Import from photopost (vb3) server error


Well-known member
Server Error

Mysqli statement execute error : Duplicate entry '88761' for key 'PRIMARY'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
XenForo_DataWriter->save() in XenGallery/Model/Importers.php at line 166
XenGallery_Model_Importers->importMedia() in XenGallery/Importer/PhotopostVb.php at line 739
XenGallery_Importer_PhotopostVb->_importMedia() in XenGallery/Importer/PhotopostVb.php at line 630
XenGallery_Importer_PhotopostVb->stepMedia() in XenForo/Importer/Abstract.php at line 97
XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 135
XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/ at line 13
I believe media import was almost done when this error showed up followed by "502 bad gateway".

How can I fix this?

Chris D

XenForo developer
Staff member
Run this query and refresh the page:

Rich (BB code):
DELETE FROM xengallery_media WHERE media_id = 88761
Chances are, you may get (by default) up to 5 more duplicate key errors. Run the same query above for each one changing the media ID each time that is shown in the duplicate entry error until it proceeds again. If any of the media IDs are repeated constantly then there's a possibility I may need to look into it for you in more detail. Hopefully, though, it will just continue after that.