Update from 1.11 to 2.0: 1146 table missing

Support & Bugs
1

Just upgrading and following message is shown:

/var/www/hp/piwik/core/Updates/2.0-a7.php:
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

2

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!

3

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

sieg01