Fixed XF to XF "Import Conversations"

DRE

Well-known member
Started all over again, skipped the Import User Following and Ignore Lists option.

  1. Import User Groups: Imported 7 items. (0.01 seconds)
  2. Import Custom User Fields: Imported 55 items. (2.47 seconds)
  3. Import Users: Imported 588 items. (10.27 seconds)
Next option was Import Personal Conversations

Got this error:

Admin Control Panel - XenForo
Server Error
Mysqli statement execute error : Column 'last_message_user_id' cannot be null

  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 632
  4. Zend_Db_Adapter_Abstract->update() in XenForo/Model/Import.php at line 1131
  5. XenForo_Model_Import->importConversation() in XenForo/Importer/XenForo.php at line 1018
  6. XenForo_Importer_XenForo->stepConversations() in XenForo/Importer/Abstract.php at line 77
  7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
  8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
  9. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
  10. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  12. XenForo_FrontController->run() in /home/me/public_html/test/admin.php at line 13
 

DRE

Well-known member
Disabled Syndol Conversation Essentials and rebuild Conversations cache. Didn't work.

Uninstalled Conversations and tried again, still didn't work. Gonna start all over and this time skip Personal Conversations.
 

DRE

Well-known member
Started all over again, skipped the Import User Following and Ignore Lists option.

  1. Import User Groups: Imported 7 items. (0.01 seconds)
  2. Import Custom User Fields: Imported 55 items. (2.47 seconds)
  3. Import Users: Imported 588 items. (10.27 seconds)
Next option was Import Personal Conversations

Got this error:

Admin Control Panel - XenForo
Server Error
Mysqli statement execute error : Column 'last_message_user_id' cannot be null

  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 632
  4. Zend_Db_Adapter_Abstract->update() in XenForo/Model/Import.php at line 1131
  5. XenForo_Model_Import->importConversation() in XenForo/Importer/XenForo.php at line 1018
  6. XenForo_Importer_XenForo->stepConversations() in XenForo/Importer/Abstract.php at line 77
  7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
  8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
  9. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
  10. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  12. XenForo_FrontController->run() in /home/me/public_html/test/admin.php at line 13
So I was looking at this thread: http://xenforo.com/community/threads/deleting-a-user-updates-the-conversation_recipient-user_id-to-zero.54996/

and it made me realized that maybe all I need to do is create an account that no one will use and just change the user ids from 0 to 1. I would do the same for profile posts and messages. So all I would need to do is search by user id and replace it with the user ID of the new user I made. Once I do that, I can probably continue importing. The new user id will be a user called 'Guest'.

I'm breaking this issue off into this thread: http://xenforo.com/community/threads/delete-all-posts-by-guests.56518/
 
Last edited:

DRE

Well-known member
After applying fixes from the other thread I can import the following:
Import Custom User Fields
Import Users
Import Profile Posts

I still cannot Import Conversations.

Server Error
Mysqli statement execute error : Column 'last_message_user_id' cannot be null

  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 632
  4. Zend_Db_Adapter_Abstract->update() in XenForo/Model/Import.php at line 1131
  5. XenForo_Model_Import->importConversation() in XenForo/Importer/XenForo.php at line 1018
  6. XenForo_Importer_XenForo->stepConversations() in XenForo/Importer/Abstract.php at line 77
  7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
  8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
  9. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
  10. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  12. XenForo_FrontController->run() in /home/blah/public_html/test/admin.php at line 13
So out of curiosity I tried applying the same fix for profile posts into conversations and that didn't work either. Ended up getting this error:

Server Error
Mysqli statement execute error : Incorrect integer value: '' for column 'user_id' at row 1

  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/Model/Import.php at line 1140
  5. XenForo_Model_Import->importConversation() in XenForo/Importer/XenForo.php at line 1020
  6. XenForo_Importer_XenForo->stepConversations() in XenForo/Importer/Abstract.php at line 77
  7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
  8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
  9. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
  10. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  12. XenForo_FrontController->run() in /home/blah/public_html/test/admin.php at line 13
 
Last edited:
Top