SQLSTATE[HY000]: General error: 144

Support & Bugs
1

Hello every body
yesterday, my server were unable to log me on the administration board fo my piwik site
This morning, when i try to log me in the administration site I get this message :

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

i can’t login anywhere !!

what must I do ?

thank you for any idea

friendly
paul

2

manual repair

3

hi Anthon
manual repair
ok
but how ? could you give me more details ?

4

using phpmyadmin for example, run the query REPAIR TABLE piwik_archive_numeric_2011_08

see MySQL :: MySQL 5.7 Reference Manual :: 13.7.2.5 REPAIR TABLE Syntax

5

ah !
ok ! thank you Matt.
I’ll do it

6

Hi,

I am having a similar problem
SQLSTATE[HY000]: General error: 144 Table ‘./newsoftw_piwik/piwik_archive_blob_2011_12’ is marked as crashed and last (automatic?) repair failed

But my problem is a little bit different since piwik_archive_blob_2011_12 doesn’t exist. If I look at the database using phpmyadmin, I can’t see the table piwik_archive_blob_2011_12, I can see some other like newsoftw_piwik.piwik_archive_blob_2011_08, but that the one that is supposed to have a problem.

What can I do to fix this?

Thanks,

Olivier

7

Anybody with similar problem?
It was working fine before, not anymore.

I’ll have to switch to something else? :frowning: