1
walkero
Newbb 3.08 to Xforum 5.70
  • 2011/2/14 9:25

  • walkero

  • Just popping in

  • Posts: 14

  • Since: 2011/2/7 1


The following sql scripts are based on wishcraft's post here. It worked for me, and I hope to work for you too.


TRUNCATE xoops_xf_archive
TRUNCATE xoops_xf_attachments
TRUNCATE xoops_xf_categories
TRUNCATE xoops_xf_digest
TRUNCATE xoops_xf_extras
TRUNCATE xoops_xf_field
TRUNCATE xoops_xf_forums
TRUNCATE xoops_xf_moderates
TRUNCATE xoops_xf_online
TRUNCATE xoops_xf_posts
TRUNCATE xoops_xf_posts_text
TRUNCATE xoops_xf_reads_forum
TRUNCATE xoops_xf_reads_topic
TRUNCATE xoops_xf_report
TRUNCATE xoops_xf_topics
TRUNCATE xoops_xf_visibility
TRUNCATE xoops_xf_votedata
INSERT INTO xoops_xf_archive SELECT FROM xoops_bb_archive
INSERT INTO xoops_xf_attachments SELECT FROM xoops_bb_attachments
INSERT INTO xoops_xf_categories(cat_idcat_imagecat_titlecat_descriptioncat_ordercat_urlSELECT FROM xoops_bb_categories;
INSERT INTO xoops_xf_digest SELECT FROM xoops_bb_digest
INSERT INTO xoops_xf_moderates SELECT FROM xoops_bb_moderates
INSERT INTO xoops_xf_online SELECT FROM xoops_bb_online
INSERT INTO xoops_xf_posts (post_idpidtopic_idforum_idpost_timeuidposter_nameposter_ip, `subject`, dohtmldosmileydoxcodedobrdoimageiconattachsig,approved,post_karma,attachment,require_replySELECT FROM xoops_bb_posts;
INSERT INTO xoops_xf_posts_text SELECT FROM xoops_bb_posts_text
INSERT INTO xoops_xf_reads_forum SELECT FROM xoops_bb_reads_forum
INSERT INTO xoops_xf_reads_topic SELECT FROM xoops_bb_reads_topic
INSERT INTO xoops_xf_report SELECT FROM xoops_bb_report
INSERT INTO xoops_xf_topics SELECT FROM xoops_bb_topics
INSERT INTO xoops_xf_votedata SELECT FROM xoops_bb_votedata;
INSERT INTO xoops_xf_forums (forum_idforum_nameforum_descparent_forumforum_moderatorforum_topicsforum_postsforum_last_post_idcat_idforum_typeallow_htmlallow_sigallow_subject_prefixhot_thresholdforum_orderattach_maxkbattach_extallow_pollsSELECT FROM xoops_bb_forums;

2
wishcraft
Re: Newbb 3.08 to Xforum 5.70

Thanks
Resized Image
http://www.ohloh.net/accounts/226400

Follow, Like & Read:-

twitter.com/RegaltyFamily
github.com/Chronolabs-Cooperative
facebook.com/DrAntonyRoberts

3
timgno
Re: Newbb 3.08 to Xforum 5.70
  • 2011/2/21 10:07

  • timgno

  • Module Developer

  • Posts: 1504

  • Since: 2007/6/21


I received the following mysql message:

#1136 - The number of columns does not match the count at line 1

Login

Who's Online

291 user(s) are online (121 user(s) are browsing Support Forums)


Members: 0


Guests: 291


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits