SQLSTATE[42S02] After Upgrade


(Lenny77) #1

I´ve upgraded my Piwik Installation from 0.2 to the latest version. The Software had also do change the database settings.

If I open now the statistics I have no problems with the last days and month, but if I try to see todays data I get the following failure message:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db0049155.piwik_log_conversion’ doesn’t exist

Is ther anybody who knows what to do?

Thanks a lot.


(vipsoft) #2

The log_conversion table was added in 0.2.27. This suggests the database update did not complete successfully within the browser or web server timeout.

If you look in core/Updates/*, you should be able to glean the SQL required to update your database manually from the command line.

p.s. we’re working on a command line script to facilitate this.
http://dev.piwik.org/trac/ticket/666


(Lenny77) #3

Thank you vipsoft for the quick reply. Unfortunately I don´t know what to do with your answer. I looked with my FTP-client in the folder core/Updates/ and I can see the mentioned 0.2.27.php. What I have to do with the file? Delete or change the content?

Sorry for my silly questions, but I have no experience in SQL databases.

[quote=vipsoft @ Jul 29 2009, 08:19 AM]The log_conversion table was added in 0.2.27. This suggests the database update did not complete successfully within the browser or web server timeout.

If you look in core/Updates/*, you should be able to glean the SQL required to update your database manually from the command line.

p.s. we’re working on a command line script to facilitate this.
http://dev.piwik.org/trac/ticket/666[/quote]


(kolchak) #4

Open the PHP file and run the SQL syntax against your SQL database.