I’m on Amazon EC2.
My server went down for about an hour this afternoon and in bringing it back up, I had to restore from a backup taken about 3 hours earlier, late in the morning.
When opening up my Piwik dashboard, I see that all widgets with information for today are now broken with the message:
Mysqli prepare error: Table ‘./piwik/piwik_log_visit’ is marked as crashed and last (automatic?) repair failed
And there’s a backtrace with each widget.
If I change the date range to yesterday (April 29), everything in the dashboard works fine except the Visitors in Real Time widget, since it still wants today’s log.