2010年7月8日星期四

[fw-db] Zend_DB error : Mysqli statement execute error : Prepared statement needs to be re-prepared

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
--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/Zend-DB-error-Mysqli-statement-execute-error-Prepared-statement-needs-to-be-re-prepared-tp2282400p2282400.html
Sent from the Zend DB mailing list archive at Nabble.com.

没有评论: