Error: SQLSTATE[HY000]: General error: 1005 Can't create table

Support & Bugs
1

Hi,

I have used Piwik for years without any issue.

Today I have the following error message:

SQLSTATE[HY000]: General error: 1005 Can’t create table ‘mydbname.piwik_archive_blob_2013_11’ (errno: -1)

Can anyone help me fix this?

Many thanks

Lorraine

2

Maybe the table piwik_archive_blob_2013_11 already exists and is somehow corrupt? can you try to delete it and piwik will re-create it

3

Thanks Matt, but the table doesn’t exist already.