Support ⇒ CPG-BB (forum) ⇒ ForumsPro - converting tables to CPG-BB DF v9.2.1 ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum Index Modules & Blocks CPG-BB (forum)

ForumsPro - converting tables to CPG-BB DF v9.2.1 This topic is locked: you cannot edit posts or make replies.


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.

www.greenday2k.net

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


greenday2k, when would your guide possibly be ready?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.37/5.0.27/5.2.1/9.2.1


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.
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:
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.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.37/5.0.27/5.2.1/9.2.1


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.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1


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

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1


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

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.37/5.0.27/5.2.1/9.2.1


revived

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


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.

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

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
DF 9.2.1


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

--------------------------------------
Dragonfly site: www.stormsurgeguild.com
Game site: www.penbrock.com

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Ubuntu8.04.1/Apache2.2.8/MySQL5.0.51/PHP5/Ver 9.2.1


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

--------------------------------------
Dragonfly site: www.stormsurgeguild.com
Game site: www.penbrock.com

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Ubuntu8.04.1/Apache2.2.8/MySQL5.0.51/PHP5/Ver 9.2.1


And the error is?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


To be honest, these instructions are epic fail, and this topic should be locked/removed, it will only prove fatal to some poor forumspro user at some point.

As clearly pointed out by CatchImran the attachments tables ave VERY different, in point of fact Forums have three, Vs only ONE in ForumsPro.

I suggest a Sticky on THIS topic, and even then I have no idea if these instructions are up to date.

dragonflycms.org/Forum...36/#148336

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
2.6.18-164.11.1.el5xen/2.2.13/5.0.89-community-log/5.2.11/9.3.3.0


All past conversions are based on DF v9.2.1 and on the standard version.

Naturally this precludes the old ForumsPlus mod and DF v9.3.3.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are UTC
Post new topic This topic is locked: you cannot edit posts or make replies. Forum Index Modules & Blocks CPG-BB (forum)
Page 1 of 1


Jump to: