Incorrect arguments to mysql_stmt_execute'

With version 1.3 I’m still having problems with MySQLi exceptions that prevent installation (see earlier post when trying version 1.2.1). I get the following error after I submit the configuration form presented during the installation procedure:

Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Incorrect arguments to mysql_stmt_execute' in /data/18/0/140/114/792603/user/812185/htdocs/dr/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /data/18/0/140/114/792603/user/812185/htdocs/dr/application/libraries/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /data/18/0/140/114/792603/user/812185/htdocs/dr/application/libraries/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /data/18/0/140/114/792603/user/812185/htdocs/dr/application/libraries/Omeka/Db.php(82): Zend_Db_Adapter_Abstract->query('? INSERT...', Array)
#3 [internal function]: Omeka_Db->__call(Array, Array)
#4 /data/18/0/140/114/792603/user/812185/htdocs/dr/application/libraries/Omeka/Db.php(284): Omeka_Db->query('query', Array)
#5 /data/18/0/140/114/792603/user/812185/htdocs/dr/application/libraries/Omeka/Db.php(254): Omeka_Db->exec('? INSERT...', Array)
#6 /dat in /data/18/0/140/114/792603/user/812185/htdocs/dr/application/libraries/Zend/Db/Statement/Mysqli.php on line 214

Inspection of the database revealed that only 21 of the tables were created. I’ve cleared the database (dropped all of the tables) and tried re-installing but the results are the same. My hosting provider (Network Solutions) is running Apache 2.2.14 with MySQL 5.0.89 with PHP 5.2.13. Any help would be greatly appreciated.

Thank you.


Your problems seem like they're potentially a symptom of your PHP MySQL connection not talking correctly to the MySQL server, or some incompatibility with Zend's database code.

Are you sure these are the most up-to-date versions that your host provides?

In particular, Network Solutions says here that they run MySQL version 5.1.

I just checked with Network Solutions and their support personnel verified that they are not yet up on ver. 5.1. (I pointed out the article you cited and they will correct it.) MySQL ver. 5.0.89 is their latest and it has been working fine with my other applications including Semantic MediaWiki, Mantis, Joomla and various other CMS packages.

Any other thoughts on places to look or things to try?


P.S. Here is a link to a copy of a phpMyAdmin session showing which tables were created: