@anonymous-piwik-user opened this Issue on June 17th 2009

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

@anonymous-piwik-user commented on June 17th 2009

Attachment: Screen shot of the dashboard
ScreenShot.jpg

@robocoder commented on June 18th 2009 Contributor

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

@robocoder commented on June 19th 2009 Contributor

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

@robocoder commented on July 1st 2009 Contributor

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

@robocoder commented on July 1st 2009 Contributor

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

@robocoder commented on July 23rd 2009 Contributor

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

This Issue was closed on July 23rd 2009
Powered by GitHub Issue Mirror