How many rows are in the resultset? That looks like it's just tried to
allocate something in the order of 400MB!)
i use Zend_Db_Table_Abstract and this error occurs when i call
fetchAll():
Fatal error: Out of memory (allocated 4718592) (tried to allocate
4294967294 bytes) in
/home/aljosa/[...]/library/Zend/Db/Statement/Mysqli.php on line 227
i guess this is probably a bug in mysqli driver but i need to use
mysqli because i have no choice.
also, if i dont use set_charset('utf8') on link i just get blank page.
anybody knows what could i do? any ideas how to fix this?
Aljosa
# connection
$db = Zend_Db::factory(
'MYSQLI',
array(
'host' => 'localhost',
'username' => 'user',
'password' => 'pass',
'dbname' => 'db'
)
);
$link =& $db->getConnection();
$link->set_charset('utf8');
Zend_Db_Table_Abstract::setDefaultAdapter($db);
# news table
class News extends Zend_Db_Table_Abstract {
protected $_name = 'news';
}
# part where it breaks
$news_tbl = new News();
$itms = $news_tbl->fetchAll();
--
Simon Mundy | Director | PEPTOLAB
""" " "" """""" "" "" """"""" " "" """"" " """"" " """""" "" "
202/258 Flinders Lane | Melbourne | Victoria | Australia | 3000
Voice +61 (0) 3 9654 4324 | Mobile 0438 046 061 | Fax +61 (0) 3 9654
4124
http://www.peptolab.com