@evgeny-grushko opened this Issue on January 18th 2017

Error during creating goals on site: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'description' in 'field list'

Piwik version 3.0.1

@sgiehl commented on January 18th 2017 Member

Updated Piwik or new install?

@evgeny-grushko commented on January 18th 2017

I have used old Piwik database, but delete all files and install it from start. So it is similar to new install

@michaelschulze commented on February 12th 2017

Same problem here.
I installed PIWIK 3 new, but used an old PIWIK 2 database for transferring existing data.
Update to PIWIK 3.0.1 didn't help.
Error occurs when I try to create a goal.

@tsteur commented on February 12th 2017 Member

try to execute a SQL query like this ALTER TABLE piwik_goal ADDdescriptionvarchar(255) NOT NULL DEFAULT ''. I presume the goal plugin was not enabled when you did the update.

@sgiehl @mattab there might be a bug in our updater. I presume when updating core that it also sets all core plugins to that new core version. However, when the plugin was disabled, the update was not actually executed. So either for core plugins we need to manage the updates in "core" updates or we need to fix to record new version only for activated core plugins.

@michaelschulze commented on February 13th 2017

That worked for me! Thanks a lot!

@tsteur commented on March 6th 2017 Member

See https://github.com/piwik/piwik/issues/11438 the same also applies not only for core plugin updates but also to the dimension updates

@sgiehl commented on March 2nd 2020 Member

@tsteur might that be fixed meanwhile? Did some local testing and for me the version of deactivated plugins didn't change in db. And when activating the after the update they triggered the included migrations / dimension updates that weren't executed

@tsteur commented on March 2nd 2020 Member

@sgiehl if you tested it, and updates of a deactivated plugin are executed later, then feel free to close it. Might be good to test with deactivated non-core plugins and deactivated core plugin.

Powered by GitHub Issue Mirror