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