SQLSTATE[42S22]: Column not found: 1054 Unknown column 'display_format' in 'field list'


#1

I want to add a new e-mail report in Piwik 18.2 and get the following error message:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘display_format’ in ‘field list’

Can someone give me the correct SQL-Syntax for phpmyadmin to correct the database?

Best regards!!


#2

Hope it was right - but it seems to work.

[quote=“core/updates/1.7-b1.php”]ALTER TABLE piwik_pdf ADD COLUMN aggregate_reports_format TINYINT(1) NOT NULL AFTER reports;
UPDATE piwik_pdf SET aggregate_reports_format = 1[/quote]