Update from 1.11 to 2.0: 1146 table missing

Just upgrading and following message is shown:

Error trying to execute the query ‘ALTER TABLE piwik_logger_message ADD COLUMN tag VARCHAR(50) NULL AFTER idlogger_message’.
The error was: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db.piwik_logger_message’ doesn’t exist

An SQL-command would help :wink:
Like last time. 301 Moved Permanently

Thank you and winterly greetings

I created the table by hand.

CREATE TABLE piwik_logger_message (idlogger_message INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,PRIMARY KEY(idlogger_message))

After that i restart the upgrade process and he show me a similar message, there was no timestamp filed and then i created a new timestamp field and it works now for me with this statemant:

ALTER TABLE  `piwik_logger_message` ADD  `timestamp` TIMESTAMP NOT NULL ;

i hope i could help you!

Yes you could! These 2 commands did the necessary job to make Piwik running again.
I thank you for this.