vBulletin 3.8.4 to PhpBB3.1

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
User avatar
FredQ
Registered User
Posts: 104
Joined: Sat Nov 01, 2014 10:48 am
Location: Northeast Scotland
Name: Fred Q
Contact:

Re: vBulletin 3.8.4 to PhpBB3.1

Post by FredQ » Sun Aug 16, 2015 7:16 pm

opperpanter wrote: Thanks, might work for me as well.
I've done it that way because there was a conversion to do, from a number of pages to a number of posts to skip when viewing threads (it's an easy conversion, but my apache rewrite skills are fairly limited)

Anyway, it's available there.

I'm not posting it in the official extensions, there's no point since the importer has never been validated (and I suspect it might never be, probably because no member of the phpBB team has access to an old installation of vBulletin)
Successfully converted my board from vBulletin v3 ;)

maggos
Registered User
Posts: 2
Joined: Tue Oct 06, 2015 3:21 pm

Re: vBulletin 3.8.4 to PhpBB3.1

Post by maggos » Tue Oct 06, 2015 3:25 pm

Hi,

VB Version 3.8.5

Code: Select all

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Incorrect string value: '\xE4hen:' for column 'code' at row 58 [1366]

SQL

...
Can You help plese?
Thank you

Markus

bugmenot
Registered User
Posts: 17
Joined: Tue Jan 22, 2008 4:55 pm

Re: vBulletin 3.8.4 to PhpBB3.1

Post by bugmenot » Tue Oct 06, 2015 8:31 pm

I have the same error, please help!

vBulletin 3.8.9 to phpBB 3.1.6

Error message:

Code: Select all

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Incorrect string value: '\xFCnsche' for column 'folder_name' at row 8 [1366]

SQL



BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 650
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/convertors/functions_vb3.php
LINE: 2207
CALL: phpbb\db\driver\driver->sql_multi_insert()

FILE: [ROOT]/install/install_convert.php(1100) : eval()'d code
LINE: 6
CALL: vb_convert_pm_folders()

FILE: [ROOT]/install/install_convert.php
LINE: 1100
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()
vb_conversion_log.txt:

Code: Select all

05/10/2015 23:40:53 - vb_version(): vBulletin version 389 detected.
05/10/2015 23:41:24 - get_src_db_table_encoding(): 195 table encoding loaded.
05/10/2015 23:41:24 - get_src_db_table_encoding(): 195 tables are using the character set 'latin1'.
05/10/2015 23:41:24 - vb_check_folders(): Attachments folder is './../files'
05/10/2015 23:41:24 - vb_check_folders(): Custom avatars folder is './../images/avatars/upload'
05/10/2015 23:41:24 - vb_check_folders(): Custom profile pictures folder is './../images/profile_pics'
05/10/2015 23:41:24 - vb_check_folders(): Signature pictures folder is './../images/signature_pics'
05/10/2015 23:41:24 - vb_check_folders(): All destination folders are writable.
05/10/2015 23:41:24 - vb_convert_forums(): 110 forum(s) found
05/10/2015 23:41:24 - vb_add_bbcodes(): Loaded 1 existing BBcodes.
05/10/2015 23:41:24 - vb_add_bbcodes(): BBcode 'font=' added.
05/10/2015 23:41:24 - vb_add_bbcodes(): BBcode 'align=' added.
05/10/2015 23:41:24 - vb_add_bbcodes(): BBcode 'indent' added.
05/10/2015 23:41:24 - vb_add_bbcodes(): BBcode 'sigpic' added.
05/10/2015 23:41:24 - vb_add_bbcodes(): BBcode hide already exists!
05/10/2015 23:41:24 - vb_add_bbcodes(): BBcode 'nfo' added.
05/10/2015 23:41:24 - vb_add_bbcodes(): BBcode 'flash' added.
05/10/2015 23:41:24 - vb_add_bbcodes(): BBcode 'spoiler' added.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/beitrag.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/pfeil.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/idee.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/ausrufezeichen.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/frage.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/cool.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/lächeln.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/böse.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/unglücklich.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/reden.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/rotes_gesicht.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/blinzeln.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/daumen_runter.gif' imported.
05/10/2015 23:41:24 - vb_import_icons(): icon 'imported/daumen_hoch.gif' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':dozey:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':T' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':confused:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':rolleyes:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':p' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':nea:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':rofl:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':scare:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':scare2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':sclerosis:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':scratch:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':search:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':secret:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':shout:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':resent:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':read:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':negative:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':no:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':not:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':offtopic:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':kiss:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':polling:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':popcorm1:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':popcorm2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':punish:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':smoke:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':snooks:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':sorry:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':sorry2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':stink:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':pleasantry:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':party:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':pardon:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':laugh:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':lazy:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':good:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':meeting:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':mosking:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':ok:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':yu:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':stop:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':superstition:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':swoon:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':swoon2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':mda:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':ireful2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':good2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':good3:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':heat:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':help:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':happy:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':ireful:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':takeexample:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':clue:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':yes:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':yes2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':yes3:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':yes4:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':friends:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':fool:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':drinks:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':download:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':mention:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':dntknw:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':dirol:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':derisive:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':declare:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':yahoo:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':whistle3:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':taunt:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':thankyou:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':thankyou2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':this:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':dance:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':cray:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':clapping:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':censored:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':boredom:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':boast:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':blush2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':umnik2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':dance3:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':dance4:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':threaten:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':tongue:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':umbrage:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':umnik:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':unsure:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':victory:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':whistle:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':whistle2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':dance2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':blum3:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':aggressive:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':beee:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':blackeye:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':agree:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':acute:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':blush:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':airkiss:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':bad:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':blum2:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':hau:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':fuckyou:' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley '<3' imported.
05/10/2015 23:41:24 - vb_import_smilies(): smiley ':blueeye:' imported.
05/10/2015 23:42:19 - vb_version(): vBulletin version 389 detected.
05/10/2015 23:43:48 - get_src_db_table_encoding(): 195 table encoding loaded.
05/10/2015 23:43:48 - get_src_db_table_encoding(): 195 tables are using the character set 'latin1'.
06/10/2015 00:20:30 - vb_prepare_message(): Error converting BBCode 'QUOTE='

User avatar
FredQ
Registered User
Posts: 104
Joined: Sat Nov 01, 2014 10:48 am
Location: Northeast Scotland
Name: Fred Q
Contact:

Re: vBulletin 3.8.4 to PhpBB3.1

Post by FredQ » Tue Oct 06, 2015 9:17 pm

Hi!

Due to the lack of interest in this converter, I haven't done anything on it for quite a while (and also I converted my board with it now).

Can you send me the SQL query in error? you both removed it. Or PM me it if you prefer, and I'll have a look as soon as I have little time.
Successfully converted my board from vBulletin v3 ;)

maggos
Registered User
Posts: 2
Joined: Tue Oct 06, 2015 3:21 pm

Re: vBulletin 3.8.4 to PhpBB3.1

Post by maggos » Tue Oct 06, 2015 10:48 pm

*edit*

I delete all smileys in vb and then it works.

but...

Code: Select all

Allgemeiner Fehler
Unknown encoding:

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/utf/utf_tools.php
LINE: 732
CALL: trigger_error()

FILE: [ROOT]/install/convertors/functions_vb3.php
LINE: 623
CALL: utf8_recode()

FILE: [ROOT]/install/convertors/functions_vb3.php
LINE: 1014
CALL: vb_set_encoding_from_source()

FILE: (not given by php)
LINE: (not given by php)
CALL: vb_prepare_message()

FILE: [ROOT]/install/install_convert.php
LINE: 2059
CALL: call_user_func_array()

FILE: [ROOT]/install/install_convert.php
LINE: 1306
CALL: install_convert->process_row()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()
there is a problem with UTF8, right?

User avatar
FredQ
Registered User
Posts: 104
Joined: Sat Nov 01, 2014 10:48 am
Location: Northeast Scotland
Name: Fred Q
Contact:

Re: vBulletin 3.8.4 to PhpBB3.1

Post by FredQ » Wed Oct 07, 2015 8:26 am

maggos wrote: there is a problem with UTF8, right?
Yes it can't detect your encoding for some reason. I believe a few things have changed between vBulletin 3.7 (the one I had) and 3.8 :roll:
Successfully converted my board from vBulletin v3 ;)

Loony BoB
Registered User
Posts: 1
Joined: Thu Nov 12, 2015 11:37 am

Re: vBulletin 3.8.4 to PhpBB3.1

Post by Loony BoB » Thu Nov 12, 2015 11:40 am

I'm getting the following error... this pops up at the "Processing last statements" stages.

Code: Select all

General Error
SQL ERROR [ mysqli ]

Out of range value for column 'poll_option_total' at row 1 [1264]

SQL

INSERT INTO phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) VALUES (10,536,'A quick-fix resolution of sorts',2147483647)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/install/convertors/functions_vb3.php
LINE: 1674
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1688) : eval()'d code
LINE: 2
CALL: vb_import_polloption()

FILE: [ROOT]/install/install_convert.php
LINE: 1688
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 823
CALL: install_convert->jump()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()
If anyone would be able to assist I'd greatly appreciate it :)

EDIT: Perhaps worth noting I'm upgrading from vB3.7 also. So that's probably the source of the problem, judging by your recent posts. :(

EDIT: Tried converting from 3.8, same problem :S

User avatar
FredQ
Registered User
Posts: 104
Joined: Sat Nov 01, 2014 10:48 am
Location: Northeast Scotland
Name: Fred Q
Contact:

Re: vBulletin 3.8.4 to PhpBB3.1

Post by FredQ » Sun Nov 29, 2015 9:45 pm

That number, 2147483647 looks like a "-1" converted to an unsigned int. I don't know why it's doing that. I should have a look at some point, but I really don't have much time right now. (Also I kind of left this project on the side because of the lack of interest about it).
Successfully converted my board from vBulletin v3 ;)

msibm
Registered User
Posts: 143
Joined: Sat Aug 24, 2002 11:35 am
Location: China
Contact:

Re: vBulletin 3.8.4 to PhpBB3.1

Post by msibm » Thu Dec 31, 2015 8:55 am

FredQ wrote:Good news everyone!
A new version of the converter is now ready to test.
You can download it from there:
https://github.com/gouarfig/vb3-to-phpB ... 0.0.15.4.5
Is this version of 1.0.0.15.4.5 the latest version?
Thanks a lot to Fred for the great work for the old vbulletin users!

msibm
Registered User
Posts: 143
Joined: Sat Aug 24, 2002 11:35 am
Location: China
Contact:

Re: vBulletin 3.8.4 to PhpBB3.1

Post by msibm » Sat Jan 02, 2016 9:33 pm

I have taken a try to convert from vB 3.8.5. There are 57485 users and 321956 posts in my forum.

On the step 5 of processing last statements, there are error:

General Error
SQL ERROR [ mysqli ]

Column 'forum_id' cannot be null [1048]

SQL

INSERT INTO phpbb_log (log_id, log_type, user_id, forum_id, topic_id, reportee_id, log_ip, log_time, log_operation, log_data) VALUES (59948, 0, 74, 0, 0, 0, '', '1258300174', 'LOG_USER_WARNING', 'a:1:{i:0;s:6:\"wxm003\";}'), (59949, 3, 74, 0, 0, 16118, '', '1258300174', 'LOG_USER_WARNING_BODY', 'a:1:{i:0;s:0:\"\";}'), (59950, 1, 74, NULL, '21711', 0, '', '1258300174', 'LOG_USER_WARNING', 'a:1:{i:0;s:6:\"wxm003\";}')

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 650
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/convertors/functions_vb3.php
LINE: 3668
CALL: phpbb\db\driver\driver->sql_multi_insert()

FILE: [ROOT]/install/install_convert.php(1688) : eval()'d code
LINE: 2
CALL: vb_convert_infractions()

FILE: [ROOT]/install/install_convert.php
LINE: 1688
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 823
CALL: install_convert->jump()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()

User avatar
FredQ
Registered User
Posts: 104
Joined: Sat Nov 01, 2014 10:48 am
Location: Northeast Scotland
Name: Fred Q
Contact:

Re: vBulletin 3.8.4 to PhpBB3.1

Post by FredQ » Sat Jan 02, 2016 10:47 pm

The converter was developed for vBulletin 3.7, which was the version I was using. I tried to adapt it to vb 3.8 but never had the time to finish it before converting my own board. I would have a look at it if I had some time. If only I had some time to spare :roll:
Successfully converted my board from vBulletin v3 ;)

opperpanter
Registered User
Posts: 61
Joined: Fri Mar 06, 2015 5:09 pm

Re: vBulletin 3.8.4 to PhpBB3.1

Post by opperpanter » Wed Feb 15, 2017 10:33 am

Hi Fred,

I'm finally converting my board (almost 2 years later).

All is looking well, except that customer profile fields are not converted correctly.

In vbulletin I have a radio button field, with the data set like this:

a:14:{i:0;s:6:"Lantus";i:1;s:10:"Caninsulin";i:2;s:17:"Caninsulin VetPen";i:3;s:7:"Levemir";i:4;s:8:"Humuline";i:5;s:13:"Insuman Basal";i:6;s:7:"ProZinc";i:7;s:5:"niets";i:8;s:10:"was Lantus";i:9;s:14:"was Caninsulin";i:10;s:11:"was Levemir";i:11;s:12:"was Humuline";i:12;s:17:"was Insuman Basal";i:13;s:11:"was ProZinc";}


After conversion into phpbb I get this:

INSERT INTO `phpbb_profile_fields_lang` (`field_id`, `lang_id`, `option_id`, `field_type`, `lang_value`) VALUES
(14, 1, 0, 'profilefields.type.dropdown', 'Lantus'),
(14, 1, 1, 'profilefields.type.dropdown', 'Caninsulin'),
(14, 1, 2, 'profilefields.type.dropdown', 'Levemir'),
(14, 1, 3, 'profilefields.type.dropdown', 'Humuline'),
(14, 1, 4, 'profilefields.type.dropdown', 'Insuman Basal'),
(14, 1, 5, 'profilefields.type.dropdown', 'niets'),
(14, 1, 6, 'profilefields.type.dropdown', 'was Lantus'),
(14, 1, 7, 'profilefields.type.dropdown', 'was Caninsulin'),
(14, 1, 8, 'profilefields.type.dropdown', 'was Levemir'),
(14, 2, 0, 'profilefields.type.dropdown', 'Lantus'),
(14, 2, 1, 'profilefields.type.dropdown', 'Caninsulin'),
(14, 2, 2, 'profilefields.type.dropdown', 'Levemir'),
(14, 2, 3, 'profilefields.type.dropdown', 'Humuline'),
(14, 2, 4, 'profilefields.type.dropdown', 'Insuman Basal'),
(14, 2, 5, 'profilefields.type.dropdown', 'niets'),
(14, 2, 6, 'profilefields.type.dropdown', 'was Lantus'),
(14, 2, 7, 'profilefields.type.dropdown', 'was Caninsulin'),
(14, 2, 8, 'profilefields.type.dropdown', 'was Levemir');

But the optionids in phpbb_profile_fields_data are based on the values from vbulletin, so ranging from 0 to 14.

I think I can resolve this with some SQL queries, but it's something for others to be aware of and maybe somebody wants to fix it in the converter.

EDIT: Just realized that it might have to do with language settings or translations, will check.

Natallyia
Registered User
Posts: 1
Joined: Wed Apr 05, 2017 2:59 am

Re: vBulletin 3.8.4 to PhpBB3.1

Post by Natallyia » Wed Apr 05, 2017 3:06 am

Hi!
I have the error, please help! vBulletin 3.8.7 to phpBB 3.1.9

Code: Select all

Общая ошибка
Unknown encoding: utf8

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/utf/utf_tools.php
LINE: 869
CALL: trigger_error()

FILE: [ROOT]/install/convertors/functions_vb3.php
LINE: 623
CALL: utf8_recode()

FILE: [ROOT]/install/convertors/functions_vb3.php
LINE: 628
CALL: vb_set_encoding_from_source()

FILE: [ROOT]/includes/functions_convert.php(1291) : eval()'d code
LINE: 1
CALL: vb_set_encoding_from_setting()

FILE: [ROOT]/includes/functions_convert.php
LINE: 1291
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 1010
CALL: restore_config()

FILE: [ROOT]/install/install_convert.php
LINE: 214
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()

Post Reply

Return to “[3.1.x] Convertors”

Who is online

Users browsing this forum: No registered users and 1 guest