Jump to content
  • Status: Moved to Github

I get the following error when testing the upgrade from 4.7.19 to latest 5.0.4 Beta 1.

Unknown column 'last_post_data' in 'SELECT'
#0 /var/www/forum/system/Db/Select.php(402): IPS\Db->preparedQuery() 
#1 /var/www/forum/system/Db/Select.php(460): IPS\Db\Select->runQuery() 
#2 /var/www/forum/applications/forums/setup/upg_5000061/upgrade.php(56): IPS\Db\Select->rewind() 
#3 /var/www/forum/applications/core/sources/Setup/Upgrade.php(648): IPS\forums\setup\upg_5000061\Upgrade->step2() 
#4 /var/www/forum/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() 
#5 /var/www/forum/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() 
#6 /var/www/forum/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->{closure:IPS\core\modules\setup\upgrade\upgrade::manage():47}() 
#7 /var/www/forum/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() 
#8 /var/www/forum/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() 
#9 /var/www/forum/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() 
#10 /var/www/forum/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #11 {main}
/var/www/forum/system/Db/Select.php::460

SELECT id, last_post_data FROM `forums_forums`

User Feedback

Recommended Comments

Eleeist

Clients

I created the column manually and the upgrade finished successfully.

teraßyte

Clients

Known issue and it should be already patched according to the replies. You should have a patch in your ACP to resolve it: