| Author |
 Topic  |
|
|
ascension
New Member
50 Posts |
 Posted - 21 June 2004 : 19:45:16
|
Hi all,
Just wanted to ask before I tried it ...
If I want to move all of the messages from one forum (say, Forum_ID = 18) ... to a forum with the ID of 3 ... would I do a query (MSSQL) for all the posts with the ID of 18 - and do an update and change it to 3 ?? Is it that easy?
I was going to do the search on the FORUM_REPLY, FORUM_TOPICS, FORUM_A_REPLY, and FORUM_A_TOPICS tables... is this all?
Thanks for your help!
John |
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 21 June 2004 : 23:16:29
|
| Why not try 1 record manually and see what happens? Sounds like it should work. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 21 June 2004 : 23:31:27
|
| you'll need to update the FORUM_SUBSCRIPTIONS table also. |
|
|
|
ascension
New Member
50 Posts |
Posted - 06 July 2004 : 22:07:33
|
I think I did something wrong. When I try to archive any of the forums, I get this error:
No Replies were Archived: none found
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near ','.
/beta/forum46/admin_forums.asp, line 577
Any ideas what this might mean? |
Edited by - ascension on 06 July 2004 22:08:05 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ascension
New Member
50 Posts |
Posted - 07 July 2004 : 23:16:34
|
I'm not sure I know how to do that? What exactly are you looking for? If you point me in a general direction, I should be able to get what you need to see....
Also, you might want to know that I did do as exactly it says in the first few posts... but. :-\ This now. |
|
|
|
ascension
New Member
50 Posts |
|
|
ascension
New Member
50 Posts |
Posted - 08 July 2004 : 01:04:44
|
| Something strange, too ... I can archive the forum for up to 5 months -- anything less (ie. 4, 3, 2 months) ... I get this error. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ascension
New Member
50 Posts |
Posted - 11 July 2004 : 20:28:30
|
Actually - I just had the database restored from a few weeks back -- so all is good now.
Thank you for your time & suggestions. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ascension
New Member
50 Posts |
Posted - 13 July 2004 : 00:18:56
|
FIXED!  |
Edited by - ascension on 13 July 2004 00:41:27 |
|
|
| |
Topic |
|
Topic Locked
