Xenforo 2.1 Import from vB 5

knuddl

Member
Registered
Joined
Jul 26, 2020
Messages
9
Points
3

Reputation:

Hello,

I've installed the importer and want to import from vB 5.5...must the foren on the same database or can I use 2 different databases?

Thanks for help
 
Last edited:

thomsa

Moderator
Staff member
Moderator
S.V.I.P Member
Collaborate
Registered
Joined
Jun 22, 2019
Messages
1,066
Points
173

Reputation:

first to backup data&db
two import u vb5 to xf2
 

Soft4Win

Developer
Staff member
Moderator
Collaborate
Registered
Joined
Apr 27, 2019
Messages
370
Points
103

Reputation:

Hello,

I've installed the importer and want to import from vB 5.5...must the foren on the same database or can I use 2 different databases?

Thanks for help
knuddlYou must have Vbulletin and Xenforo Stored on Different Database, once Xenforo is installed run the Vbulletin Importer and fill the Vbulletin Database details to import the data on Xenforo.

Make sure to take a backup of data before proceeding.
 

knuddl

Member
Registered
Joined
Jul 26, 2020
Messages
9
Points
3

Reputation:

thanks

One more question - i've done it all and i get

XF\Db\InvalidQueryException: MySQL statement prepare error [1176]: Key 'PRIMARY' doesn't exist in table 'admin' in src/XF/Db/AbstractStatement.php at line 228
  1. XF\Db\AbstractStatement->getException() insrc/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() insrc/XF/Db/Mysqli/Statement.php at line 39
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.phpat line 54
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.phpat line 94
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 155
  6. XF\Db\AbstractAdapter->fetchAll() insrc/addons/XFI/Import/Importer/vBulletin.php at line 984
  7. XFI\Import\Importer\vBulletin->stepUsers() insrc/XF/Import/Runner.php at line 231
  8. XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 59
  9. XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line234
  10. XF\Admin\Controller\Import->actionRun() insrc/XF/Mvc/Dispatcher.php at line 350
  11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line257
  12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.phpat line 113
  13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line55
  14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
  15. XF\App->run() in src/XF.php at line 391
  16. XF::runApp() in admin.php at line 13

Can someone help me to import from vB 5.5
 
Last edited:

thomsa

Moderator
Staff member
Moderator
S.V.I.P Member
Collaborate
Registered
Joined
Jun 22, 2019
Messages
1,066
Points
173

Reputation:

to delete xf db and creat new then to install new xf.
 

knuddl

Member
Registered
Joined
Jul 26, 2020
Messages
9
Points
3

Reputation:

ok i try it, but the xf was complete new and empty

If have done it but I get this error too....what is going wrong by me?
 
Last edited:

knuddl

Member
Registered
Joined
Jul 26, 2020
Messages
9
Points
3

Reputation:

I've found the problem - the import from vB 5.5.5 to xf 2.1 doesn't work because vB have changed something in the db-structure.....

I must downgrade vB to 5.3... is the right way to save the db and install vB 5.3 and import the db?
 

Soft4Win

Developer
Staff member
Moderator
Collaborate
Registered
Joined
Apr 27, 2019
Messages
370
Points
103

Reputation:

I think downgrading wasn't going to be that easy, look for the latest importers of Xenforo, it should be upgraded to support the new db structure.
 

knuddl

Member
Registered
Joined
Jul 26, 2020
Messages
9
Points
3

Reputation:

the support of xf told me, that the importer only work till vB 5.3. When the new update for vB 5.5.5 will released they doesn't know. If i found a way i will report it here
 

cmd

Collaborate
Collaborate
Registered
Joined
Feb 18, 2020
Messages
217
Points
73

Reputation:

Xenforo does not prioritize the development of their importer as much as they do with their paid add-ons and the software itself. You are likely available to do one of the following:
  • Stick to using vBulletin for your forums
  • Do a clean install of Xenforo and require users to register again
  • Do a clean install of Xenforo and manually transfer all data
vBulletin never has, and will never, support downgrading. So that will not be of any luck for you.
 

thomsa

Moderator
Staff member
Moderator
S.V.I.P Member
Collaborate
Registered
Joined
Jun 22, 2019
Messages
1,066
Points
173

Reputation:

what error when import ?

i test import from vb 5.6.2 to xf 2.1.10 pl2 use importer addon 1.3.2 it pass.

error [1406]: Data too long for column 'old_id' at row 1

but i make it to pass.
 

knuddl

Member
Registered
Joined
Jul 26, 2020
Messages
9
Points
3

Reputation:

Downgrad doesn't work

@cmd what do you mean with
  • Do a clean install of Xenforo and manually transfer all data
I have installed a new xf and how can i transfere all data manually from the db off vb5.5.5

@thomsa the error is

XF\Db\InvalidQueryException: MySQL statement prepare error [1176]: Key 'PRIMARY' doesn't exist in table 'admin' in src/XF/Db/AbstractStatement.php at line 228
  1. XF\Db\AbstractStatement->getException() insrc/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() insrc/XF/Db/Mysqli/Statement.php at line 39
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.phpat line 54
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.phpat line 94
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 155
  6. XF\Db\AbstractAdapter->fetchAll() insrc/addons/XFI/Import/Importer/vBulletin.php at line 984
  7. XFI\Import\Importer\vBulletin->stepUsers() insrc/XF/Import/Runner.php at line 231
  8. XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 59
  9. XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line234
  10. XF\Admin\Controller\Import->actionRun() insrc/XF/Mvc/Dispatcher.php at line 350
  11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line257
  12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.phpat line 113
  13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line55
  14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
  15. XF\App->run() in src/XF.php at line 391
  16. XF::runApp() in admin.php at line 13

I've installed xf 2.1.10 patch 2 enxf and then i installt xfi-xenforo-import-1.3.2 full from this board.
I doen't know what is going wrong

The Server-Error-Protocoll

Stack-Trace

SELECT user.*, userfield.*, usertextfield.*,
IF(admin.userid IS NULL, 0, 1) AS is_admin,
admin.adminpermissions AS admin_permissions,
IF(userban.userid IS NULL, 0, 1) AS is_banned,
userban.bandate AS ban_date,
userban.liftdate AS ban_end_date,
userban.reason AS ban_reason,
userban.adminid AS ban_user_id,
IF(usergroup.adminpermissions & 1, 1, 0) AS is_super_moderator,
IF(customavatar.userid, 1, 0) AS has_custom_avatar
FROM user AS
user
STRAIGHT_JOIN userfield AS
userfield ON (user.userid = userfield.userid)
STRAIGHT_JOIN usertextfield AS
usertextfield ON (user.userid = usertextfield.userid)
LEFT JOIN administrator AS
admin FORCE INDEX (PRIMARY) ON (user.userid = admin.userid)
LEFT JOIN userban AS
userban ON (user.userid = userban.userid)
LEFT JOIN usergroup AS
usergroup ON (user.usergroupid = usergroup.usergroupid)
LEFT JOIN customavatar AS
customavatar ON (user.userid = customavatar.userid)
WHERE user.userid > ? AND user.userid <= ?
ORDER BY user.userid
LIMIT 500

------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException()
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException()
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(155): XF\Db\AbstractAdapter->query()
#5 src/addons/XFI/Import/Importer/vBulletin.php(984): XF\Db\AbstractAdapter->fetchAll()
#6 src/XF/Import/Runner.php(231): XFI\Import\Importer\vBulletin->stepUsers()
#7 src/XF/Import/Runner.php(59): XF\Import\Runner->runStep()
#8 src/XF/Admin/Controller/Import.php(234): XF\Import\Runner->run()
#9 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\Import->actionRun()
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass()
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch()
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop()
#13 src/XF/App.php(2190): XF\Mvc\Dispatcher->run()
#14 src/XF.php(391): XF\App->run()
#15 admin.php(13): XF::runApp()
#16 {main}
 
Last edited:

knuddl

Member
Registered
Joined
Jul 26, 2020
Messages
9
Points
3

Reputation:

If you want you can try it by me - i will grant you access to all what you need
 

knuddl

Member
Registered
Joined
Jul 26, 2020
Messages
9
Points
3

Reputation:

must the admin in xf the same as vb?

Is it possible that the error runs of the addons of xf? I've installed them and the german language....
 
Last edited:

thomsa

Moderator
Staff member
Moderator
S.V.I.P Member
Collaborate
Registered
Joined
Jun 22, 2019
Messages
1,066
Points
173

Reputation:

MySQL statement prepare error [1176]: Key 'PRIMARY' doesn't exist in table 'admin'

don't have 'PRIMARY' in table 'admin'

pl, show pic of table 'admin' on xf database
 
Last edited:

rOckEt

OldSchool
Collaborate
Registered
Joined
Aug 9, 2019
Messages
55
Points
43

Reputation:

Recommend to Migrate fisrt to last version of Xenforo 1.xx(Use Search) then you can migrate from xf 1 to xf 2 without problems.
 
Top