Resource icon
vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] [Paid] 1.5.0
- Thread starter Slavik
- Start date
Brent W
Well-known member
Got this just now:
Code:
Total time for private messages: 19.41s
performing avatar diff...An unexpected database error occurred. Please try again later.
<!-- Mysqli prepare error: Unknown column 'user.userid' in 'field list' -->[root@localhost public]# rm: cannot remove ‘/home/nginx/domains/religiousforums.com/public/importData/xf_post_*’: No such file or directory
There should be something written out. You're checking the one in XenForo yea?
Brent W
Well-known member
Sorry my brain was on server logs.
Code:
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'user.userid' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Yesterday at 11:48 PM
Stack Trace
#0 /home/nginx/domains/religiousforums.com/public/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\t\tSELECT us...')
#1 /home/nginx/domains/religiousforums.com/public/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\t\tSELECT us...')
#2 /home/nginx/domains/religiousforums.com/public/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\t\tSELECT us...')
#3 /home/nginx/domains/religiousforums.com/public/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('\r\n\t\t\t\tSELECT us...', Array)
#4 /home/nginx/domains/religiousforums.com/public/Export.php(1520): Zend_Db_Adapter_Abstract->fetchAll('\r\n\t\t\t\tSELECT us...')
#5 /home/nginx/domains/religiousforums.com/public/Export.php(1921): DigitalPointExporter->avatars()
#6 {main}
Request State
array(3) {
["url"] => string(7) "http://"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}Brent W
Well-known member
https://www.dropbox.com/s/xqbsmhsjq6zl495/Screenshot 2014-10-24 15.05.59.png?dl=0
https://www.dropbox.com/s/79b5x6fpysm8sex/Screenshot 2014-10-24 15.06.19.png?dl=0
https://www.dropbox.com/s/flskwm0pivjwek7/Screenshot 2014-10-24 15.06.34.png?dl=0
https://www.dropbox.com/s/7lyjvhht7dcsvuk/Screenshot 2014-10-24 15.06.58.png?dl=0
https://www.dropbox.com/s/1iwizhw2f92o3yr/Screenshot 2014-10-24 15.07.07.png?dl=0
Brent W
Well-known member
Superfluous
Member
Can you send it to me lol. Can't download anything from DPs site right now.
Is it something to do with table name extension - such as it should be vb_user? - even with the table extension defined in the newest script it breaks on me importing attachments and avatars - gives a similar 'can not find table' error.
Does it work on the 1.2?
Superfluous
Member
To get around the different order of table columns, I installed XF 1.2 - used old 1.2 Big Board Importer it worked fine. Upgraded to 1.4, used 1.4 Big Board Importer, with vb_ extension defined and it gave me the 'table not found' error only on the Avatars and Attachments.
Superfluous
Member
When importing into XF 1.2 I used a non-live (older) copy of my vBulletin database, in which I had renamed all vb_ tables. When I tested with the 1.4 Importer I connected to the live VB database and defined the vb_ extension in the script.
Brent W
Well-known member
I get this error when trying to rebuild user caches after import:
Server Error
Mysqli statement execute error : Incorrect integer value: '' for column 'user_group_id' at row 1
Server Error
Mysqli statement execute error : Incorrect integer value: '' for column 'user_group_id' at row 1
- Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
- Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
- Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
- Zend_Db_Adapter_Abstract->insert() in XenForo/Model/Permission.php at line 1416
- XenForo_Model_Permission->findOrCreatePermissionCombination() in XenForo/Model/Permission.php at line 1377
- XenForo_Model_Permission->findOrCreatePermissionCombinationFromUser() in XenForo/Model/Permission.php at line 1246
- XenForo_Model_Permission->updateUserPermissionCombination() in XenForo/DataWriter/User.php at line 962
- XenForo_DataWriter_User->rebuildPermissionCombinationId() in XenForo/Deferred/User.php at line 37
- XenForo_Deferred_User->execute() in XenForo/Model/Deferred.php at line 197
- XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 320
- XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 273
- XenForo_Model_Deferred->run() in XenForo/ControllerAdmin/Tools.php at line 147
- XenForo_ControllerAdmin_Tools->actionRunDeferred() in XenForo/FrontController.php at line 337
- XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
- XenForo_FrontController->run() in /home/nginx/domains/religiousforums.com/public/admin.php at line 13
Jake Bunce
Well-known member
That looks like it might be bad data which may be the result of wrong column orders from not starting with XF 1.2.
I am almost done doing a full column order review so we can reset the requirements to a new installation of XF 1.4. There have been a few changes to the various user tables that I have found already.
Similar threads
- Question
- Question
