vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] [Paid] 1.5.0

[jaymsgq]

Hi
I see error below when rebuilding cache or importing a new style. Any advice on how to fix this?

An exception occurred: Mysqli statement execute error : Incorrect integer value: '' for column 'user_group_id' at row 2 in /sites/apache/forum/xenbig/library/Zend/Db/Statement/Mysqli.php on line 214

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 XenForo/DataWriter/User.php at line 981
XenForo_DataWriter_User->rebuildUserGroupRelations() in XenForo/Deferred/User.php at line 38
XenForo_Deferred_User->execute() in XenForo/Model/Deferred.php at line 252
XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 378
XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 331
XenForo_Model_Deferred->run() in XenForo/ViewRenderer/Abstract.php at line 352
XenForo_ViewRenderer_Abstract::hasManualDeferredToRun() in XenForo/ViewRenderer/Json.php at line 147
XenForo_ViewRenderer_Json::_addDefaultParams() in XenForo/ViewRenderer/Json.php at line 185
XenForo_ViewRenderer_Json::jsonEncodeForOutput() in XenForo/ViewAdmin/Error/ServerError.php at line 47

Thanks1

 

[Jake Bunce]

@jaymsgq

Hmm. Check your xf_user table. Check the values for user_group_id and secondary_group_ids. The first should be an integer number, and the second should be a comma list of integers. It's possible something went wrong with your import and resulted in bad values for these columns.

 

[jaymsgq]

Thanks Jake. Is there a option to re import user groups in Big Board Importer or I should import everything or Just users?
1 - Posts
2 - Users
3 - Threads
4 - Private Messages
5 - Avatars
6 - Attachments
7 - Forums
8 - Miscellaneous
9 - Everything

 

[Ludachris]

I've read through some posts in this thread suggesting upgrading to at least MySQL 5.5. I recently upgraded PHP and it broke some of the functionality of the plugins for my vB 3.8 site, but it had to be done to use this script (to get the PCNTL extension) - the server is now running PHP 5.3.27. Will upgrading MySQL cause any issues? Which version of 5.5 should I upgrade to exactly?

 

[Ludachris]

Then I suggest taking the desired modules from the unofficial vB4 importer and copying them into the official vB3 importer for your purpose. The two schemas are virtually identical so they will probably copy without any code changes needed.

So if I am going to use the big board importer to import from 3.8, theoretically, could I copy/paste the blogs module code from the unofficial vB4 importer to the official vB3 importer and only run the blog importer (to import blogs as threads) via the Tools > Import External Data in AdminCP? What would the appropriate order of operation be assuming you're using the big board importer?

 

[Ludachris]

My 'field2' in vB is set up as a select menu with roughly 60 location options that are used for filtering. I found that importing this field using the standard importer means I lose the select menu because admins have no control over the 'location' field in XF for some reason. It's a plain text field that cannot be customized. I need it to remain a select menu after import and I need to make it required. If that means importing it as a different custom field in XF and not using the default XF location field, that's fine with me if it's possible.

To import custom fields I know I need to edit the Export file. To import a select menu file with 60 options, how would I structure it? I found this code from another reply in this thread:

exec('mysql -h' . $this->slaveDbHost . ' ' . $this->sourceDb . ' ' . $this->sourceDBuser . ' ' . $this->sourceDBpassword . ' -N -q -e "SET NAMES binary;SELECT SQL_NO_CACHE userid AS user_id, \'xenforofieldname\' AS field_id, IF(field5 = 1, \'Yes\', \'No\') AS field_value FROM userfield ORDER BY userid" ' . self::$extraOutCommand . ' >> ' . self::$dataDir . 'xf_user_field_value.txt');

Would I just change the IF(field5 = 1, \'Yes\', \'No\') in the code above to something like IF(field2 = 1, \'Option1\', \'Option2\', \'Option3\', \'Option60\', )? And just fill in all of the available options? Can I import it as a different field and simply not map anything to the default XF location field, then hide that field? Would that cause any issues?

 

[Jake Bunce]

Thanks Jake. Is there a option to re import user groups in Big Board Importer or I should import everything or Just users?
1 - Posts
2 - Users
3 - Threads
4 - Private Messages
5 - Avatars
6 - Attachments
7 - Forums
8 - Miscellaneous
9 - Everything

The big board importer doesn't do usergroups. You must create them manually in your XF Admin CP before running the import.

 

[Jake Bunce]

Will upgrading MySQL cause any issues?

Doubtful.

 

[Ludachris]

Doubtful.

Thanks @Jake Bunce - I'm going to upgrade and cross my fingers. Any advice on 605 and 606 above?

 

[Ludachris]

Anyone have advice on post 605 and 606 above? I'm waiting on some replies so I can move forward on this.

 

[Jake Bunce]

My 'field2' in vB is set up as a select menu with roughly 60 location options that are used for filtering. I found that importing this field using the standard importer means I lose the select menu because admins have no control over the 'location' field in XF for some reason. It's a plain text field that cannot be customized. I need it to remain a select menu after import and I need to make it required. If that means importing it as a different custom field in XF and not using the default XF location field, that's fine with me if it's possible.

To import custom fields I know I need to edit the Export file. To import a select menu file with 60 options, how would I structure it? I found this code from another reply in this thread:

exec('mysql -h' . $this->slaveDbHost . ' ' . $this->sourceDb . ' ' . $this->sourceDBuser . ' ' . $this->sourceDBpassword . ' -N -q -e "SET NAMES binary;SELECT SQL_NO_CACHE userid AS user_id, \'xenforofieldname\' AS field_id, IF(field5 = 1, \'Yes\', \'No\') AS field_value FROM userfield ORDER BY userid" ' . self::$extraOutCommand . ' >> ' . self::$dataDir . 'xf_user_field_value.txt');

Would I just change the IF(field5 = 1, \'Yes\', \'No\') in the code above to something like IF(field2 = 1, \'Option1\', \'Option2\', \'Option3\', \'Option60\', )? And just fill in all of the available options? Can I import it as a different field and simply not map anything to the default XF location field, then hide that field? Would that cause any issues?

This script doesn't create custom fields. The fields must be manually created in your XF Admin CP. Then you can edit that code in the Export script to bring over the values for the field you created.

 

[Jake Bunce]

So if I am going to use the big board importer to import from 3.8, theoretically, could I copy/paste the blogs module code from the unofficial vB4 importer to the official vB3 importer and only run the blog importer (to import blogs as threads) via the Tools > Import External Data in AdminCP? What would the appropriate order of operation be assuming you're using the big board importer?

You are using the big board importer which is completely different than the web-based importer. As such, a direct copy paste of a web-based import step won't work. Custom programming is needed.

 

[jaymsgq]

Hi Jake,
I created the usergroups and re ran the Export.php I still get the same error when rebuilding cache or importing a style.
An exception occurred: Mysqli statement execute error : Incorrect integer value: '' for column 'user_group_id' at row 2 in /apps/apache/forum/xenbig_printer/library/Zend/Db/Statement/Mysqli.php on line 214

Also I see this error in the server log
ErrorException:Undefined offset: 11 -Export.php:373
Generated By: Unknown Account,20 minutes ago

Thanks

The big board importer doesn't do usergroups. You must create them manually in your XF Admin CP before running the import.

Jake

 

[Slavik]

Hi Jake,
I created the usergroups and re ran the Export.php I still get the same error when rebuilding cache or importing a style.
An exception occurred: Mysqli statement execute error : Incorrect integer value: '' for column 'user_group_id' at row 2 in /apps/apache/forum/xenbig_printer/library/Zend/Db/Statement/Mysqli.php on line 214

Also I see this error in the server log
ErrorException:Undefined offset: 11 -Export.php:373
Generated By: Unknown Account,20 minutes ago

Thanks


Jake

Looks like you havent mapped the user id groups in the import settings.

 

[Ludachris]

This script doesn't create custom fields. The fields must be manually created in your XF Admin CP. Then you can edit that code in the Export script to bring over the values for the field you created.

Set up a custom select field in the user profile where data will be imported. When you configure a select menu option in XF you have the value and the text. The value cannot have spaces. I know for a fact that some of the field values that get imported will have spaces based on how it was set up in vB. Will that cause a conflict on the import?

 

[jaymsgq]

Looks like you havent mapped the user id groups in the import settings.

Thanks Slavik.

 

[Jake Bunce]

Set up a custom select field in the user profile where data will be imported. When you configure a select menu option in XF you have the value and the text. The value cannot have spaces. I know for a fact that some of the field values that get imported will have spaces based on how it was set up in vB. Will that cause a conflict on the import?

After creating the field in XF, edit some users and select some values to see how XF stores those values in xf_user_field_value. Then the Export needs to be made to write out those same values.

 

[Ludachris]

After creating the field in XF, edit some users and select some values to see how XF stores those values in xf_user_field_value. Then the Export needs to be made to write out those same values.

Well that's just it - when setting up the select options I had to use underscores since spaces weren't allowed for values. Some of the imported data is going to have spaces for that field, since spaces were allowed in vB. So will I need to modify the script so that it replaces spaces with underscores when it imports that data? Any suggestions on the code to use for that?

 

[Ludachris]

If I run into a database error running Export.php in the middle of attachments should I just run Export.php and choose All again?

 

[Ludachris]

Attaching the errors via a PDF file...

I just tried the Export.php and Import.php again for the hell of it. Got these same errors with console text mixed in and cannot login to the site. The Import.php file took 13 seconds to run. My user account is set as a SuperAdmin in config.php. I'm not sure why I cannot login, nor do I understand these errors. Slavik, I guess I'll have to wait for our appointment. I really wish I could get this importer to work.