| Author |
 Topic  |
|
ReAX222
Starting Member
4 Posts |
 Posted - 16 November 2007 : 10:56:12
|
3.4.05
Archive one topic, Atomic's BGimage cell, Avatar mod for 3.4, Gatekeeper Anti-spam, and private messages mod
It's an Access, but I had to convert it up to 2002-3 to work on it. Yes that was the site, and the world always seems to get smaller doesn't it?< |
 |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 16 November 2007 : 14:29:19
|
quote:
Originally posted by ReAX222
It's an Access, but I had to convert it up to 2002-3 to work on it. Yes that was the site, and the world always seems to get smaller doesn't it?
OK. That helps out a lot.
Did you install the MOD (run the dbs_ file) before you converted the database or after converting it?< |
|
|
|
Lon2
Junior Member
USA
151 Posts |
Posted - 03 March 2009 : 15:02:46
|
Implimented this mod and got the following error:
quote:
Microsoft SQL Native Client error '80040e37'
Invalid object name 'FORUM_UA_TOPICS'.
/forums/admin_topics.asp, line 1168
I'm using SQL 2005. Looking for any clues...
Etymon, hope you're still around!
If it makes any difference, this was the last routine right before the failure:
quote:
Sub subUnArchiveStuff()
Forum_SQL - INSERT both the old TOPIC_ID (from the FORUM_A_TOPICS table) and the new TOPIC_ID (UA_TOPIC_ID) to the Un-Archived Topics (FORUM_UA_TOPICS) table.
Archived TOPIC_ID = 9359
Un-Archived TOPIC_ID = 60791
strSql = INSERT INTO FORUM_UA_TOPICS (UA_TOPIC_ID,TOPIC_ID) VALUES (60791,9359)
It looks like it almost got to the end. It went through many routines, then the message "All replies to the topic ... [the topic name] were successfully un-archived!" then a few more routines, and then the error. |
Edited by - Lon2 on 03 March 2009 15:41:00 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 03 March 2009 : 16:03:34
|
| was there a setup script to run for the database ? looks like you don't have the required tables in your db |
|
|
|
Lon2
Junior Member
USA
151 Posts |
Posted - 03 March 2009 : 16:12:40
|
There is one file "dbs_archive_one_topic_mod_1.0a.asp" that looks like it might create a table:
Archive One Topic MOD 1.0a
[CREATE]
UA_TOPICS
UA_TOPIC_ID#int#NOT NULL#
TOPIC_ID#int#NOT NULL#
[END] Does this have to be run in Alernate Mod setup in Admin Options? |
|
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 03 March 2009 : 18:37:03
|
| I think either way should work. |
|
|
|
Lon2
Junior Member
USA
151 Posts |
Posted - 03 March 2009 : 20:11:38
|
You thunk right, texanman. 
I used Alternate Mod setup in Admin Options to create the tables. And now the mod works!
Thank you Etymon, texanman and Huwr!  |
|
|
|
Lon2
Junior Member
USA
151 Posts |
Posted - 03 March 2009 : 20:24:21
|
| I am left with one small problem from when I got the error above. The replies to the topic that I was trying to unarchive got unarchived but not the topic. Is there any way to fix this? I copied the results page from when I got the error so I have the Topic and Reply IDs. |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 03 March 2009 : 21:22:35
|
i am still around, but just got out surgery today. i'm out of town for a bit. i might be able to you more when i get back. depends on how long i can sit up and all. sorry i can't help sooner.
etymon
|
|
|
|
Lon2
Junior Member
USA
151 Posts |
Posted - 04 March 2009 : 11:06:14
|
| Sorry to hear that, Etymon. No problem. Get well soon! |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 06 March 2009 : 17:32:53
|
Thanks Lon2! 
OK, I am doing really good on this recovery things so far. It's been about 72 hours, and I am not using crutches or a walker. I am limping and grimacing. My head is still in a fog though. So, if I can work effectively on this tonight I'll give it a shot.
From what I think you said last was is that you successfully un-archived the replies for a topic, but then topic for those replies was left still archived. Then you asked about it in this topic, the other members told you to install the dbs code, then after that all was well. But, I think that means that the MOD worked as expected for other topics you have un-archived since installing the code. It sounds like the topic that was left unfinished before the dbs code installation is still unfinished (or archived). Is that right? If so that means you have replies un-archived and the referring topic archived.
When I get settled tonight I'll look at this some more.
Cheers,
Etymon
|
|
|
|
Lon2
Junior Member
USA
151 Posts |
Posted - 07 March 2009 : 14:17:40
|
You hit the nail right on the head, Etymon!
Glad you're doing better! |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 07 March 2009 : 15:47:45
|
Great!
Now, since this is testing, could you e-mail me from my Snitz profile? I'll need to work through it with you offline. Then we can post the answer in this topic. The reason is that the testing could be lengthy which would make this topic a roller coaster to read for someone else looking for the same answer.
If you use MSN Messenger, then send me your contact info so that I can invite you to my contact list. If you use something other, then post that.
Etymon
|
Edited by - Etymon on 07 March 2009 15:50:40 |
|
|
|
Lon2
Junior Member
USA
151 Posts |
Posted - 10 March 2009 : 16:25:56
|
| Emailed. |
|
|
|
Topic |
|
Archive One Topic MOD 1.0a
