[Piwik-hackers] MySQL Version

[Matthieu Aubry]

Indeed piwik requires mysql 4.1
It would be better to warn you during the installation.
I've created a ticket http://dev.piwik.org/trac/ticket/198

Tobias Neumann wrote:
> This is Mysql > 4 but smaller than MySQL < 4.1 (i do not know the
> exact version because i  have no access). The database connection
> settings are correct because with the same user, password and
> databases run a blog system on this server.
>
> The error was following:
>
> Uncaught exception: 'SQLSTATE[42000]: Syntax error or access
> violation: 1064 You have an error in your SQL syntax. Check the manual
> that corresponds to your MySQL server version for the right syntax to
> use near 'CURRENT_TIMESTAMP, PRIMARY KEY(login), UNIQUE I'
> More information
>
> In PATH_FROM_ROOT/stats/libs/Zend/Db/Statement/Pdo.php on line 227
> Backtrace:
>
> #0 PATH_FROM_ROOT/stats/libs/Zend/Db/Statement.php(298):
> Zend_Db_Statement_Pdo->_execute(Array)
> #1 PATH_FROM_ROOT/stats/libs/Zend/Db/Adapter/Abstract.php(262):
> Zend_Db_Statement->execute(Array)
> #2 PATH_FROM_ROOT/stats/libs/Zend/Db/Adapter/Pdo/Abstract.php(206):
> Zend_Db_Adapter_Abstract->query('CREATE TABLE pi...', Array)
> #3 PATH_FROM_ROOT/stats/modules/Piwik.php(946):
> Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE pi...')
> #4 PATH_FROM_ROOT/stats/plugins/Installation/Controller.php(192):
> Piwik::createTables()
> #5 PATH_FROM_ROOT/stats/plugins/Installation/Installation.php(66):
> Piwik_Installation_Controller->tablesCreation()
> #6 [internal function]:
> Piwik_Installation->startInstallation(Object(Event_Notification))
> #7 PATH_FROM_ROOT/stats/libs/Event/Dispatcher.php(214):
> call_user_func_array(Array, Array)
> #8 PATH_FROM_ROOT/stats/modules/PluginsManager.php(396):
> Event_Dispatcher->addObserver(Array, 'FrontController...')
> #9 PATH_FROM_ROOT/stats/modules/PluginsManager.php(314):
> Piwik_PluginsManager->addPluginObservers(Object(Piwik_Installation))
> #10 PATH_FROM_ROOT/stats/modules/PluginsManager.php(240):
> Piwik_PluginsManager->loadPlugins()
> #11 PATH_FROM_ROOT/stats/modules/Piwik.php(362):
> Piwik_PluginsManager->setPluginsToLoad(Array)
> #12 PATH_FROM_ROOT/stats/modules/FrontController.php(309): Piwik::loadPlugins()
> #13 PATH_FROM_ROOT/stats/index.php(55): Piwik_FrontController->init()
> #14 {main}
>
>
> You can get help from http://piwik.org (give us the full error message
> + your PHP and Mysql version)
>
> And this exception raised another exception "No entry is registered
> for key 'logger_exception'"
>
>
>
> 2008/4/16, Matthieu Aubry <matthieu.aubry at gmail.com>:
>   
>> piwik should work well with mysql > 4.1
>>  what was the error exactly?
>>
>>
>>  Tobias Neumann wrote:
>>  > Hello,
>>  > which minimal mysql version is required for piwik?
>>  >
>>  > I installed this lokal and on a root server with mysql 5 with no
>>  > problems. Than I have got another Server with mysql 4.x and their i
>>  > can't run the install process.
>>  >
>>  > regards
>>
>>     
>>> _______________________________________________
>>>       
>>  > Piwik-hackers mailing list
>>  > Piwik-hackers at piwik.org
>>  > http://lists.piwik.org/cgi-bin/mailman/listinfo/piwik-hackers
>>  >
>>  >
>>  _______________________________________________
>>  Piwik-hackers mailing list
>>  Piwik-hackers at piwik.org
>>  http://lists.piwik.org/cgi-bin/mailman/listinfo/piwik-hackers
>>
>>     
> _______________________________________________
> Piwik-hackers mailing list
> Piwik-hackers at piwik.org
> http://lists.piwik.org/cgi-bin/mailman/listinfo/piwik-hackers
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.piwik.org/pipermail/piwik-hackers/attachments/20080416/13dea404/attachment.htm