How to Convert from XenFORO

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Anti-Spam Guide
ashkir
Registered User
Posts: 11
Joined: Sun Sep 02, 2012 10:57 pm

Re: How to Convert from XenFORO

Post by 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
Registered User
Posts: 11
Joined: Sun Sep 02, 2012 10:57 pm

Re: How to Convert from XenFORO

Post by 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
Registered User
Posts: 1
Joined: Fri Jul 11, 2014 4:51 pm

Re: How to Convert from XenFORO

Post by 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".
User avatar
Meis2M
Translator
Posts: 1012
Joined: Wed Mar 03, 2010 11:32 am
Location: IR.Damghan
Name: میثم نوبری

Re: How to Convert from XenFORO

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

phpBB persian international support
Follow us in Instagram
Free upgrade and install extensions on your forum - drop me PM
Ultimate phpBB SEO Friendly URL extension
Swanny
Registered User
Posts: 486
Joined: Sun Apr 14, 2002 2:11 am
Location: Canada

Re: How to Convert from XenFORO

Post by 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
Registered User
Posts: 2
Joined: Fri May 11, 2012 12:04 pm
Location: CZ

Re: How to Convert from XenFORO

Post by 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
Registered User
Posts: 1
Joined: Mon Feb 16, 2015 3:10 pm

Re: How to Convert from XenFORO

Post by E&N »

prototech wrote: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
Registered User
Posts: 61
Joined: Fri Feb 20, 2015 1:09 pm

Re: How to Convert from XenFORO

Post by TopSpace »

what made move from great supported and module plugged Xenforo to a phpBB?
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26846
Joined: Fri Aug 29, 2008 9:49 am

Re: How to Convert from XenFORO

Post by Mick »

TopSpace wrote:what made move from great supported and module plugged Xenforo to a phpBB?
Cost would be a big decision maker I guess.
  • "The more connected we get the more alone we become” - Kyle Broflovski© 🇬🇧
Megan1967
Registered User
Posts: 5
Joined: Sun Aug 11, 2013 4:39 am

Re: How to Convert from XenFORO

Post by 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
Registered User
Posts: 5
Joined: Sun Aug 11, 2013 4:39 am

Re: How to Convert from XenFORO

Post by 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
Registered User
Posts: 5
Joined: Sun Aug 11, 2013 4:39 am

Re: How to Convert from XenFORO

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


User avatar
Lumpy Burgertushie
Registered User
Posts: 69228
Joined: Mon May 02, 2005 3:11 am

Re: How to Convert from XenFORO

Post by 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
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
msibm
Registered User
Posts: 143
Joined: Sat Aug 24, 2002 11:35 am

Re: How to Convert from XenFORO

Post by msibm »

prototech wrote: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?

Return to “[3.0.x] Convertors”