HELP ! Update fail


(superj707) #1

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.


(vipsoft) #2

Please try the 0.4.1rc1 (release candidate) on http://builds.piwik.org


(superj707) #3

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.


(superj707) #4

also in different browsers I see this

Open Flash Chart
IO ERROR
Loading test data
Error #2032


(vipsoft) #5

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


(superj707) #6

[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.


(vipsoft) #7

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';