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 Apparently XenForo changed the format of the custom profile fields in the database from “PHP serialized” to “JSON”. Can you clarify which exact version of XenForo you are trying to import?

  • Hi


    levi45 Apparently XenForo changed the format of the custom profile fields in the database from “PHP serialized” to “JSON”. Can you clarify which exact version of XenForo you are trying to import?

    Hi Its latest one xenforo 2.1.4

  • 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.

  • What a super team , what a super customer support , what a super community <3 Thank you very much all sorted now .:thumbup:

  • 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.