Basic stats on my source VB forum: 4,800 users, 102,000 total posts, 7600 threads. Images and attachments are stored in the file system (not the database) and total around 12.8 GB of data. My hoster is 1and1 and the php memory limit is 120 MB. php 5.4.x is what they're using.
My attachments and images are in the "images/attachments" folder of the forum (normal place in a VB install) and are nested below that in numbered folders, and include attachments + thumbs.
Can anyone detail what the issue with the attachment/image import process? I've researched the community via various other threads (shown below) and it seems that others have had similar problems in the past. I've tried a couple of the fixes (per the config.php file changes, for instance) and have not had luck in solving the issue.
Thoughts? Comments? Help? ?!?
XenForo Community threads that seem relevant to my issue:
- Fatal error while importing attachments
- XF 1.4 - Import Attached Files Error
- XF 1.4 - Importing Images Failed Help
- Memory error during attachment import
Here is the error information that I'm getting about 43% of the way through the attachment import process:
Fatal error: Out of memory (allocated 82051072) (tried to allocate 2448 bytes) in /homepages/0/d315437492/htdocs/testforum2/library/XenForo/Image/Gd.php on line 215
Mysqli statement execute error : Duplicate entry '18376' 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 XenForo/Model/Import.php at line 1890
XenForo_Model_Import->importAttachment() in XenForo/Model/Import.php at line 1936
XenForo_Model_Import->importPostAttachment() in XenForo/Importer/vBulletin4x.php at line 114
XenForo_Importer_vBulletin4x->stepAttachments() 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 /homepages/0/d315437492/htdocs/testforum2/admin.php at line 13