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: 138
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 »

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)
My board (converted from vBulletin)
maggos
Registered User
Posts: 2
Joined: Tue Oct 06, 2015 3:21 pm

Re: vBulletin 3.8.4 to PhpBB3.1

Post by maggos »

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 »

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: 138
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 »

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.
My board (converted from vBulletin)
maggos
Registered User
Posts: 2
Joined: Tue Oct 06, 2015 3:21 pm

Re: vBulletin 3.8.4 to PhpBB3.1

Post by maggos »

*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: 138
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 »

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:
My board (converted from vBulletin)
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 »

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: 138
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 »

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).
My board (converted from vBulletin)
msibm
Registered User
Posts: 143
Joined: Sat Aug 24, 2002 11:35 am

Re: vBulletin 3.8.4 to PhpBB3.1

Post by msibm »

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

Re: vBulletin 3.8.4 to PhpBB3.1

Post by msibm »

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: 138
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 »

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:
My board (converted from vBulletin)
opperpanter
Registered User
Posts: 103
Joined: Fri Mar 06, 2015 5:09 pm

Re: vBulletin 3.8.4 to PhpBB3.1

Post by opperpanter »

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 »

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()
IldeNet
Registered User
Posts: 6
Joined: Sat Jul 20, 2013 7:08 pm

Re: vBulletin 3.8.4 to PhpBB3.1

Post by IldeNet »

Can you help me with this?

Code: Select all

SQL ERROR [ mysql4 ]

Column 'lang_name' cannot be null [1048]

SQL

INSERT INTO phpbb_profile_lang (field_id, lang_id, lang_name, lang_explain) VALUES (22, '1', NULL, NULL), (22, '2', NULL, NULL), (23, '1', NULL, NULL), (23, '2', NULL, NULL), (24, '1', NULL, NULL), (24, '2', NULL, NULL), (25, '1', NULL, NULL), (25, '2', NULL, NULL)

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/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

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

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

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

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()

thank you for you work
Last edited by bonelifer on Sat Jan 13, 2018 4:32 am, edited 1 time in total.
Reason: Please use CODE tags around large segments like this
User avatar
warmweer
Jr. Extension Validator
Posts: 11194
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: vBulletin 3.8.4 to PhpBB3.1

Post by warmweer »

IldeNet wrote: Sat Jan 13, 2018 1:03 am Can you help me with this?

Code: Select all

SQL ERROR [ mysql4 ]

Column 'lang_name' cannot be null [1048]

SQL

INSERT INTO phpbb_profile_lang (field_id, lang_id, lang_name, lang_explain) VALUES (22, '1', NULL, NULL), (22, '2', NULL, NULL), (23, '1', NULL, NULL), (23, '2', NULL, NULL), (24, '1', NULL, NULL), (24, '2', NULL, NULL), (25, '1', NULL, NULL), (25, '2', NULL, NULL)

BACKTRACE
The SQL error tells you exactly where the problem is.
The field lang_name cannot have a NULL value, so the insert fails.
Check the source database and fill these source fields with a language code (probably en )
Apparently the field lang_explain will also receive a NULL: >> check if that is allowed.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Locked

Return to “[3.1.x] Convertors”