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?