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}

  • A year or so ago I gave them copies of my Xenforo database, both 1.5 and 2.0 version so they could update their importer.

    They did it and did an amazing job. They unlike other forum software providers WANT people to convert to them.

    Good job WoltLab, keep up the good work.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!