Page 1 of 2

How to Convert from XenFORO

Posted: Sat Feb 02, 2013 4:42 pm
by censorious
Hello,
i would like to know if it is possible to carry over the members from XeNForo
Thanks

Re: How to Convert from XenFORO

Posted: Sat Feb 02, 2013 8:54 pm
by prototech
We do not have a XenForo convertor available at this time. However, I will start working on one in the next few days so please check back in the next week or two for an update on that. :)

Re: How to Convert from XenFORO

Posted: Sun Feb 03, 2013 12:42 am
by nextgen
prototech wrote:We do not have a XenForo convertor available at this time. However, I will start working on one in the next few days so please check back in the next week or two for an update on that. :)
I recently move from xenforo to phpbb :)
But what I did was to migrate xenforo to vbulletin 4 and then to phpbb :lol:
If you want to a guinea pig here we are to the order. :)

Re: How to Convert from XenFORO

Posted: Sat Mar 02, 2013 3:29 pm
by Rusty105
Any update on this?

Re: How to Convert from XenFORO

Posted: Sat Mar 02, 2013 10:13 pm
by prototech
Sorry, I was interrupted with the vBulletin 4 converter so I haven't had a chance to take a look at this. I should have some time to start working on it in the next few days now that the vB converter is in a working state. :)

Re: How to Convert from XenFORO

Posted: Mon Mar 04, 2013 7:27 pm
by Rusty105
Sounds good!

Re: How to Convert from XenFORO

Posted: Thu Apr 18, 2013 7:01 pm
by Zapy_
prototech wrote:Sorry, I was interrupted with the vBulletin 4 converter so I haven't had a chance to take a look at this. I should have some time to start working on it in the next few days now that the vB converter is in a working state. :)
April now, any news on this? :)

Re: How to Convert from XenFORO

Posted: Fri Jul 12, 2013 7:31 pm
by prototech
Here is the initial version of the convertor. Please let me know if you encounter any errors. :)
xenforo11_convertor_0.0.2.zip
(21.21 KiB) Downloaded 1500 times

Re: How to Convert from XenFORO

Posted: Sat Jul 13, 2013 4:20 am
by nextgen
Hi Cesar,

I'm doing some testing on localhost and get me this error at the start of the 9 steps.

Code: Select all

General Error
SQL ERROR [ mysqli ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

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

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/dbal.php
LINE: 432
CALL: dbal->sql_error()

FILE: [ROOT]/install/convertors/functions_xenforo11.php
LINE: 842
CALL: dbal->sql_in_set()

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

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

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

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

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

FILE: [ROOT]/install/index.php
LINE: 203
CALL: module->load()
Regards and good job :)

Edit: After this step get me the above error.

Code: Select all

			xf_fix_pm_multi_recipients(false, true);

Re: How to Convert from XenFORO

Posted: Sat Jul 13, 2013 2:43 pm
by prototech
Thanks for testing it. I have updated the download with a fixed version.

Re: How to Convert from XenFORO

Posted: Sat Jul 13, 2013 5:49 pm
by nextgen
Cesar Is it normal that the forums will not be displayed?
Board wrote:This board has no forums.
Or you must assign the permissions that were not transferred during the conversion. :geek:

Re: How to Convert from XenFORO

Posted: Sat Jul 13, 2013 9:11 pm
by prototech
That's correct, the converter will not attempt to convert any permissions.

Re: How to Convert from XenFORO

Posted: Sun Jul 14, 2013 1:01 am
by nextgen
For the moment everything worked correctly. :)

Re: How to Convert from XenFORO

Posted: Thu May 08, 2014 6:20 pm
by ashkir
We still have 1.1 and we get an error :(
SQL ERROR [ mysqli ]

Unknown column 'forum_options' in 'field list' [1054]

SQL

INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_status, forum_link, left_id, right_id, forum_posts, forum_flags, forum_options, enable_prune, prune_next, prune_days, prune_viewed, prune_freq, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, display_on_index, enable_indexing, enable_icons) VALUES (3, ' Home', 0, '', '', 0, 0, '', 239, 270, 0, 34, 0, 0, 0, 0, 0, 0, '', 7, '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 0)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/convertors/functions_xenforo11.php
LINE: 236
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1003) : eval()'d code
LINE: 3
CALL: xf_insert_forums()

FILE: install/install_convert.php
LINE: 1003
CALL: eval()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
CALL: module->load()

Re: How to Convert from XenFORO

Posted: Tue Jun 10, 2014 6:27 pm
by ashkir
Tried again on an offline conversion got this this time:

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_convert.php on line 546: Missing argument 3 for _import_check(), called in [ROOT]/install/convertors/functions_xenforo11.php on line 317 and defined
[phpBB Debug] PHP Warning: in file [ROOT]/includes/db/mysqli.php on line 247: Illegal offset type in isset or empty
[phpBB Debug] PHP Warning: in file [ROOT]/includes/db/mysqli.php on line 302: Illegal offset type in isset or empty
Return to the index page
General Error
SQL ERROR [ mysqli ]

Column 'smiley_width' cannot be null [1048]

SQL

INSERT INTO phpbb_smilies (code, emotion, smiley_url, smiley_width, smiley_height, smiley_order, display_on_posting) VALUES (':)', 'Smile', '/images/smilies/Grin.png', NULL, NULL, 1, 1), (':-)', 'Smile', '/images/smilies/Grin.png', NULL, NULL, 2, 1), ('(:', 'Smile', '/images/smilies/Grin.png', NULL, NULL, 3, 1)

BACKTRACE

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

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/dbal.php
LINE: 550
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/install/convertors/functions_xenforo11.php
LINE: 339
CALL: dbal->sql_multi_insert()

FILE: [ROOT]/install/install_convert.php(1003) : eval()'d code
LINE: 5
CALL: xf_convert_smilies()

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

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

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

FILE: [ROOT]/install/index.php
LINE: 203
CALL: module->load()
Edit: I found a solution I believe:
I completely commented function xf_convert_smilies() in functions and the other file I removed: xf_convert_smilies();
smilies aren't important we can always readd em :)