SQL errors on new install

[carcus88]

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

[carcus88]

Screen shot of the dashboard

[vipsoft]

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

[vipsoft]

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

[vipsoft]

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

[vipsoft]

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

[vipsoft]

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