Fixed XF to XF "Import Conversations"

DRE

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
 
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 said:
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
Click to expand...
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:
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:

Similar threads

jb9826
  • Question Question
XF 1.5 Batch Update Threads Timeout
Replies
0
Views
319
jb9826
jb9826
questlot
  • Solved
XF 2.0 Xenforo Import Error
Replies
5
Views
547
questlot
questlot
Commander
Fixed Discourse import problem
Replies
6
Views
1K
Jeremy P
Jeremy P
jb9826
  • Question Question
XF 1.5 Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
Replies
0
Views
534
jb9826
jb9826
The Matrix
Importer from xF to xF error
Replies
0
Views
950
The Matrix
The Matrix
Top Bottom