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

E
  • Question Question
XF 2.2 Moderator VB to XF import
Replies
1
Views
28
Paul B
P
The Matrix
Importer from xF to xF error
Replies
0
Views
960
The Matrix
The Matrix
K
TypeError: Argument 1 passed to XF\Import\Data\ThreadPrefix::setTitle() must be of the type string, null given
Replies
2
Views
4K
Kirby
K
Fajfie
Fixed [E_NOTICE] Trying to access array offset on value of type null src/XF/Import/Importer/StepPostsTrait.php:120
Replies
3
Views
1K
XF Bug Bot
XF Bug Bot
S
  • Question Question
XF 2.2 problem import vb 4.2.5 to xf 2.2
Replies
1
Views
813
Paul B
P
Back
Top Bottom