How to Convert from XenFORO

[ashkir]

"This webpage is not available"

When importing the posts it gets stuck. . And it times out and says webpage is not available. 2500 :[.

Gonna try converting to SMF since that worked fine and SMF>PHPBB again.

>_<

It's importing posts at 1 row/second. Is there a way to speed that up at all? .

At this rate this is 12 days...

[ashkir]

I wanted to thank you for this converter. It works nicely on localhost. However, it is painfully slow trying to convert a million posts. My ETA is 13 days to convert a million posts from xf_post to phpbb_posts. I wish there was a faster way. More I try the more it looks like phpBB is no longer an option worth considering if we keep running into walls trying to convert to it. :[. 1 rows/s (6000 rows)

// Batch size, can be adjusted by the conversion file
// For big boards a value of 6000 seems to be optimal
var $batch_size = 6000;
// Number of rows to be inserted at once (extended insert) if supported
// For installations having enough memory a value of 60 may be good.
var $num_wait_rows = 30;

Thank you though! I'm sure this converter would work fine for smaller forums. But, it simply is not feasible at this time. I tried XenForo -> SMF, that worked beautifully and fast. But, SMF -> phpBB was having issues, running into walls, etc.

Thank you to everyone that helped for their time.

[crisanmarius]

Could anyone please tell me why would anybody move their forum from paid script to free script ? I have read all over the internet that XenForo is the best script at this moment.
Thank you very much.

I am using phpbb3 and having mild "re-considerations".

[Meis2M]

error:

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'poll.multiple' in 'field list' [1054]

SQL

SELECT thread.thread_id, thread.node_id, thread.user_id AS poster_id, thread.title, thread.post_date, thread.view_count, thread.reply_count, thread.last_post_id, thread.discussion_open, thread.sticky, thread.first_post_id, post.post_date, poll.question, poll.close_date, poll.responses, poll.multiple FROM (xf_thread thread LEFT JOIN xf_poll AS poll ON (thread.thread_id = poll.content_id AND poll.content_type = "thread")) LEFT JOIN xf_post AS post ON (thread.last_post_id = post.post_id) WHERE (thread.discussion_type <> "redirect") ORDER BY thread.thread_id LIMIT 2000

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: 189
CALL: dbal->sql_error()

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

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

FILE: [ROOT]/install/install_convert.php
LINE: 1233
CALL: dbal->sql_query_limit()

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

[Swanny]

Just out of curiosity why are you switching to phpBB from Xenforo? I've been thinking of switching to Xenforo to get auto-resized pics on upload among other features.

[Ascalon]

Is this convertor working on XenForo version 1.4.3?

And I am not switching from XenForo to phpBB, I just need a testing platform.

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'forum_posts' 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, 'Hlavní kategorie', 0, '', '', 0, 0, '', 1, 8, 0, 34, 0, 0, 0, 0, 0, 0, '', 7, '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 0)

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]/install/convertors/functions_xenforo11.php
LINE: 236
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1028) : eval()'d code
LINE: 3
CALL: xf_insert_forums()

FILE: [ROOT]/install/install_convert.php
LINE: 1028
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()

[E&N]

Here is the initial version of the convertor. Please let me know if you encounter any errors.

xenforo11_convertor_0.0.2.zip

Hi
I need your help! I’d like to use your initial version of the convertor from XenForo 1.4.3. to phpBB. But I’m not a programmer (I’m a doctor). Explain me, how to do this, please.
What to do with downloaded files «install» and «included»?

Thank you very much

[TopSpace]

what made move from great supported and module plugged Xenforo to a phpBB?

[Mick]

what made move from great supported and module plugged Xenforo to a phpBB?

Cost would be a big decision maker I guess.

[Megan1967]

How do I use this converter. I've looked at the Convert How To viewtopic.php?f=65&t=1213555 article and thought I followed the steps exactly, but the Xenforo converter isn't an option after I've installed it.

I've never tried to convert a forum before, only set up new forums.

Thanks so much for the help in advance. Also to complicate things I don't know the version of Xenforo we were using. It was 6 years old though.

[Megan1967]

I figured out what I was doing wrong, but the original forum is not on this host. I have the database, but not the xenforo files. Can I convert still?

[Megan1967]

Okay. Now I have the old Xenforo forum up, but I get this error below. I assume this is because I am running a newer version of Xenforo. Is there any way to fix this. My aquarium hobbyist group has to switch forum platforms because of a long complicated story and it would be great if we could use phpBB.

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'forum_posts' 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 (1, 'Madison Area Aquatic Hobbyists', 0, '', 'These forums are all associated with MAAH news and events.', 0, 0, '', 5, 30, 0, 34, 0, 0, 0, 0, 0, 0, '', 7, '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 0)

BACKTRACE

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

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

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

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

FILE: [ROOT]/install/install_convert.php(1028) : eval()'d code
LINE: 3
CALL: xf_insert_forums()

FILE: [ROOT]/install/install_convert.php
LINE: 1028
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()

[Lumpy Burgertushie]

it looks like you may be trying to convert this staight to phpbb 3.1 instead of 3.0

there is no column named forum_posts in a phpbb 3.1 database but there is in a 3.0 database.

you have to convert your board to phpbb 3.0 first, then you upgrade phpbb 3.0 to phpbb 3.1


robert

[msibm]

Here is the initial version of the convertor. Please let me know if you encounter any errors.

xenforo11_convertor_0.0.2.zip

Does it work for xenforo 1.4.x?