SQL general Error 144 with tables piwik_archive_numeric_xx crashed & repair failed

Support & Bugs
1

Hi,

since last update i get into the dashboards of all websites into the last-visitors-graph widget and target-overflow widget the followed errors:

SQLSTATE[HY000]: General error: 144 Table ‘./database_name/piwik_archive_numeric_2012_12’ is marked as crashed and last (automatic?) repair failed

with a big backtrace. How can i fix this?

2

Try mysqlcheck:
http://www.thegeekstuff.com/2011/12/mysqlcheck/
http://dev.mysql.com/doc/refman/5.1/de/mysqlcheck.html

3

Ouhh… well, that’s works. Thanks, it’s resolved :wink: