views:

40

answers:

0

Hello,

the full error is "Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared"

It occurs only on our unit tests server, but not on all run (it run tests every hour), and not on all test wich use database. We only have 111 PHPunit tests. The test server is a Linux Centos5 with PHP 5.2.10, and we use Zend Framework 1.10.0.

Here is the ini configuration

resources.db.adapter = "MYSQLI"
resources.db.params.host = "localhost"
resources.db.params.username = "root"
resources.db.params.password = ""
resources.db.params.dbname = "DB_UNITTESTS"
resources.db.params.date_format = "YYYY-MM-ddTHH:mm:ss"
resources.db.params.charset = "UTF8"
resources.db.isDefaultTableAdapter = true

Here is the call stack

/shares/ZendFramework/1.10.0/Zend/Db/Statement.php:300 /shares/ZendFramework/1.10.0/Zend/Db/Adapter/Abstract.php:468 /shares/ZendFramework/1.10.0/Zend/Db/Select.php:686 /shares/applications/VOOZANOO4/library/Resource/XML/VarSet.php:145 ...

and here is the code

$oSelect = Zend_Db_Table::getDefaultAdapter()
->select()
->from($table)
->where('name = ?', $name);
$aRecordSet = $oSelect->query()->fetchAll();

We mainly use the query() method.

How can I understand and solve this problem?
Thanks for your help and advices
Cédric