[greenday2k]

is not complicated to move your topics and forums from forums Pro to Cpg Forums... Keep in mind that youll lose the subforums Features,Forums icons and so on, you have to rebuild your bbserachXXX tables. Re check and maybe Edit your permissions for all your Forums.

The best way is using phpmyadmin in two windows... of course working on a backed-up database. In each windows compare and edit the tables

prefix_fpro_forums to prefix_bbforums
(also you need to sep "parent" to zero in all forums)
prefix_fpro_categories to prefix_bbcategories
prefix_fpro_posts to prefix_bbposts
prefix_fpro_posts_text to prefix_bbposts_text
prefix_fpro_posts_notifications to prefix_bbposts_notifications

Compare the tables and delete the "extra colums" on the fpro tables, then delete the "original" _bbxxxx tables, rename the edited fprotables to bbxxxx.

Rebuild the bbsearchxxx tables using this script
dragonflycms.org/Forum...20/#140520

Edit the .htaccess file to point Forums_Pro Posts, Forums etc links to Cpg Forums.
CPg-

Ill try build a guide, but is not complicated.
Compare and delete colums, thats All.

[shooh]

greenday2k, when would your guide possibly be ready?

[shooh]

Here is a quick test according to greenday2k's instructions.

Below is the comparison between table structures of ForumsPro and CPG-BB



First, I dropped all underlined tables of CPG-BB except cms_bbsearch_wordlist and cms_bbsearch_wordmatch.

Code:

DROP TABLE cms_bbattachments, cms_bbattachments_desc, cms_bbauth_access, cms_bbcategories, cms_bbforums, cms_bbposts, cms_bbposts_text, cms_bbtopics, cms_bbtopics_watch, cms_bbvote_desc, cms_bbvote_results, cms_bbvote_voters;

Then, renamed all their equivalents from ForumsPro to CPG-BB:

Code:

RENAME TABLE cms_fpro_attachments TO cms_bbattachments;
RENAME TABLE cms_fpro_attachments_desc TO cms_bbattachments_desc;
RENAME TABLE cms_fpro_auth_access TO cms_bbauth_access;
RENAME TABLE cms_fpro_categories TO cms_bbcategories;
RENAME TABLE cms_fpro_forums TO cms_bbforums;
RENAME TABLE cms_fpro_posts TO cms_bbposts;
RENAME TABLE cms_fpro_posts_text TO cms_bbposts_text;
RENAME TABLE cms_fpro_topics TO cms_bbtopics;
RENAME TABLE cms_fpro_topics_watch TO cms_bbtopics_watch;
RENAME TABLE cms_fpro_vote_desc TO cms_bbvote_desc;
RENAME TABLE cms_fpro_vote_results TO cms_bbvote_results;
RENAME TABLE cms_fpro_vote_voters TO cms_bbvote_voters;

Checked the URL index.php?name=Forums which worked without any error and the forum loaded perfectly. What I didn't do is rebuilding the wordlist and wordmatch tables (yet). And my ForumsPro had no subforums.

[CatchImran]

Tried this and it does seem to work. But there seems to be a small problem. I seem to be missing this table

cms_fpro_attachments_desc

What does it exactly do? I have left the standard cms_bbattachments_desc table while I look for more answers! Help appreciated.

[CatchImran]

Just realized that I am using FPro 2.0.0.1. Could this be related to the different version as you have attempted this on 1.0.0.3

[shooh]

CatchImran wrote:

Tried this and it does seem to work. But there seems to be a small problem. I seem to be missing this table

cms_fpro_attachments_desc

What does it exactly do? I have left the standard cms_bbattachments_desc table while I look for more answers! Help appreciated.

Attachments' description

[Phoenix]

revived

[Otzelott]

The thread looks quite old, but i was searching for hours for an solution to konvert Forumspro v2.0.1 to Regular Dragonfly 9.2.1.

Quote:

prefix_fpro_forums to prefix_bbforums
(also you need to sep "parent" to zero in all forums)
prefix_fpro_categories to prefix_bbcategories
prefix_fpro_posts to prefix_bbposts
prefix_fpro_posts_text to prefix_bbposts_text
prefix_fpro_posts_notifications to prefix_bbposts_notifications

ForumsPro 2.0.1 Users have to this also on the following Tables:

prefix_fpro_topics to prefix_bbtopics (drop "topic_description" and "topic_descmod")
prefix_fpro_topics_watch to prefix_bbtopics_watch

On prefix_bbforums in Field forum_order you have to add a "0" after each Number, so that the forumsorder looks like:
1st Forum 10
2nd Forum 20

[penbrock]

I must have missed something. I wanted to keep my Pro running until I was able to test the Plus install so I copied (not moved)

Quote:

prefix_fpro_forums to prefix_bbforums
(also you need to sep "parent" to zero in all forums)
prefix_fpro_categories to prefix_bbcategories
prefix_fpro_posts to prefix_bbposts
prefix_fpro_posts_text to prefix_bbposts_text
prefix_fpro_posts_notifications to prefix_bbposts_notifications

I do see all the messages in _bbposts_text, when I go to the forum I see all the categories fine, but there is no topics or messages in any of them.

What did I miss?

[penbrock]

OK well after coping the bbtopics I can now see the topics but I get a database error when ever I try to read any message

[Phoenix]

And the error is?