Skip to:
Content
Pages
Categories
Search
Top
Bottom

Newbb (xoops) convert to bbpress


  • Michał
    Participant

    @hadesteam

    Good morning, my name is Michael and I am writing from a distant country of Poland :). I have a website dedicated to bodybuilding based on xoops, but I will soon change to wordpress. I have converted all 1200 articles, comments and users, but I have a problem moving forums …

    The newbb script is similar to phpbb, so I used the available converter in the admin panel, I modified it a little, basically the beginning of the category and description of the forum sections. It looks like:
    http://www.kulturystyka.org.pl/test/forums/

    Further modification of the phpBB.php file unfortunately did not produce the expected results, because the newbb script has changed a bit, and the converter in the BBpress package is probably not updated for a long time ….?

    Please help me to modify this file so that it finishes work ie it has moved topics, utterances and users. Below I show how the structure of individual tables in the newbb module (xoops) looks like. I am green in terms of these matters, I am surprised myself that I have moved the forum sections. My WP version is 4.7.3

    I found something like this: https://bbpress.trac.wordpress.org/browser/trunk/src/includes/admin/converters/Example.php?order=name

    Yesterday and today I’m struggling with it …

    I will be very, but very grateful for the help shown. Regards, Michal

    Link to the structure of table; posts, posts_text, topics and users:
    http://www.kulturystyka.org.pl/newbb_table_structure.txt

Viewing 23 replies - 1 through 23 (of 23 total)
  • Hi,
    Check out https://codex.bbpress.org/getting-started/importing-data/import-forums/
    If your source forum is not in the list, there is a custom importer.

    Let us know if it works or not !

    Pascal.


    Michał
    Participant

    @hadesteam

    Unfortunately, under the link that you provided, there is no script that I am currently using. I tried to modify the converter from phpBB.php and Example.php, but unfortunately I get errors … I need your help! I am determined to have a forum based on bbpress (100k posts, 10k topics).

    I read a lot about migration, I tried to move the whole thing from newbb to phpbb, mybb, smf, but these forums also do not have a converter.

    Only someone who deals with daily php and programming can help me.

    First up, if you use bbPress 2.6 beta there are huge updates to the importer 🙂

    You can download bbPress 2.6 beta from https://bbpress.org/download/

    I’d suggest you look at either the phpBB or SMF importers, the two of those are the best examples that uses as much functionality as possible.

    I’ll take a look at that table structure you posted later today and see if I can make some suggestions to help, p.s. very helpful that you posted that, so thanks 🙂


    Michał
    Participant

    @hadesteam

    I already installed this beta. Tomorrow, as soon as I get up, I’ll make coffee, I’ll try with those converters, but I doubt I’ll succeed … I’ll be grateful for any help shown. I think that such a “newbb” forum converter will in the future help other users. I will keep you updated on progress or lack thereof 🙂


    Michał
    Participant

    @hadesteam

    I took the phpBB.php modification. I replaced the names of 3 tables in the database: from “xoops_bb_posts” to “posts”, from “xoops_bb_posts_text” to “posts_text”, from “xoops_bb_topics” to “topics”.

    I am working on a converter, converting a forum category -> OK, the first error appears when it starts to convert topics:

    Błąd bazy danych WordPressa: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN posts_text AS posts_text USING (topic_id) WHERE posts.post_id = topic' at line 1]
    SELECT convert(topics.topic_id USING "mypass") AS topic_id,convert(topics.topic_replies USING "mypass") AS topic_replies,convert(topics.forum_id USING "mypass") AS forum_id,convert(topics.topic_poster USING "mypass") AS topic_poster,convert(topics.poster_name USING "mypass") AS poster_name,convert(posts.poster_ip USING "mypass") AS poster_ip,convert(posts_text.post_text USING "mypass") AS post_text,convert(topics.topic_title USING "mypass") AS topic_title,convert(topics.topic_status USING "mypass") AS topic_status,convert(topics.topic_type USING "mypass") AS topic_type,convert(topics.topic_time USING "mypass") AS topic_time,convert(topics.topic_last_post_time USING "mypass") AS topic_last_post_time FROM topics AS topics INNER JOIN posts AS posts USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id INNER JOIN posts_text AS posts_text USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id LIMIT 0, 100

    It seems to me that the problem is because the “newbb” system uses two tables to display the response content: xoops_bb_posts and xoops_bb_posts_text. The structures are both here; http://www.kulturystyka.org.pl/newbb_table_structure.txt


    Michał
    Participant

    @hadesteam

    Hi,

    I just edit file Example.php but when try import data it says: No topic converters. Look at this file please and help me.
    http://www.kulturystyka.org.pl/Example.zip


    Michał
    Participant

    @hadesteam

    Really no one can help me? I am very interested in it, I am writing in the help forum, but I did not get it. After all, the people who wrote all the converters will certainly be able to modify one of them. It’s only been a few days since I created the topic, maybe too soon I would like the forum to work on bbpress script …. However, I hope that there will be a person willing to help. Regards, Michal sorry for my english 🙂


    Michał
    Participant

    @hadesteam

    Stephen Edgar where are You?

    Hi @hadesteam,

    I’m currently building a converter from google groups to bbPress. When I finish that one I might have a look to help you. Can you drop me an email so we keep in touch. You can find my email on http://casier.eu/wp-dev/

    Thanks.


    Michał
    Participant

    @hadesteam

    OK no problem ;-))))))))))))

    I had to wait more than a month, but hopefully it was worth it, I hope … it only left me.


    Michał
    Participant

    @hadesteam

    I still need help with migrate forum xoops newbb to bbpress, it`s similar mysql structure like phpbb. I can pay for help. My mail: michal [ at ] kulturystyka.org.pl

    Best ragards.


    Angelo Rocha
    Participant

    @angelorocha

    I’m worging on WP plugin to convert this:

    https://github.com/angelorocha/xoopstowp


    Michał
    Participant

    @hadesteam

    I am impressed, tell me if you can only choose a forum for migration or immediately migrate the entire content of xoops? It works ? This is for free ?

    Angelo, we know each other from the xoops forum, I use your xboostrap template 🙂


    Michał
    Participant

    @hadesteam

    I do not hide that I care about the time when you plan to finish this project? I mean only to move the content of the forum (sections, topics, speeches and users).


    Angelo Rocha
    Participant

    @angelorocha

    This plugin is already functional, I’m working on a user-friendly interface, currently only works with some programming settings.
    This site: https://www.guiadocftv.com.br/
    It was migrated successfully using my plugin. At the moment I’m running out of time to finish it, as I’m involved in other WordPress projects, it’s how I make my living.

    This plugin is under GPL license, anyone from this forum can help in its finalization. Any doubts I am available.


    Michał
    Participant

    @hadesteam

    Yesterday I installed this plugin, but I do not see any migration option anywhere … I am asking you for help, I can give data to my server, phpmyadmin etc.

    Comments on the xoops module “news” also this plugin moves?

    I am waiting 2 years on this forum for any help! sick… I thought that it helps people here

    I would like to finally go on wordpress and bbpress.

    Please Angelo Rocha help me, You are the last man who gonna make this, i migrate all articles with comments and users, i need migrate only module NEWBB.

    Best regards. You can find my e-mail previous message.


    Michał
    Participant

    @hadesteam

    I can pay via paypal for Your job/time.

    You know how to do it, you have experience, I’m unfortunately not a programmer, I hope you help me.


    Angelo Rocha
    Participant

    @angelorocha

    Hi Michal.
    I speak with you by email, now I’m in my job, tonight i reply you. Sorry for my horrible english =D

    Thanks.


    Michał
    Participant

    @hadesteam

    OK no problem. I am from Poland and using google translate sometimes. I am glad You speak to me by mail. I wanna finally move to wordpress. I hope with Your help my dream come true.

    Regards and thanks for reply.


    geggino
    Participant

    @geggino

    Hi Angelo. I had read this topic years ago, hoping for a solution and now I have fortunately found your project.
    I installed the plugin, but the lack of documentation doesn’t help me. I don’t understand where and how to enter the parameters of the xoops site.Where should I upload the old xoops site?
    Can you please explain how can I proceed?
    I would like to move users and all the contents of the old newbb forum (there are 3334 topics and 35950 messages).
    Articles, images and more I could also move them manually.
    Thanks very much!
    Cristian


    Angelo Rocha
    Participant

    @angelorocha

    This week i’will update the plugin to put a user interface in admin page.
    Another adjusts be necessary to detect XOOPS data, in Michal site, the site url field is different from what was programmed in the plugin, these adjustments are necessary so that you do not need a programmer for you to migrate your site.

    To start the migration you need to install WordPress in the same base of your site xoops, change the table prefix. Check if in the plugin panel it will detect the URL of your site xoops.


    Jax Jay
    Participant

    @ghostjax

    Nice post! a friend from https://abokiplay.com/ directed me here


    geggino
    Participant

    @geggino

    ok thanks Angelo for your reply.
    I’ll wait for the interface update. I am sure that your work will help many users.

Viewing 23 replies - 1 through 23 (of 23 total)
  • You must be logged in to reply to this topic.
Skip to toolbar