XF 2.2 Media Gallery upgrade not working

[Kwaka]

Hi,
I would welcome some help please.
I've moved web severs and upgraded to Xenforo 2.2 from version 1.X. I also had the Media Gallery installed at version 1.1.14.
The forum is all working fine... with a few tweaks needed due to coming from an older version, but I can't get the MediaGallery version working. It won't upgrade.
I don't want to lose any of the media that has been uploaded historically so asking for help please to try to diagnose the issue.


I'm getting errors in the server log:
Server error log

• XF\Db\Exception: xf_mg_category: MySQL query error [1054]: Unknown column 'category_description' in 'xf_mg_category'
• 
  
• src/XF/Db/AbstractStatement.php:230
• Generated by: Oleksandr
• 
  
• Nov 7, 2022 at 9:55 PM

Stack trace​

ALTER TABLE xf_mg_category
ADD view_user_groups BLOB NOT NULL AFTER category_description
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1054, '42S22')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/Schema/AbstractDdl.php(158): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...')
#4 src/XF/Db/SchemaManager.php(148): XF\Db\Schema\AbstractDdl->apply()
#5 src/addons/XFMG/Setup.php(644): XF\Db\SchemaManager->alterTable('xf_mg_category', Object(Closure))
#6 src/XF/AddOn/StepRunnerUpgradeTrait.php(124): XFMG\Setup->upgrade902000010Step3(Array)
#7 src/XF/AddOn/StepRunnerUpgradeTrait.php(73): XFMG\Setup->upgradeStepRunner(902000010, 3, Array, 902000032)
#8 src/XF/Admin/Controller/AddOn.php(597): XFMG\Setup->upgrade(Array)
#9 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#11 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\AddOn), NULL)
#12 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2353): XF\Mvc\Dispatcher->run()
#14 src/XF.php(524): XF\App->run()
#15 admin.php(13): XF::runApp('XF\\Admin\\App')
#16 {main}

 

[Kwaka]

This is the error when upgrading:



XFIDb\Exception: xf mg category: MySQL query error [1054]: Unknown column 'category description' in 'xf_mg_ category' in src/XF/Db/AbstractStatement.php at line 230

1. XFIDblAbstractStatement->getException()in src/XF/Db/Mysqli/Statement.php at line 198
2. XFIDb|MysqlilStatement->getException)insrc/XF/Db/Mysqli/Statement.phpatline79
3. XF\Db\Mysqlilstatement->execute() in src/F/Db/AbstractAdapter.php at line 96
4. XF\DblAbstractAdapter->query) in src/XF/Db/Schema/AbstractDdI.php at line 158
5. XFIDbISchemalAbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 148
6. XFIDbISchemaManager->alterTable() in srcladdons/XFMG/Setup.php at line 644
7. XFMG\Setup->upgrade902000010Step3() in src/XF/AddOn/StepRunnerUpgradeTrait.ph at line 124
8. XFMG\Setup->upgradeStepRunner() in src/XF/AddOn/StepRunnerUpgradeTrait.php at line 73
9. XFMG\Setup->upgrade() in src/XF/Admin/Controller/AddOn.php at line 597
10. XFlAdmin|Controller\AddOn->actionUpgrade()insrc/XF/Mvc/Dispatcher.phpatline352
11. XF\Mvc\Dispatcher->dispatchClass()in src/XF/Mvc/Dispatcher.php at line 259
12. XF\Mvc\Dispatcher->dispatchFromMatch()in src/XF/Mvc/Dispatcher.php at line 115
13. XF\Mvc\Dispatcher->dispatchLoop() in src/F/Mvc/Dispatcher.php at line 57
14. XFIMvc|Dispatcher->run() in src/XF|App.php at line 2353
15. XFlApp->run) in src/XF.php at line 524
16. XF::runApp() in admin.php at line 1

 

[Kwaka]

Ok have managed to solve this now with a restore of the database.