Error installer: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]


(wavetraxx) #1

Hi,

i made many piwik installations without problems. But at my newest project i have an error after step 3. Error in line 204 in file Mysqli.php.

Piwik Version 0.4.5
PHP Version 5.2.6
Mysql 5.0.68

At line 204 is:

           
#201 call_user_func_array(
#202 array($this->_stmt, 'bind_param'),
#203 $stmtParams
#204 );
#205 }

THis is the error:

mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters in prepared statement 
in '/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/libs/Zend/Db/Statement/Mysqli.php' at the line 204

#0  Piwik_ErrorHandler(2, mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters in prepared statement, /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/libs/Zend/Db/Statement/Mysqli.php, 204, Array ([params] => Array ([0] => ssss,[1] => version_core,[2] => 0.4.5,[3] => 1,[4] => 0.4.5),[stmtParams] => Array ([0] => ssss,[1] => version_core,[2] => 0.4.5,[3] => 1,[4] => 0.4.5),[value] => 0.4.5,[k] => 4))
#1  mysqli_stmt->bind_param(ssss, version_core, 0.4.5, 1, 0.4.5)
#2  call_user_func_array(Array ([0] => mysqli_stmt Object (),[1] => bind_param), Array ([0] => ssss,[1] => version_core,[2] => 0.4.5,[3] => 1,[4] => 0.4.5)) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/libs/Zend/Db/Statement/Mysqli.php:204]
#3  Zend_Db_Statement_Mysqli->_execute(Array ([0] => version_core,[1] => 0.4.5,[2] => 1,[3] => 0.4.5)) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/libs/Zend/Db/Statement.php:300]
#4  Zend_Db_Statement->execute(Array ([0] => version_core,[1] => 0.4.5,[2] => 1,[3] => 0.4.5)) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/libs/Zend/Db/Adapter/Abstract.php:468]
#5  Zend_Db_Adapter_Abstract->query(INSERT INTO `piwik2_option` (option_name, option_value, autoload)  VALUES (?, ?, ?)  ON DUPLICATE KEY UPDATE option_value = ?, Array ([0] => version_core,[1] => 0.4.5,[2] => 1,[3] => 0.4.5)) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/PluginsFunctions/Sql.php:37]
#6  Piwik_Query(INSERT INTO `piwik2_option` (option_name, option_value, autoload)  VALUES (?, ?, ?)  ON DUPLICATE KEY UPDATE option_value = ?, Array ([0] => version_core,[1] => 0.4.5,[2] => 1,[3] => 0.4.5)) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/Option.php:80]
#7  Piwik_Option->set(version_core, 0.4.5, 1) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/Option.php:109]
#8  Piwik_SetOption(version_core, 0.4.5, 1) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/Updater.php:64]
#9  Piwik_Updater->recordComponentSuccessfullyUpdated(core, 0.4.5) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/plugins/Installation/Controller.php:238]
#10 Piwik_Installation_Controller->tablesCreation() called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/plugins/Installation/Installation.php:62]
#11 Piwik_Installation->dispatch(Piwik_Event_Notification Object ([_notificationName] => FrontController.NoConfigurationFile,[_notificationObject] => Exception Object ([] => The configuration file /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/config/config.ini.php has not been found.,[] => ,[] => 0,[] => /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/Config.php,[] => 110,[] => Array ([0] => Array ([file] => /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/Piwik.php,[line] => 1574,[function] => init,[class] => Piwik_Config,[type] => ->,[args] => Array ()),[1] => Array ([file] => /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/FrontController.php,[line] => 202,[function] => createConfigObject,[class] => Piwik,[type] => ::,[args] => Array ()),[2] => Array ([file] => /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/index.php,[line] => 90,[function] => init,[class] => Piwik_FrontController,[type] => ->,[args] => Array ()))),[_notificationInfo] => Array (),[_notificationState] => 0,[_notificationCount] => 0))
#12 call_user_func_array(Array ([0] => Piwik_Installation Object ([] => Piwik_Installation_Controller),[1] => dispatch), Array ([0] => Piwik_Event_Notification Object ([_notificationName] => FrontController.NoConfigurationFile,[_notificationObject] => Exception Object ([] => The configuration file /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/config/config.ini.php has not been found.,[] => ,[] => 0,[] => /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/Config.php,[] => 110,[] => Array ([0] => Array ([file] => /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/Piwik.php,[line] => 1574,[function] => init,[class] => Piwik_Config,[type] => ->,[args] => Array ()),[1] => Array ([file] => /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/FrontController.php,[line] => 202,[function] => createConfigObject,[class] => Piwik,[type] => ::,[args] => Array ()),[2] => Array ([file] => /home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/index.php,[line] => 90,[function] => init,[class] => Piwik_FrontController,[type] => ->,[args] => Array ()))),[_notificationInfo] => Array (),[_notificationState] => 0,[_notificationCount] => 0))) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/libs/Event/Dispatcher.php:213]
#13 Event_Dispatcher->addObserver(Array ([0] => Piwik_Installation Object ([] => Piwik_Installation_Controller),[1] => dispatch), FrontController.NoConfigurationFile) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/PluginsManager.php:363]
#14 Piwik_PluginsManager->addPluginObservers(Piwik_Installation Object ([] => Piwik_Installation_Controller)) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/PluginsManager.php:250]
#15 Piwik_PluginsManager->loadPlugins() called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/PluginsManager.php:165]
#16 Piwik_PluginsManager->setPluginsToLoad(Array ([0] => CorePluginsAdmin,[1] => CoreAdminHome,[2] => CoreHome,[3] => API,[4] => Widgetize,[5] => LanguagesManager,[6] => Actions,[7] => Dashboard,[8] => Referers,[9] => UserSettings,[10] => UserCountry,[11] => VisitsSummary,[12] => VisitFrequency,[13] => VisitTime,[14] => VisitorInterest,[15] => ExampleAPI,[16] => ExamplePlugin,[17] => ExampleRssWidget,[18] => ExampleFeedburner,[19] => ExampleRssWidget,[20] => Provider,[21] => Feedback,[22] => Login,[23] => UsersManager,[24] => SitesManager,[25] => Installation)) called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/core/FrontController.php:209]
#17 Piwik_FrontController->init() called at [/home/httpd/vhosts/froidevauxsportfotos.com/httpdocs/piwik/index.php:90]

Everyone can help me?


(vipsoft) #2

Sounds like an incompatible libmysql version.


(wavetraxx) #3

hi,

thats a problem from the websitehoster?

greetings


(vipsoft) #4

Depends whether it’s a standard distro or not.

If pdo mysql isn’t an option, ask the webhost to update libmysql. If they have to recompile it, ask that they build --with-charset=utf8 while they’re at it.