Xenforo 2.0 Importer

  • i got this error come up

    unserialize(): Error at offset 0 of 100 bytes


    Stacktrace:

    #0 [internal function]: wcf\system\WCF::handleError(8, 'unserialize(): ...', '/home1/myaccname...', 305, Array)

    #1 /home1/myaccname/public_html/lib/system/exporter/XF2xExporter.class.php(305): unserialize('{"aim":"","icq"...')

    #2 [internal function]: wcf\system\exporter\XF2xExporter->exportUsers(0, 200)

    #3 /home1/myaccname/public_html/lib/system/exporter/AbstractExporter.class.php(152): call_user_func(Array, 0, 200)

    #4 /home1/myaccname/public_html/lib/system/worker/ImportWorker.class.php(95): wcf\system\exporter\AbstractExporter->exportData('com.woltlab.wcf...', 0)

    #5 /home1/myaccname/public_html/lib/acp/action/WorkerProxyAction.class.php(92): wcf\system\worker\ImportWorker->execute()

    #6 /home1/myaccname/public_html/lib/action/AbstractAction.class.php(47): wcf\acp\action\WorkerProxyAction->execute()

    #7 /home1/myaccname/public_html/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()

    #8 /home1/myaccname/public_html/lib/system/request/Request.class.php(83): wcf\action\AJAXInvokeAction->__run()

    #9 /home1/myaccname/public_html/lib/system/request/RequestHandler.class.php(96): wcf\system\request\Request->execute()

    #10 /home1/myaccname/public_html/acp/index.php(9): wcf\system\request\RequestHandler->handle('wcf', true)

    #11 {main}

  • Hi


    levi45 Thank you. I can confirm that they adjusted the format in XenForo 2.1. Try replacing the file lib/system/export/XF2xExporter.class.php with the attached version. It should fix the issue.


    Note: Before doing a final import after you verified that the exporter works I recommend re-installing WoltLab Suite to make sure there are no duplicate entries!

  • Now i run in to this error

    Could not prepare statement 'SELECT COUNT(*) AS count FROM xf_liked_content WHERE content_type = ?'


    Stacktrace:

    #0 /home1/myaccname/public_html/lib/system/exporter/XF2xExporter.class.php(1527): wcf\system\database\Database->prepareStatement('SELECT\tCOUNT(*)...')

    #1 /home1/myaccname/public_html/lib/system/exporter/XF2xExporter.class.php(1105): wcf\system\exporter\XF2xExporter->countLikes('post')

    #2 [internal function]: wcf\system\exporter\XF2xExporter->countPostLikes()

    #3 /home1/myaccname/public_html/lib/system/exporter/AbstractExporter.class.php(138): call_user_func(Array)

    #4 /home1/myaccname/public_html/lib/system/worker/ImportWorker.class.php(64): wcf\system\exporter\AbstractExporter->countLoops('com.woltlab.wbb...')

    #5 /home1/myaccname/public_html/lib/system/worker/ImportWorker.class.php(71): wcf\system\worker\ImportWorker->countObjects()

    #6 /home1/myaccname/public_html/lib/acp/action/WorkerProxyAction.class.php(89): wcf\system\worker\ImportWorker->getProgress()

    #7 /home1/myaccname/public_html/lib/action/AbstractAction.class.php(47): wcf\acp\action\WorkerProxyAction->execute()

    #8 /home1/myaccname/public_html/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()

    #9 /home1/myaccname/public_html/lib/system/request/Request.class.php(83): wcf\action\AJAXInvokeAction->__run()

    #10 /home1/myaccname/public_html/lib/system/request/RequestHandler.class.php(96): wcf\system\request\Request->execute()

    #11 /home1/myaccname/public_html/acp/index.php(9): wcf\system\request\RequestHandler->handle('wcf', true)

    #12 {main}

    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'myaccname_.xf_liked_content' doesn't exist


    Stacktrace

    #0 /home1/myaccname/public_html/lib/system/database/Database.class.php(243): PDO->prepare('SELECT\tCOUNT(*)...')

    #1 /home1/myaccname/public_html/lib/system/exporter/XF2xExporter.class.php(1527): wcf\system\database\Database->prepareStatement('SELECT\tCOUNT(*)...')

    #2 /home1/myaccname/public_html/lib/system/exporter/XF2xExporter.class.php(1105): wcf\system\exporter\XF2xExporter->countLikes('post')

    #3 [internal function]: wcf\system\exporter\XF2xExporter->countPostLikes()

    #4 /home1/myaccname/public_html/lib/system/exporter/AbstractExporter.class.php(138): call_user_func(Array)

    #5 /home1/myaccname/public_html/lib/system/worker/ImportWorker.class.php(64): wcf\system\exporter\AbstractExporter->countLoops('com.woltlab.wbb...')

    #6 /home1/myaccname/public_html/lib/system/worker/ImportWorker.class.php(71): wcf\system\worker\ImportWorker->countObjects()

    #7 /home1/myaccname/public_html/lib/acp/action/WorkerProxyAction.class.php(89): wcf\system\worker\ImportWorker->getProgress()

    #8 /home1/myaccname/public_html/lib/action/AbstractAction.class.php(47): wcf\acp\action\WorkerProxyAction->execute()

    #9 /home1/myaccname/public_html/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()

    #10 /home1/myaccname/public_html/lib/system/request/Request.class.php(83): wcf\action\AJAXInvokeAction->__run()

    #11 /home1/myaccname/public_html/lib/system/request/RequestHandler.class.php(96): wcf\system\request\Request->execute()

    #12 /home1/myaccname/public_html/acp/index.php(9): wcf\system\request\RequestHandler->handle('wcf', true)

    #13 {main}

  • Hi


    levi45 It looks like this might required a bit more of back and forth. It might be helpful if you could provide us with a database dump so we can check it ourselves. You can provide it to us by creating a ticket. Simply create one, referring to this thread. We will then request your database information via a separate form.