I tried to upgrade to piwik 0.4 and things did not go well. Everything was fine before I tried this. I had to do a manual install because no amount of CHMOD changes were working with the automatic update. I downloaded piwik 0.4 and uploaded and now this is what I have. www.lovethesecurves.com/piwik
please help. thank you in advance.
the dash board works except for the bar graph but some of the other pages don’t work at all like visitors overview.
Open Flash Chart
JSON Parse Error [Syntax Error]
Error at character 0, line 1:
0:
that is the error I am getting even after update.
also in different browsers I see this
Open Flash Chart
IO ERROR
Loading test data
Error #2032
Your database appears to have some bad data on June 7, 2009. Any date range excluding that date appears to work (e.g., 2009-01-01,2009-06-06 or 2009-06-08,2009-06-25).
http://www.lovethesecurves.com/piwik/index.php?module=API&method=VisitsSummary.get&idSite=1&period=day&date=2009-06-07,2009-06-07&format=Html&token_auth=anonymous
If you want to keep this private, send an email to hello (at) piwik.org with the following info:
Assuming your tables are prefixed by “piwik_”, run this query:
SELECT * FROM piwik_log_visit WHERE visit_server_date = '2009-06-07';
Then try repairing (and then optimizing) your database:
mysqlcheck -r your_database
mysqlcheck -o your_database
[quote=vipsoft @ Jun 25 2009, 04:09 PM]Your database appears to have some bad data on June 7, 2009. Any date range excluding that date appears to work (e.g., 2009-01-01,2009-06-06 or 2009-06-08,2009-06-25).
http://www.lovethesecurves.com/piwik/index.php?module=API&method=VisitsSummary.get&idSite=1&period=day&date=2009-06-07,2009-06-07&format=Html&token_auth=anonymous
If you want to keep this private, send an email to hello (at) piwik.org with the following info:
Assuming your tables are prefixed by “piwik_”, run this query:
SELECT * FROM piwik_log_visit WHERE visit_server_date = '2009-06-07';
Then try repairing (and then optimizing) your database:
mysqlcheck -r your_database
mysqlcheck -o your_database[/quote]
the repair and check both showed that everything was good. I don’t get it. as a test I deleted all the data from the above day and my graph started working. hummm… There must be 1 entry from that day that is wrong. How can I find it. I have 927 entrys thats a lot to look through by hand.
That’s assuming there’s only a single bad entry…
Theoretically, using divide and conquer, you can isolate it in about 10 iterations. However, if there’s more than one…
This should export the rows into a tab delimited text file. You’re welcome to troubleshoot it or send it to us for further investigation.
SELECT * INTO OUTFILE 'filename' FROM piwik_log_visit WHERE visit_server_date = '2009-06-07';