[Piwik-hackers] MySQL Version

[Tobias Neumann]

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
>