Skip to content


Subversion checkout URL

You can clone with
Download ZIP


SQL errors on new install #809

anonymous-piwik-user opened this Issue · 6 comments

2 participants


I install Piwik on Windows / Apache connecting to a CentOS / Mysql 5.0 backend. The install worked fine but the dashboard shows SQL errors because there is no archived data it seems.

The error comes from core/archive/array/IndexedByDate.php in the function getDataTableFromNumeric(). It seems that $archive->getIdArchive(); is returning null and causing a query that looks like this

SELECT value, name, UNIX_TIMESTAMP(date1) as timestamp FROM piwik_archive_numeric_2009_06 WHERE idarchive IN ( ) AND name IN ( 'nb_visits' );

ERROR 1064 (42000): 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 ') AND name IN ( 'nb_visits' )' at line 1


Attachment: Screen shot of the dashboard


Can you grab a snapshot from svn, and run tests/all_tests.php for your set-up?


Also, what are your versions of Apache, PHP, and MySQL? (major.minor.revision)


Unable to reproduce. Could this be a timezone mismatch between PHP on the Windows/Apache server and the Centos/MySQL server?


(In [1268]) Quick fixes #809 - guard against empty archive ID list


(In [1323]) refs #809 - alternate fix

@anonymous-piwik-user anonymous-piwik-user added this to the Piwik 0.4.2 milestone
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.