While running the database update I encountered an error.
Running from commandline and with ‘record_statistics = 0’, on a small install. (database size 7.6 Mb).
The update took about a minute and broke with:
[X] Critical Error during the update process:
Error trying to execute the query ‘ALTER TABLE
idaction_category2 INTEGER(10) UNSIGNED NOT NULL AFTER idaction_category, ADD
idaction_category3 INTEGER(10) UNSIGNED NOT NULL, ADD idaction_category4
INTEGER(10) UNSIGNED NOT NULL, ADD idaction_category5 INTEGER(10) UNSIGNED NOT
The error was: SQLSTATE[HY000]: General error: 2006 MySQL server has gone
I ran the database-update-script again and now it completed it in a second.
Piwik seems to work correctly now.
My question being:
Is it ok to rerun a update-script like this, or can I expect problems?
edit: From v1.5.1 to v1.6
edit2: better title