Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Piwik installation fails in Database setup step #1076

Closed
anonymous-matomo-user opened this issue Dec 14, 2009 · 2 comments
Closed

Piwik installation fails in Database setup step #1076

anonymous-matomo-user opened this issue Dec 14, 2009 · 2 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Milestone

Comments

@anonymous-matomo-user
Copy link

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-matomo-user
Copy link
Author

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

@robocoder
Copy link
Contributor

Please upgrade to the latest version of Piwik.

@anonymous-matomo-user anonymous-matomo-user added this to the Piwik 0.5.2 milestone Jul 8, 2014
@mattab mattab added the wontfix label Aug 3, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Projects
None yet
Development

No branches or pull requests

3 participants