Snitz Forums 2000 - Problem deleting from topic.asp

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Problem deleting from topic.asp

New Topic

Topic Locked

Printer Friendly

Author

Topic

withanhdammit
Junior Member

USA
236 Posts

Posted - 19 March 2005 : 17:04:58

When I delete a post from topic.asp, I get this error:

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/inc_func_common.asp, line 1726

That section of code in inc_func_common.asp is:

		Case "topic.asp"
			strTempTopic = request.querystring("TOPIC_ID")
			if not(strTempTopic = "") then
				if request.querystring("archive") = "true" then
					strsql = "SELECT T_SUBJECT, FORUM_ID FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID=" & strTempTopic
					set ttopics = my_conn.execute(strsql)
					strTempTopicTitle = ttopics("T_SUBJECT")
					strTempForum = ttopics("FORUM_ID")
					set ttopics = nothing
					strsql = "SELECT F_SUBJECT FROM " & strActivePrefix & "FORUM WHERE FORUM_ID=" & strTempForum
					set tforums = my_conn.execute(strsql)
					strTempForumTitle = tforums("F_SUBJECT")
					set tforums = nothing
					strNewTitle = strTempTopicTitle & " - " & strTempForumTitle & " - " & strForumTitle
				else
					strsql = "SELECT T_SUBJECT, FORUM_ID FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & strTempTopic
					set ttopics = my_conn.execute(strsql)
                       <Line 1726-----> strTempTopicTitle = ttopics("T_SUBJECT") 
					strTempForum = ttopics("FORUM_ID")
					set ttopics = nothing
					strsql = "SELECT F_SUBJECT FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & strTempForum
					set tforums = my_conn.execute(strsql)
					strTempForumTitle = tforums("F_SUBJECT")
					set tforums = nothing
					strNewTitle = strTempTopicTitle & " - " & strTempForumTitle & " - " & strForumTitle
				end if
			else
				strNewTitle = strForumTitle
			end if

Thanks!

h

<edited to add the rest of the code around line 1726>

I reject your reality and substitute my own.

Edited by - ruirib on 20 March 2005 09:41:51

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 March 2005 : 19:49:40

Did you change topic.asp?

Snitz 3.4 Readme | Like the support? Support Snitz too

withanhdammit
Junior Member

USA
236 Posts

Posted - 19 March 2005 : 19:54:34

The last mod I installed was online/offline add-on to Active Users. I got it from http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=42436&SearchTerms=online/offline
It does require a change to topic.asp.

You can see my topic.asp at http://thepoopsheet.dnjhome.com/topic.txt

h

<edited to add link to topic.txt>

I reject your reality and substitute my own.

Edited by - withanhdammit on 19 March 2005 20:10:48

withanhdammit
Junior Member

USA
236 Posts

Posted - 19 March 2005 : 21:07:04

OK Rui,

I replaced my topic.asp from before the online/offline mod was installed and I still have the same problem. I'm not sure what the deal is. I'm running base code of 3.4.05 on Win03, IIS6, MSSQL2000. Here is my list of installed mods and the order they were installed in:


Profile Views
Conquer Chat
Basic Statistics
Active Users
Recently Seen
Top Posters
Photo Album
Avatars
  My Avatars
Admin Moderators
US States List
  (includes US Territories, Military Post Offices, & Canadian Provinces)
Admin Tools
Anti-spam registration
Birthdays
News Mod (Front Page)
Reset Users Password
Private Messages
  PM Notification
Site Integration
Alternate Birthdate Entry
Split Topics
Subscription Manager
Optimized Search
Profile Admin
Spell Check 2004
Skype Add-on
Page Drop to link
Tell a friend
Search Log
Events Calendar
Site Statistics
Post Stamp (post x of xxx)
Inactive Users
Who has posted
Classifieds
Bookmarks
Advanced Search
Newsletter
  Subscribe at Registration
Yesterday/Today on posts
Online/Offline

Thanks!

h

<edited to add base code & server versions>

I reject your reality and substitute my own.

Edited by - withanhdammit on 19 March 2005 21:08:58

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 March 2005 : 09:50:25

With all those mods it's hard to find what's causing it... Anyway, the file required is inc_func_common.asp, not topic.asp.

Snitz 3.4 Readme | Like the support? Support Snitz too

withanhdammit
Junior Member

USA
236 Posts

Posted - 20 March 2005 : 09:54:54

OK, that file is at http://thepoopsheet.dnjhome.com/inc_func_common.txt

Thanks!

h

I reject your reality and substitute my own.

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 March 2005 : 10:20:27

You're using a GetNewTitle function that doesn't belong to the Snitz base code. I don't know the function nor it's purpose, so I'm afraid I can't be of help. I suggest that you change the topic title, so that the mod where that comes from is clearly identified, so that people knowledgeable about the mod can offer to help.

Snitz 3.4 Readme | Like the support? Support Snitz too

withanhdammit
Junior Member

USA
236 Posts

Posted - 20 March 2005 : 10:42:18

Actually, I beg to differ. I believe that it is part of the 3.4.05 base code. I just redownloaded the code from this website, and in the zip file sf2k_v34_05.zip I opened the inc_func_common.asp and on line 1304 is where the function "GetNewTitle" starts. The mirror I chose is in Phoenix, AZ. Maybe they are distributing a non-standard version.

I have included a snip of that below:


'##############################################
'##              Page Title                  ##
'##############################################

Function GetNewTitle(strTempScriptName) <---Line 1304 in the base Snitz 3.4.05 code
	Dim StrTempScript
	Dim strNewTitle
	arrTempScript = Split(strTempScriptName, "/")
	strTempScript = arrTempScript(Ubound(arrTempScript))
	strTempScript = lcase(strTempScript)

As you can see, that function doesn't come from a mod, as far as I can tell, it is part of the 3.4.05 base code.

Rui, I understand how hard it is to help people when they heavily mod their forum. And that help is highly appreciated, not just by me, but by everyone else who posts here looking for help.

Thanks!

h

I reject your reality and substitute my own.

cripto9t
Average Member

USA
881 Posts

Posted - 20 March 2005 : 11:51:14

You have 2 getNewTitle() functions.

The one under

'##############################################
'##              Page Title                  ##
'##############################################

is base code.

The other one is near the bottom of the file and is giving you the error. It must be from a mod.

_-/Cripto9t\-_

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 March 2005 : 12:51:49

I use Beyond Compare (www.scootersoftware.com) to compare users's files with the ones from Snitz. Regarding your file, near and at the area where you're having errors, Beyond Compare tells me the code I pointed out is not present in the Snitz file. I guess cripto9t as already pointed out a reason for this.

Snitz 3.4 Readme | Like the support? Support Snitz too

withanhdammit
Junior Member

USA
236 Posts

Posted - 20 March 2005 : 19:16:31

Thanks cripto9t, I appreciate you pointing out to me that there were two functions that had the same name I did not realize that. I'll try removing the 2nd one and see what happens.

Thanks again,

h

I reject your reality and substitute my own.

withanhdammit
Junior Member

USA
236 Posts

Posted - 20 March 2005 : 19:23:01

cripto9t,

That was the trick. I removed the 2nd version of the function and the deletes from topic.asp started working properly again. I appreciate you clueing me in to the fact that there were two versions of that function.

h

I reject your reality and substitute my own.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.34 seconds.