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 19 replies - 1 through 19 (of 19 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.

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