Arch Linux

hsz

Member

Registered: 2009-09-25

Posts: 30

[SOLVED] PHP 5.3 and MySQLi problem due insert/update

Hello !

Today after an upgrade of php package to 5.3.0-3 version my projects crashed.
I get following error

Mysqli statement execute error : No data supplied for parameters in prepared statement

#0 /srv/http/projects/Zend_Framework/ZendFramework-1.7.6-minimal/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /srv/http/projects/Zend_Framework/ZendFramework-1.7.6-minimal/library/Zend/Db/Adapter/Abstract.php(433): Zend_Db_Statement->execute(Array)
#2 /srv/http/projects/hsz/lib/Cms/Db/Table/Abstract.php(176): Zend_Db_Adapter_Abstract->query('UPDATE _seq_cat SET id = 3', 8)

every time I try to INSERT or UPDATE any MySQL table.

How to fix it ? I do not have any idea.
Currently installed php/mysql packages:

~ $  pacman -Q | grep mysql
libmysqlclient 5.1.38-1
mysql-clients 5.1.38-1
mysql-gui-tools 5.0r14-3
mysql-workbench 5.1.18-1
~ $  pacman -Q | grep php
php 5.3.0-3
php-apache 5.3.0-3
php-zend-debugger 5.2.15-1
phpmyadmin 3.2.2-1

Some configuration fragments:

~ $  cat /etc/php/php.ini | grep mysql | grep extension
extension=mysql.so
extension=mysqli.so
extension=pdo_mysql.so

~ $  cat /etc/php/php.ini | grep extension_dir
extension_dir = "/usr/lib/php/20060613/"

~ $  ls -la /usr/lib/php/20060613/ | grep mysql
lrwxrwxrwx 1 root root     19 09-25 16:55 mysql.so -> ../modules/mysql.so
lrwxrwxrwx 1 root root     20 09-25 16:55 mysqli.so -> ../modules/mysqli.so
lrwxrwxrwx 1 root root     23 09-25 16:55 pdo_mysql.so -> ../modules/pdo_mysql.so

Could anyone help me with this problem ? I need to get this thing done as soon as possible.

Thanks !
hsz

Last edited by hsz (2009-09-26 11:06:10)

hsz

Member

Registered: 2009-09-25

Posts: 30

Re: [SOLVED] PHP 5.3 and MySQLi problem due insert/update

Solution is silly - i upgraded Zend Framework to 1.9.3 patch 1 version.
In change log we can see:

* PHP 5.3 compatibility, including support for new features in the
  mysqli extension. All components are fully tested on both PHP 5.2.x
  and PHP 5.3.0.

Available since 23 sep - so just in time.

hsz