Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Archive One Topic MOD 1.0a

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Etymon Posted - 18 December 2006 : 09:21:01
Edited: March 4, 2009

I'm not sure why the original message was gone when I checked up on this topic today.

Below is the download link for this MOD:

https://sourceforge.net/project/showfiles.php?group_id=184115&package_id=214028

15   L A T E S T    R E P L I E S    (Newest First)
Lon2 Posted - 10 March 2009 : 16:25:56
Emailed.
Etymon 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
Lon2 Posted - 07 March 2009 : 14:17:40
You hit the nail right on the head, Etymon!

Glad you're doing better!
Etymon 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 Posted - 04 March 2009 : 11:06:14
Sorry to hear that, Etymon. No problem. Get well soon!
Etymon 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 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.
Lon2 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!
texanman Posted - 03 March 2009 : 18:37:03
I think either way should work.
Lon2 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?
HuwR 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 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.
Etymon 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?<
ReAX222 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 Posted - 15 November 2007 : 23:29:00
What version of Snitz are you running?
What MODs do you have installed?
What database are you using?

I may have to rework the MOD. It's about time for an update on it anyway.

Thank you for the report. I am sure it will help someone else out as well.

Etymon
<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000 Version 3.4.07