Re: [fw-general] Select Problem

[Simon Mundy]

I think it's a known bug with Mysqli/PHP - try MEDIUMTEXT instead?
Hey all,

i have a problem selecting from database

here is my function :

    public function wordCVsList($Starting_id = 0, $limit = 2) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $this->getAdapter()->select();
        $select->from(array('w' => 'word_cvs'),
        array('word_cv_id'));
        $select->limit($limit, $Starting_id);
            echo $select;
        return $db->query($select)->fetchAll();
    }


when i call it i get this error :

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried  
to allocate 4294967296 bytes) in /Library/WebServer/Documents/cha/ 
library/Zend/Db/Statement/Mysqli.php on line 227



note : there is a field in the same table with LONGTEXT type
when i edit the type and make it VARCHAR the error is gone.

i don't understand why, i am selecting only the id field, why the  
memory is gone.

can anyone help please ?


--
Ahmed Abdel-Aliem

--

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