1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Import from photopost (vb3) server error

Discussion in 'Media Gallery Support' started by dutchbb, Mar 13, 2015.

  1. dutchbb

    dutchbb 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/mydomain.nl/public_html/test_import_forum/admin.php 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?
  2. Chris D

    Chris D XenForo Developer Staff Member

    Run this query and refresh the page:

    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.
  3. dutchbb

    dutchbb Well-Known Member

    Yes it is repeating, do I send login info in a support ticket or PC?
  4. Chris D

    Chris D XenForo Developer Staff Member

    Support ticket please. Please include Admin CP, FTP and PhpMyAdmin access if possible.

Share This Page