1. 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"

Discussion in 'Resolved Bug Reports' started by DRE, Aug 3, 2013.

  1. 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
     
  2. DRE

    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.
     
  3. DRE

    DRE Well-Known Member

    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: Aug 4, 2013
  4. DRE

    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: Aug 5, 2013
  5. Kier

    Kier XenForo Developer Staff Member

    Should be fixed now.
     

Share This Page