When install,get error


(yifang) #1

i get the lastest code from svn ,when creating the tables in mysql ,I got the following errors:
the page is
http://localhost:8080/index.php?action=tab…le=Installation

Piwik # open source web analytics
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Backtrace:

#0 F:\eclipse workspace\piwik\libs\Zend\Db\Statement.php(298): Zend_Db_Statement_Pdo->_execute(Array)
#1 F:\eclipse workspace\piwik\libs\Zend\Db\Adapter\Abstract.php(269): Zend_Db_Statement->execute(Array)
#2 F:\eclipse workspace\piwik\libs\Zend\Db\Adapter\Pdo\Abstract.php(206): Zend_Db_Adapter_Abstract->query(‘CREATE TABLE pi…’, Array)
#3 F:\eclipse workspace\piwik\core\Piwik.php(1330): Zend_Db_Adapter_Pdo_Abstract->query(‘CREATE TABLE pi…’)
#4 F:\eclipse workspace\piwik\plugins\Installation\Controller.php(210): Piwik::createTables()
#5 F:\eclipse workspace\piwik\plugins\Installation\Installation.php(61): Piwik_Installation_Controller->tablesCreation()
#6 [internal function]: Piwik_Installation->startInstallation(Object(Piwik_Event_Notification))
#7 F:\eclipse workspace\piwik\libs\Event\Dispatcher.php(214): call_user_func_array(Array, Array)
#8 F:\eclipse workspace\piwik\core\PluginsManager.php(360): Event_Dispatcher->addObserver(Array, ‘FrontController…’)
#9 F:\eclipse workspace\piwik\core\PluginsManager.php(246): Piwik_PluginsManager->addPluginObservers(Object(Piwik_Installation))
#10 F:\eclipse workspace\piwik\core\PluginsManager.php(161): Piwik_PluginsManager->loadPlugins()
#11 F:\eclipse workspace\piwik\core\FrontController.php(224): Piwik_PluginsManager->setPluginsToLoad(Array)
#12 F:\eclipse workspace\piwik\index.php(48): Piwik_FrontController->init()
#13 {main}
Piwik homepage
Piwik Frequently Asked Questions
Piwik Documentation
Piwik Forums
Piwik Online Demo

the mysql version is 6.0.
thanks in advance:-)


(yifang) #2

maybe it’s the mysql which caused such errors.
I uninstall mysql 6,install mysql 5.1 solved this problem.

[quote=yifang @ Apr 19 2009, 01:52 AM]i get the lastest code from svn ,when creating the tables in mysql ,I got the following errors:
the page is
http://localhost:8080/index.php?action=tab…le=Installation

Piwik # open source web analytics
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Backtrace:

#0 F:\eclipse workspace\piwik\libs\Zend\Db\Statement.php(298): Zend_Db_Statement_Pdo->_execute(Array)
#1 F:\eclipse workspace\piwik\libs\Zend\Db\Adapter\Abstract.php(269): Zend_Db_Statement->execute(Array)
#2 F:\eclipse workspace\piwik\libs\Zend\Db\Adapter\Pdo\Abstract.php(206): Zend_Db_Adapter_Abstract->query(‘CREATE TABLE pi…’, Array)
#3 F:\eclipse workspace\piwik\core\Piwik.php(1330): Zend_Db_Adapter_Pdo_Abstract->query(‘CREATE TABLE pi…’)
#4 F:\eclipse workspace\piwik\plugins\Installation\Controller.php(210): Piwik::createTables()
#5 F:\eclipse workspace\piwik\plugins\Installation\Installation.php(61): Piwik_Installation_Controller->tablesCreation()
#6 [internal function]: Piwik_Installation->startInstallation(Object(Piwik_Event_Notification))
#7 F:\eclipse workspace\piwik\libs\Event\Dispatcher.php(214): call_user_func_array(Array, Array)
#8 F:\eclipse workspace\piwik\core\PluginsManager.php(360): Event_Dispatcher->addObserver(Array, ‘FrontController…’)
#9 F:\eclipse workspace\piwik\core\PluginsManager.php(246): Piwik_PluginsManager->addPluginObservers(Object(Piwik_Installation))
#10 F:\eclipse workspace\piwik\core\PluginsManager.php(161): Piwik_PluginsManager->loadPlugins()
#11 F:\eclipse workspace\piwik\core\FrontController.php(224): Piwik_PluginsManager->setPluginsToLoad(Array)
#12 F:\eclipse workspace\piwik\index.php(48): Piwik_FrontController->init()
#13 {main}
Piwik homepage
Piwik Frequently Asked Questions
Piwik Documentation
Piwik Forums
Piwik Online Demo

the mysql version is 6.0.
thanks in advance:-)[/quote]