| 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 |
|
|
withanhdammit
Junior Member
USA
236 Posts |
|
|
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 |
|
|
withanhdammit
Junior Member
USA
236 Posts |
|
|
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 |
|
Topic Locked
