Fixed Discourse import problem


Affected version
Hi all...

I've managed to import most of data from Discourse to XenForo... but at near end I got this:

ErrorException: [E_WARNING] pg_prepare(): Query failed: ERROR: column bookmarks.topic_id does not exist LINE 4: ON = bookmarks.topic_id ^ in src/XF/Db/PostgreSql/Statement.php at line 35
  1. XF::handlePhpError()
  2. pg_prepare() in src/XF/Db/PostgreSql/Statement.php at line 35
  3. XF\Db\PostgreSql\Statement->prepare() in src/XF/Db/PostgreSql/Statement.php at line 47
  4. XF\Db\PostgreSql\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 167
  6. XF\Db\AbstractAdapter->fetchAllKeyed() in src/addons/XFI/Import/Importer/Discourse.php at line 2556
  7. XFI\Import\Importer\Discourse->stepBookmarks() in src/XF/Import/Runner.php at line 244
  8. XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 61
  9. XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line 234
  10. XF\Admin\Controller\Import->actionRun() in src/XF/Mvc/Dispatcher.php at line 352
  11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
  12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2353
  15. XF\App->run() in src/XF.php at line 524
  16. XF::runApp() in admin.php at line 13

Also I have about 79k posts and there is 77k post imported, but mainly problem is that is imporetd only 179 memebrs of 1605. When using rebuild I saw that rebuild goes to 1605, but I cant see them.

Is there any help for this?


Okay, try new import this time without bookmark options... now everything goes "OK" no error at the end, Import finalize and then there is still problem that only 179 members are imported.

XF Bug Bot

XenForo bug fixer bot
Staff member
Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XFI release (1.5.3).

Change log:
Handle Discourse 3.0+ polymorphic bookmarks properly
There may be a delay before changes are rolled out to the XenForo Community.