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}

There appears to be an issue with the database values, Tim Düsterhus should be able to tell you more.

ok thanks ill wait Tim Düsterhus reply

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?

Quote from Tim Düsterhus

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!

Please can you let me know how do i reinstall, like a fresh install many thanks

Just delete the folder containing the WoltLab applications and delete the SQL database, do a fresh install as instructed here.

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.

Tim Düsterhus great i will do thanks. Just an update if i uncheck the like box to not import then finishes the data import fine.

What a super team , what a super customer support , what a super community Thank you very much all sorted now .