XF 1.5 Trying to upgrade and got this error

drastic

Well-known member
#1
Server Error
Mysqli statement execute error : Duplicate entry 'boardUrl-basicBoard' for key 'PRIMARY'

  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter/Option.php at line 496
  5. XenForo_DataWriter_Option->_updateRelatedGroupList() in XenForo/DataWriter/Option.php at line 430
  6. XenForo_DataWriter_Option->_postSave() in XenForo/DataWriter.php at line 1423
  7. XenForo_DataWriter->save() in XenForo/Model/Option.php at line 1131
  8. XenForo_Model_Option->importOptionsAddOnXml() in XenForo/Model/Option.php at line 1034
  9. XenForo_Model_Option->importOptionsDevelopmentXml() in XenForo/Deferred/ImportMasterData.php at line 21
  10. XenForo_Deferred_ImportMasterData->execute() in XenForo/Deferred/Atomic.php at line 66
  11. XenForo_Deferred_Atomic->execute() in XenForo/Model/Deferred.php at line 295
  12. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
  13. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 355
  14. XenForo_Model_Deferred->runByUniqueKey() in XenForo/Install/Controller/Abstract.php at line 34
  15. XenForo_Install_Controller_Abstract->_manualDeferredRunner() in XenForo/Install/Controller/Upgrade.php at line 221
  16. XenForo_Install_Controller_Upgrade->actionRunDeferred() in XenForo/FrontController.php at line 351
  17. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  18. XenForo_FrontController->run() in /home/path/domain.com/c/install/index.php at line 18

I can't login to the admin because it's stuck in the "finish upgrade" screen.

I can get into phpmyadmin though, so if there's something I can do in there, any suggestions?
 

Mike

XenForo developer
Staff member
#2
In phpMyAdmin, look in the xf_option_group_relation table for any rows with an option_id of "boardUrl". Remove them and then retry the upgrade.
 
Top