Piwik installations failed with undefined offset error

Support & Bugs
1

Hi,

I’ve tried to install Piwik 1.9.2 , but I keep getting an error “Undefined offset” at Database Setup:

Undefined offset: 0
in ‘/www/htdocs/k007xxxx/analyse/core/Db/Adapter/Pdo/Mysql.php’ at the line 168

#0 Piwik_ErrorHandler(…) called at [/www/htdocs/k007xxxx/analyse/core/Db/Adapter/Pdo/Mysql.php:168]
#1 Piwik_Db_Adapter_Pdo_Mysql->isConnectionUTF8(…) called at

[/www/htdocs/k007xxxx/analyse/core/Piwik.php:2071]
#2 Piwik::isDatabaseConnectionUTF8(…) called at

[/www/htdocs/k007xxxx/analyse/plugins/Installation/Controller.php:240]
#3 Piwik_Installation_Controller->databaseCheck(…) called at

[/www/htdocs/k007xxxx/analyse/plugins/Installation/Installation.php:75]
#4 Piwik_Installation->dispatch(…) called at [:]
#5 call_user_func_array(…) called at [/www/htdocs/k007xxxx/analyse/libs/Event/Dispatcher.php:213]
#6 Event_Dispatcher->addObserver(…) called at [/www/htdocs/k007xxxx/analyse/core/PluginsManager.php:545]
#7 Piwik_PluginsManager->addPluginObservers(…) called at

[/www/htdocs/k007xxxx/analyse/core/PluginsManager.php:407]
#8 Piwik_PluginsManager->reloadPlugins(…) called at

[/www/htdocs/k007xxxx/analyse/core/PluginsManager.php:290]
#9 Piwik_PluginsManager->loadPlugins(…) called at

[/www/htdocs/k007xxxx/analyse/core/FrontController.php:267]
#10 Piwik_FrontController->init(…) called at [/www/htdocs/k007xxxx/analyse/index.php:52]

Any suggestions to solve the problems? Thanks in advance.

Lunablu

2

Thanks for the bug report: fixed in: http://dev.piwik.org/trac/changeset#file0

3

Thanks for the quick response, but I get the following error:

SQLSTATE[HY000] [1193] Unknown system variable ‘NAMES’

4

what version of mysql are you using? please try upgrading