Re: [fw-db] Out of memory error

Why you using getAdapter() method? Try to use $db->fetchAll($sqlxx);
instead.

Alex.

----- Original Message -----
From: "monk.e.boy" <john.glazebrook@guava.com>
To: <fw-db@lists.zend.com>
Sent: Wednesday, August 27, 2008 1:56 AM
Subject: Re: [fw-db] Out of memory error

>
> Hi,
>
> Has anyone else got this error?
>
> Does anyone know where I should look to fix it? Is it a bug in the DB
> Adapter?
>
> Thankx
>
> monk.e.boy
>
>
>
> monk.e.boy wrote:
>>
>> Hi,
>>
>> I run this:
>>
>> $sqlxx = <<<EOT
>> SELECT
>> FORMAT(seconds_to_download,2) as secs
>> FROM page
>> EOT;
>>
>> $db = $this->getAdapter();
>> return $db->fetchAll( $sqlxx );
>>
>> And I get:
>>
>> Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to
>> allocate 1431655772 bytes) in
>> /usr/local/lib/php/Zend/Db/Statement/Mysqli.php on line 254
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/Out-of-memory-error-tp19108319p19163705.html
> Sent from the Zend DB mailing list archive at Nabble.com.
>
>
> __________ Èíôîðìàöèÿ îò ESET NOD32 Antivirus, âåðñèÿ áàçû äàííûõ ñèãíàòóð
> âèðóñîâ 3389 (20080826) __________
>
> Ñîîáùåíèå ïðîâåðåíî ïðîãðàììîé ESET NOD32 Antivirus.
>
> http://www.esetnod32.ru
>
>