CiviCRM Community Forums (archive)

My apologies, it seems mysql.php line 383 is not blank. It's in the middle fo the following function (highlighted in red):

function fetchInto($result, &$arr, $fetchmode, $rownum = null)
    {
        if ($rownum !== null) {
            if (!@mysql_data_seek($result, $rownum)) {
                return null;
            }
        }
        if ($fetchmode & DB_FETCHMODE_ASSOC) {
            $arr = @mysql_fetch_array($result, MYSQL_ASSOC);
            if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE && $arr) {
                $arr = array_change_key_case($arr, CASE_LOWER);
            }
        } else {
            $arr = @mysql_fetch_row($result);
        }
        if (!$arr) {
            return null;
        }
        if ($this->options['portability'] & DB_PORTABILITY_RTRIM) {
            /*
             * Even though this DBMS already trims output, we do this because
             * a field might have intentional whitespace at the end that
             * gets removed by DB_PORTABILITY_RTRIM under another driver.
             */
            $this->_rtrimArrayValues($arr);
        }
        if ($this->options['portability'] & DB_PORTABILITY_NULL_TO_EMPTY) {
            $this->_convertNullArrayValuesToEmpty($arr);
        }
        return DB_OK;
    }

I've compared and this section of code isn't any different from the previous version of CiviCRM I was using (2.1.4), which exported just fine. Somewhere along the way it seems a large memory leak is occurring, causing all but the smallest of queries to blow up. Other than the error message about the line above though I don't have much else to go on as that error is the only thing that appears on a clear white page when the export fails.

I'd be thankful for any help on this. Being unable to export any data is a pretty serious problem, to say the least.

UPDATE: It seems this problem only occurs with searches involving tags. If I run a search to export contacts from several groups there are no problems with it, even if the number of contacts is 800+. Run a search on tags though and seemingly an query with more than 80 results seems to throw the 'out of memory' error.

Hi Donald, thanks for replying.

1. The tags aren't arranged in any hierarachal structure. It's just a plain list of tags. There are about 15 of them.

2. Database is just under 4MB

3. Couldn't reproduce it on the demo, but that's also not possible because the demo doesn't have enough data in it. Even selecting every tag it only returns about 40 results, a size which my current installation can also handle. It's only when there are over about 80 tagged results that the export goes wrong.

4. Yeah, I think so. I'll find you on the channel.