@anonymous-piwik-user opened this issue on December 14th 2009

I am using following versions:

apache_2.2.14-win32-x86-no_ssl,

mysql-5.1.39-win32,

php-5.2.11-win32-installer

Find below the error that i am getting when trying to proceed from database setup during piwik installation:

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

Please help.

@anonymous-piwik-user commented on December 14th 2009

Attachment: error in database set up during piwik installation piwikerror.JPG

@robocoder commented on December 14th 2009

Please upgrade to the latest version of Piwik.

This issue was closed on December 14th 2009
Powered by GitHub Issue Mirror