1
I have had a few emails about how to upgrade from newbb to X-Forum. The following SQL you can fire you will need to replace
prefix_ with your database prefix but this will copy all the data from newbb to xforum and allow it to be used.
TRUNCATE prefix__xf_archive;
TRUNCATE prefix__xf_attachments;
TRUNCATE prefix__xf_categories;
TRUNCATE prefix__xf_digest;
TRUNCATE prefix__xf_extras;
TRUNCATE prefix__xf_field;
TRUNCATE prefix__xf_forums;
TRUNCATE prefix__xf_moderates;
TRUNCATE prefix__xf_online;
TRUNCATE prefix__xf_posts;
TRUNCATE prefix__xf_posts_text;
TRUNCATE prefix__xf_reads_forum;
TRUNCATE prefix__xf_reads_topic;
TRUNCATE prefix__xf_report;
TRUNCATE prefix__xf_topics;
TRUNCATE prefix__xf_visibility;
TRUNCATE prefix__xf_votedata;
INSERT INTO prefix__xf_archive SELECT * FROM prefix__bb_archive;
INSERT INTO prefix__xf_attachments SELECT * FROM prefix__bb_attachments;
INSERT INTO prefix__xf_categories SELECT * FROM prefix__bb_categories;
INSERT INTO prefix__xf_digest SELECT * FROM prefix__bb_digest;
INSERT INTO prefix__xf_forums SELECT * FROM prefix__bb_forums;
INSERT INTO prefix__xf_moderates SELECT * FROM prefix__bb_moderates;
INSERT INTO prefix__xf_online SELECT * FROM prefix__bb_online;
INSERT INTO prefix__xf_posts (post_id, pid, topic_id, forum_id, post_time, uid, poster_name, poster_ip, `subject`, dohtml, dosmiley, doxcode, dobr, doimage, icon, attachsig,approved,post_karma,attachment,require_reply) SELECT * FROM prefix__bb_posts;
INSERT INTO prefix__xf_posts_text SELECT * FROM prefix__bb_posts_text;
INSERT INTO prefix__xf_reads_forum SELECT * FROM prefix__bb_reads_forum;
INSERT INTO prefix__xf_reads_topic SELECT * FROM prefix__bb_reads_topic;
INSERT INTO prefix__xf_report SELECT * FROM prefix__bb_report;
INSERT INTO prefix__xf_topics SELECT * FROM prefix__bb_topics;
INSERT INTO prefix__xf_votedata SELECT * FROM prefix__bb_votedata;
You will be able to fire this in phpmyadmin or SQL tools like sqlYog from webYog.
www.ohloh.net/accounts/226400
Follow, Like & Read:-
twitter.com/RegaltyFamily
github.com/Chronolabs-Cooperative
facebook.com/DrAntonyRoberts
