Piwik 1.7 | Update | Error: SQLSTATE[42S22]


Hello, after updating Piwik 1.6 we cannot create or edit an Email Report because there is a problem with some table showing the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘aggregate_reports_format’ in ‘field list’

So I thought it would be better to have a new installation with new tables and import the old data.

What would be the best way for my solution ?

(Matthieu Aubry) #2

This column should have been created during the upgrade.

Run the queries manually using phpmyadmin for example

ALTER TABLE piwik_pdf ADD COLUMN `aggregate_reports_format` TINYINT(1) NOT NULL AFTER `reports`

UPDATE piwik_pdf SET `aggregate_reports_format` = 1


It worked adding that column using phpMyAdmin, but comparing to a new installation one, I considered to create the column after “format” instead of placing it after column “reports”. Thanks !