Hi!
I have a little problem with exception message.
For example I got this:
exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[22P02]:
Invalid text representation: 7 ERROR: invalid input syntax for
integer: ""' in /mnt/ware/PRIVAT/PROJECTS/sa
Stack trace:
#0 /mnt/ware/PRIVAT/PROJECTS/saycms_on_php/lib/Zend/Db/Statement.php(283):
Zend_Db_Statement_Pdo->_execute(Array)
#1
/mnt/ware/PRIVAT/PROJECTS/saycms_on_php/lib/Zend/Db/Adapter/Abstract.php(430):
Zend_Db_Statement->execute(Array)
#2
/mnt/ware/PRIVAT/PROJECTS/saycms_on_php/lib/Zend/Db/Adapter/Pdo/Abstract.php(220):
Zend_Db_Adapter_Abstract->query('INSERT INTO "ml...', Array)
#3
/mnt/ware/PRIVAT/PROJECTS/saycms_on_php/lib/Zend/Db/Adapter/Abstract.php(508):
Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO "ml...', Array)
#4 /mnt/ware/PRIVAT/PROJECTS/saycms_on_php/lib/Zend/Db/Table/Abstract.php(924):
Zend_Db_Adapter_Abstract->insert('ml_t_moviespers...', Array)
#5
/mnt/ware/PRIVAT/PROJECTS/saycms_on_php/app/controllers/MovieslibraryController.php(247):
Zend_Db_Table_Abstract->insert(Array)
#6 /mnt/ware/PRIVAT/PROJECTS/saycms_on_php/lib/Zend/Controller/Action.php(503):
MoviesLibraryController->addmoviesAction()
#7
/mnt/ware/PRIVAT/PROJECTS/saycms_on_php/lib/Zend/Controller/Dispatcher/Standard.php(285):
Zend_Controller_Action->dispatch('addmoviesAction')
#8 /mnt/ware/PRIVAT/PROJECTS/saycms_on_php/lib/Zend/Controller/Front.php(934):
Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http),
Object(Zend_Cont
#9 /mnt/ware/PRIVAT/PROJECTS/saycms_on_php/htdocs/index.php(37):
Zend_Controller_Front->dispatch()
#10 {main}
It1s beautyful and shine but the point is this: "query('INSERT INTO
"ml...', Array)" I know something is wrong in my code. But in that
method I do more than 20 insert into different table. Every table has
"ml_t_" prefix. So, this message isn't helpful in this case.
My question is: how can I set the php os pdo extension for longer
messages. In this case If could see the all query I can find the error
fast enough.
I haven't got any special extension, for example suhosin.
Many thanks for the help!
András
--
- -
-- Csanyi Andras -- http://sayusi.hu -- Sayusi Ando
-- "Bízzál Istenben és tartsd szárazon a puskaport!".-- Cromwell
