Jump to content
  • Status: Moved to Github

Gents, I posted this in the forums but thought I would share it here.

During the upgrade from 4.7.20 to 5.0.3 I experienced this error and could not continue.

Unknown column 'post_featured' in 'field list'
#0 /var/www/vhosts/classiczcars.com/vision/system/Db/Db.php(1232): IPS\Db->preparedQuery() #1 /var/www/vhosts/classiczcars.com/vision/applications/core/setup/upg_5000057/upgrade.php(58): IPS\Db->update() #2 /var/www/vhosts/classiczcars.com/vision/applications/core/sources/Setup/Upgrade.php(648): IPS\core\setup\upg_5000057\Upgrade->step1() #3 /var/www/vhosts/classiczcars.com/vision/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /var/www/vhosts/classiczcars.com/vision/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /var/www/vhosts/classiczcars.com/vision/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /var/www/vhosts/classiczcars.com/vision/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() #7 /var/www/vhosts/classiczcars.com/vision/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /var/www/vhosts/classiczcars.com/vision/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /var/www/vhosts/classiczcars.com/vision/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main}
/var/www/vhosts/classiczcars.com/vision/applications/core/setup/upg_5000057/upgrade.php::58

Fixed it with:

ALTER TABLE forums_posts

ADD COLUMN post_featured TINYINT(1) NOT NULL DEFAULT 0;

User Feedback

Recommended Comments

There are no comments to display.