Home Private Messages Search
CPG Dragonfly™ CMS
Toggle Content
 
Forums ⇒ Support ⇒ CPG-BB (forum) ⇒ ForumsPro - converting tables to CPG-BB DF v9.2.1


ForumsPro - converting tables to CPG-BB DF v9.2.1
Please post bugs in the Projects Module.
Post anything and everything else about CPG-BB in this forum.
Formerly known as phpBB but no longer compatible.

Post new topic    This topic is locked: you cannot edit posts or make replies.    Printer Friendly Page     Forum Index ⇒  Modules & BlocksCPG-BB (forum)

View previous topic :: View next topic  
Author Message
greenday2k
Forum Admin
Forum Admin

Offline Offline
Joined: Aug 11, 2005
Posts: 555
Location: CO
PostPosted: Mon Mar 10, 2008 4:16 pm
Post subject: ForumsPro - converting tables to CPG-BB DF v9.2.1

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)
Back to top
View user's profile Visit poster's website MSN Messenger Yahoo Messenger
shooh
Newbie
Newbie

Offline Offline
Joined: Jan 25, 2007
Posts: 42

PostPosted: Wed Mar 12, 2008 7:39 pm
Post subject: Re: How to move topics from ForumsPro back to CPG-BB

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
Back to top
View user's profile Visit poster's website
shooh
Newbie
Newbie

Offline Offline
Joined: Jan 25, 2007
Posts: 42

PostPosted: Wed Mar 12, 2008 8:59 pm
Post subject: Re: How to move topics from ForumsPro back to CPG-BB

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.


shooh's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.37/5.0.27/5.2.1/9.2.1
Back to top
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
PostPosted: Mon Jun 02, 2008 9:41 am
Post subject: Re: How to move topics from ForumsPro back to CPG-BB

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
Back to top
View user's profile
CatchImran
500+ Posts Club
500+ Posts Club

Offline Offline
Joined: Mar 06, 2006
Posts: 635
Location: India
PostPosted: Mon Jun 02, 2008 11:25 am
Post subject: Re: How to move topics from ForumsPro back to CPG-BB

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
Back to top
View user's profile
shooh
Newbie
Newbie

Offline Offline
Joined: Jan 25, 2007
Posts: 42

PostPosted: Wed Jul 23, 2008 3:12 pm
Post subject: Re: How to move topics from ForumsPro back to CPG-BB

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

Offline Offline
Joined: Apr 19, 2004
Posts: 8837
Location: Netizen
PostPosted: Mon Dec 01, 2008 11:49 pm
Post subject: Re: Converting ForumsPro to CPG-BB

revived


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website Photo Gallery
Otzelott
Newbie
Newbie

Offline Offline
Joined: Mar 18, 2008
Posts: 1

PostPosted: Wed Dec 30, 2009 6:08 pm
Post subject: Re: ForumsPro - converting tables to CPG-BB

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


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

Offline Offline
Joined: Sep 24, 2008
Posts: 32
Location: Anchorage, AK
PostPosted: Tue Feb 02, 2010 5:11 pm
Post subject: Re: ForumsPro - converting tables to CPG-BB

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?

_________________
--------------------------------------
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
Back to top
View user's profile Visit poster's website
penbrock
Newbie
Newbie

Offline Offline
Joined: Sep 24, 2008
Posts: 32
Location: Anchorage, AK
PostPosted: Tue Feb 02, 2010 5:27 pm
Post subject: Re: ForumsPro - converting tables to CPG-BB

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

Offline Offline
Joined: Apr 19, 2004
Posts: 8837
Location: Netizen
PostPosted: Wed Feb 03, 2010 2:59 am
Post subject: Re: ForumsPro - converting tables to CPG-BB

And the error is?


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website Photo Gallery
Kinsman
Dragonfly addicted
Dragonfly addicted

Offline Offline
Joined: May 29, 2006
Posts: 470
Location: Australia
PostPosted: Fri Mar 09, 2012 11:13 pm
Post subject: Re: ForumsPro - converting tables to CPG-BB

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

Offline Offline
Joined: Apr 19, 2004
Posts: 8837
Location: Netizen
PostPosted: Sat Mar 10, 2012 4:30 am
Post subject: Re: ForumsPro - converting tables to CPG-BB

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, MyBB, vBulletin

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website Photo Gallery
Display posts from previous:   
Post new topic    This topic is locked: you cannot edit posts or make replies.    Printer Friendly Page    Forum Index ⇒  Modules & BlocksCPG-BB (forum)
Page 1 of 1
All times are GMT



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


 
   Toggle Content User Info

Welcome Anonymous

Nickname
Password
(Register)

   Toggle Content Mercurial Commits
· Bugfix: \Poodle::getKernel()->IDENTITY can be undefined in debugger Change: spli
· Changed another L10N->get() to L10N->dbget() for CFG->global->slogan and CFG->gl
· Changed L10N->get() to L10N->dbget() for CFG->global->slogan and CFG->global->si
· Improved L10N admin
· Update version due to L10N changes
· Bugfix: L10N date parsing Added: L10N dbget() check v9 constants
· Merge
· Bugfix: new language system incompatibilities
· Dragonfly_Page namespaced and closed http://dragonflycms.org/Projects/f=143.html
· Bugfix: Statistics module missing properties

read more...

   Toggle Content Community

Support for DragonflyCMS in a other languages:

Deutsch
Español

You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
Interactive software released under GNU GPL, Code Credits, Privacy Policy