sieg01
March 12, 2013, 12:06pm
#1
Upgrading from 1.9x to 1.11.1
Following message is shown:
Kritischer Fehler während der Aktualisierung:
/var/www/hp/piwik/core/Updates/1.10.2-b1.php:
Error trying to execute the query ‘ALTER TABLE piwik_report ADD COLUMN hour tinyint NOT NULL default 0 AFTER period’.
The error was: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db.piwik_report’ doesn’t exist
What is the next step to solve this?
sieg01
March 12, 2013, 6:01pm
#2
I created the missing table “report” and added the columns “period” and “hour” as well as “keep_url_fragment” within table “site” (after group).
Now when I login I get:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘idsite’ in ‘from clause’
halfdan
(Fabian Becker)
March 12, 2013, 7:53pm
#3
Can you delete the table again and try to recreate it using the following command:
CREATE TABLE IF NOT EXISTS `piwik_report` (
`idreport` int(11) NOT NULL AUTO_INCREMENT,
`idsite` int(11) NOT NULL,
`login` varchar(100) NOT NULL,
`description` varchar(255) NOT NULL,
`period` varchar(10) NOT NULL,
`hour` tinyint(4) NOT NULL DEFAULT '0',
`type` varchar(10) NOT NULL,
`format` varchar(10) NOT NULL,
`reports` text NOT NULL,
`parameters` text,
`ts_created` timestamp NULL DEFAULT NULL,
`ts_last_sent` timestamp NULL DEFAULT NULL,
`deleted` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`idreport`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
halfdan
(Fabian Becker)
March 12, 2013, 7:58pm
#4
Not sure why it wasn’t created, but please try the fix I provided in the other thread.
sieg01
March 12, 2013, 8:11pm
#5
[quote=“Fabian Becker”]
Not sure why it wasn’t created, but please try the fix I provided in the other thread.[/quote]
Thank you for the helping hand!
It works now - after I ran your sql command
sieg01
March 12, 2013, 8:15pm
#6
Yust exploring the latest version and it is great!
A major step to walk w/o flash.
Thank you for this great advancement.