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

Import errors

Discussion in 'Media Gallery Support' started by Nelson T., Feb 6, 2015.

  1. Nelson T.

    Nelson T. Guest

    Tried to import from VB, and got these errors, then it died at 36.99%:

    Mysqli statement execute error : Duplicate entry '34861' 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.php at line 1624
    5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
    6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
    7. XenForo_DataWriter->save() in XenGallery/Model/Importers.php at line 166
    8. XenGallery_Model_Importers->importMedia() in XenGallery/Importer/vBulletin42x.php at line 506
    9. XenGallery_Importer_vBulletin42x->stepMedia() in XenForo/Importer/Abstract.php at line 97
    10. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
    11. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 135
    12. XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 347
    13. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    14. XenForo_FrontController->run() in /home/hobbymac/public_html/Xen/admin.php at line 13
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    If you check Tools > Server Error Log

    What was the first error you received? Unless you're trying to import data into an existing gallery, or trying to re-run the importer after it failed, the initial error would have probably been something different.
     
  3. Nelson T.

    Nelson T. Guest

    Chris:

    They all appeared at once.

    Idea- Could this be because I am out of disk space on the server? I don't think I am but I am just trying to figure it out.

    I am at 84% full and got a warning, so I am not full.
     
  4. Nelson T.

    Nelson T. Guest

    Question- where is the directory located on the server, so I can delete it and try again.

    Thanks.
     
  5. Chris D

    Chris D XenForo Developer Staff Member

    The best way to start over is to uninstall XFMG and reinstall again.

    That will mark the stuff imported so far for deletion and clear any data that has been imported so far.

    If you continue to have problems, please open a ticket from your Customer Area with login details for your Admin CP, FTP and PhpMyAdmin (the latter two may not be needed if you have access to cPanel or similar).
     
  6. Nelson T.

    Nelson T. Guest

    Ok, I am uninstalling media gallery. Will see what happens.
     
  7. Nelson T.

    Nelson T. Guest

    Ok, question...

    It wants to use /home/hobbymac/attachments as the gallery directory to import from. That is the main attachment directory with thousands of files. I am worried that is not the correct album directory.

    Can you clarify please Chris, this may be the problem.

    Thanks.
     
  8. Nelson T.

    Nelson T. Guest

    Chris,

    When I hit 36.99 after reinstalling the MG, it happens again.....
    Admin Control Panel - The Hobby-Machinist
    Server Error
    Mysqli statement execute error : Duplicate entry '34861' 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.php at line 1624
    5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
    6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
    7. XenForo_DataWriter->save() in XenGallery/Model/Importers.php at line 166
    8. XenGallery_Model_Importers->importMedia() in XenGallery/Importer/vBulletin42x.php at line 506
    9. XenGallery_Importer_vBulletin42x->stepMedia() in XenForo/Importer/Abstract.php at line 97
    10. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
    11. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 135
    12. XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 347
    13. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    14. XenForo_FrontController->run() in /home/hobbymac/public_html/Xen/admin.php at line 13
     
  9. 0ptima

    0ptima Well-Known Member

    Im getting a similar issue. How did you resolve this?
     
  10. Chris D

    Chris D XenForo Developer Staff Member

    It usually suggests that PHP has hit some sort of error so when it tries to resume it comes across images that it has already imported.

    Was there any errors that you could see before this came up? Anything in your PHP or wbeb server error logs?
     
  11. 0ptima

    0ptima Well-Known Member

    Found this in the php log
    PHP Fatal error: Maximum execution time of 120 seconds exceeded in C:\wamp\www\xf\library\Zend\Db\Statement\Mysqli.php on line 208

    What do I need to delete in order for the import to continue?
     
  12. Chris D

    Chris D XenForo Developer Staff Member

    Hmm that's an intersting error because nothing should be executing for longer than 120 seconds. The error suggests it's executing a query, at that point. None of the queries should be particularly stressful.

    Are you just on the Media step at the moment?

    In case it is something else causing it... Do you have many animated images and do you have enabled the option to create animated thumbnails? (That option requires ImageMagick to be enabled).

    That might be worth disabling.

    Ultimately, though, it might just be worth trying again.

    Assuming you're getting the same error as Nelson, above, and you're now getting duplicate entry errors. If the duplicate entry is e.g. 1234 you would need to delete that and the subsequent images currently in the xengallery_media table, then try and refresh the importer. It should continue where it left off.

    If you continue to receive these errors, it may be simply down to some sort of corrupted image. To identify it, look in the xengallery_media table for the last entry. If the last entry is 12345 then the one causing the problem is likely to be 12346. Deleting that entry from the source data may allow the importer to continue. Sometimes you might have to do this a few times if there are a few "bad" images.
     
  13. 0ptima

    0ptima Well-Known Member

    This was at the import media step. According to phpinfo(), I dont have ImageMagick installed.
    Deleting the latest two records in xengallery_media allowed the importer to continue.

    Thanks.
     
  14. Chris D

    Chris D XenForo Developer Staff Member

    Good news :)
     

Share This Page