FUDforum: How To » Imported into wrong Forum

Home » FUDforum » How To » Imported into wrong Forum

Show: Today's Messages :: Polls :: Message Navigator

Imported into wrong Forum [message #33640]

Mon, 11 September 2006 19:28

aleman

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

Report message to a moderator

[Message index]

		Imported into wrong Forum By: aleman on Mon, 11 September 2006 19:28
		Re: Imported into wrong Forum By: Ilia on Mon, 11 September 2006 20:01

Previous Topic:	Avatars
Next Topic:	Forum not responding

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 17:22:19 GMT 2024

Total time taken to generate the page: 0.05824 seconds