We forcefully moved to the new server and upgraded to Dragonfly CMS v10.
Please keep in mind we are working hard to get everything up and running, so please be patient.
Read/reply for issues in this forum topic /

Best regards, DJ Maze

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

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

Author Message
greenday2k
Forum Admin
Forum Admin

Offline Offline
Joined: Aug 11, 2005
Posts: 557
Location: CO
Post
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


greenday2k's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
View user's profile Visit poster's website Yahoo Messenger
shooh
Newbie
Newbie

Offline Offline
Joined: Jan 25, 2007
Posts: 42
Post
greenday2k, when would your guide possibly be ready?


shooh's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.37/5.0.27/5.2.1/9.2.1
View user's profile Visit poster's website
shooh
Newbie
Newbie

Offline Offline
Joined: Jan 25, 2007
Posts: 42
Post
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.


shooh's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.37/5.0.27/5.2.1/9.2.1
View user's profile Visit poster's website
CatchImran
500+ Posts Club
500+ Posts Club

Offline Offline
Joined: Mar 06, 2006
Posts: 635
Location: India
Post
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's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1
View user's profile
CatchImran
500+ Posts Club
500+ Posts Club

Offline Offline
Joined: Mar 06, 2006
Posts: 635
Location: India
Post
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


CatchImran's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1
View user's profile
shooh
Newbie
Newbie

Offline Offline
Joined: Jan 25, 2007
Posts: 42
Post
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


shooh's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.37/5.0.27/5.2.1/9.2.1
View user's profile Visit poster's website
Phoenix
• Many Posts •
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8840
Location: Netizen
Post
revived


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
View user's profile Photo Gallery
Otzelott
Newbie
Newbie

Offline Offline
Joined: Mar 18, 2008
Posts: 1
Post
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


Otzelott's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
DF 9.2.1
View user's profile Visit poster's website
penbrock
Newbie
Newbie

Offline Offline
Joined: Sep 24, 2008
Posts: 32
Location: Anchorage, AK
Post
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

penbrock's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Ubuntu8.04.1/Apache2.2.8/MySQL5.0.51/PHP5/Ver 9.2.1
View user's profile Visit poster's website
penbrock
Newbie
Newbie

Offline Offline
Joined: Sep 24, 2008
Posts: 32
Location: Anchorage, AK
Post
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

penbrock's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Ubuntu8.04.1/Apache2.2.8/MySQL5.0.51/PHP5/Ver 9.2.1
View user's profile Visit poster's website
Phoenix
• Many Posts •
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8840
Location: Netizen
Post
And the error is?


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
View user's profile Photo Gallery
Kinsman
Dragonfly addicted
Dragonfly addicted

Offline Offline
Joined: May 29, 2006
Posts: 474
Location: Australia
Post
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


Kinsman's 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
View user's profile Visit poster's website
Phoenix
• Many Posts •
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8840
Location: Netizen
Post
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.

_________________
DonationsPro for DragonflyCMS & SMF

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
View user's profile Photo Gallery
Display posts from previous:
All times are UTC



Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum


User Info

Welcome Anonymous



(Register)
Community

Support for DragonflyCMS in a other languages:

Deutsch
Español