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
Return to the default flat view Create a new topic Submit Reply
Imported into wrong Forum [message #33640] Mon, 11 September 2006 19:28 Go to previous message
aleman   United Kingdom
Messages: 40
Registered: May 2006
Location: Blackpool UK
Karma:
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
[Message index]
 
Read Message
Read Message
Previous Topic: Avatars
Next Topic: Forum not responding
Goto Forum:
  

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

Current Time: Wed Nov 27 13:53:58 GMT 2024

Total time taken to generate the page: 0.03980 seconds