FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » Imported into wrong Forum
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Imported into wrong Forum [message #33640] Mon, 11 September 2006 19:28 Go to next message
aleman   United Kingdom
Messages: 40
Registered: May 2006
Location: Blackpool UK
Karma: 0
Member
Doh!

Ok I'm in the process of using Fudbox.php to import 5years worth of MBOX archives into our nice new shiny forum, month by month Sad Anyway just over half way in I forgot to change the Forum that I wanted the emails imported into with the consequence that Jan, Feb and A little bit of Mar 2004 ended up being posted in the 2003 archive.

What I need to do is to move these from the wrong forum and put them in the right one. I've had a quick squiz at the tables but can't see where the forumId is in the msg table, all I need to do is to change the ForumId from 6 to 7 where the Date is in the range Jan 01 2004 to March 05 2004.

Simple Update statement should do it or am I being too simplistic?

TIA

--
Aleman

Report message to a moderator

Re: Imported into wrong Forum [message #33642 is a reply to message #33640] Mon, 11 September 2006 20:01 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Update the forum_id in value in the threads table for the relevant topics and run the consistency checker.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Avatars
Next Topic: Forum not responding
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 10:19:09 GMT 2024

Total time taken to generate the page: 0.05342 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software