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

Fixed XF to XF "Import Conversations"

DRE

Well-known member
#1
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
#2
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
#3
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/thread...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
#4
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: