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
- XF\Db\AbstractStatement->getException() insrc/XF/Db/Mysqli/Statement.php at line 196
- XF\Db\Mysqli\Statement->getException() insrc/XF/Db/Mysqli/Statement.php at line 39
- XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.phpat line 54
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.phpat line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 155
- XF\Db\AbstractAdapter->fetchAll() insrc/addons/XFI/Import/Importer/vBulletin.php at line 984
- XFI\Import\Importer\vBulletin->stepUsers() insrc/XF/Import/Runner.php at line 231
- XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 59
- XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line234
- XF\Admin\Controller\Import->actionRun() insrc/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.phpat line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
- XF\App->run() in src/XF.php at line 391
- 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}