I'm getting this MYSQL error and a 500 Internal Server Error when trying to upgrade my XFMG to XFMG 2.0
Server error log
- XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'watermark_id' in 'where clause'
- src/XF/Db/AbstractStatement.php:212
- Generated by: John
- Dec 10, 2017 at 2:01 AM
Stack trace
UPDATE xf_mg_media_item
SET watermark_id = 1
WHERE watermark_id > 0
------------
#0 src/XF/Db/Mysqli/Statement.php(174): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(36): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(46): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(69): XF\Db\Mysqli\Statement->execute()
#4 src/XF/AddOn/AbstractSetup.php(190): XF\Db\AbstractAdapter->query('\n\t\t\tUPDATE xf_m...', Array)
#5 src/addons/XFMG/Setup.php(855): XF\AddOn\AbstractSetup->query('\n\t\t\tUPDATE xf_m...')
#6 src/XF/AddOn/StepRunnerUpgradeTrait.php(117): XFMG\Setup->upgrade902000010Step6(Array)
#7 src/XF/AddOn/StepRunnerUpgradeTrait.php(74): XFMG\Setup->upgradeStepRunner(902000010, 6, Array, 902000032)
#8 src/XF/Admin/Controller/AddOn.php(437): XFMG\Setup->upgrade(Array)
#9 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AddOn->actionUpgrade(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(89): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'upgrade', 'html', Object(XF\Mvc\ParameterBag), 'listAddOns', Object(XF\Admin\Controller\AddOn), NULL)
#11 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(1879): XF\Mvc\Dispatcher->run()
#13 src/XF.php(328): XF\App->run()
#14 admin.php(13): XF::runApp('XF\\Admin\\App')
#15 {main}
Not sure what else to do at this point. The Forums seem to be working well but, this upgrade fails and I'm seeing this with the Server Logs.
