Page 5 of 6

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Sun Aug 16, 2015 7:16 pm
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)

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Tue Oct 06, 2015 3:25 pm
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

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Tue Oct 06, 2015 8:31 pm
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='

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Tue Oct 06, 2015 9:17 pm
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.

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Tue Oct 06, 2015 10:48 pm
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?

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Wed Oct 07, 2015 8:26 am
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:

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Thu Nov 12, 2015 11:40 am
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

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Sun Nov 29, 2015 9:45 pm
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).

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Thu Dec 31, 2015 8:55 am
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!

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Sat Jan 02, 2016 9:33 pm
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()

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Sat Jan 02, 2016 10:47 pm
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:

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Wed Feb 15, 2017 10:33 am
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.

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Wed Apr 05, 2017 3:06 am
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()

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Sat Jan 13, 2018 1:03 am
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

Re: vBulletin 3.8.4 to PhpBB3.1

Posted: Sat Jan 13, 2018 4:24 pm
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.