1.11.1 - upgrade issue .piwik_report missing

Support & Bugs
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?

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’

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;
4

Not sure why it wasn’t created, but please try the fix I provided in the other thread.

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 :slight_smile:

6

Yust exploring the latest version and it is great!
A major step to walk w/o flash.

Thank you for this great advancement.