| Author |
 Topic  |
|
|
rodwatkins
Starting Member
19 Posts |
 Posted - 13 April 2001 : 21:56:26
|
When I register a new user, I am getting this error:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/PHL243/inc_functions.asp, line 1094
Here is line 1094 (and surrounding lines):
color=violetred>", "</font id=violetred>")
fstring = docode(fstring, "[wheat]", "[/wheat]", "<font color=wheat>", "</font id=wheat>")
fString = doCode(fString, "", "", "<font color=white>", "</font id=white>")
fstring = docode(fstring, "[whitesmoke]", "[/whitesmoke]", "<font color=whitesmoke>", "</font id=whitesmoke>")
fString = doCode(fString, "", "", "<font color=yellow>", "</font id=yellow>")
fstring = docode(fstring, "[yellowgreen]", "[/yellowgreen]", "<font color=yellowgreen>", "</font id=yellowgreen>")
Please help if you can.
Thank in advance
Rod Watkins
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 14 April 2001 : 01:38:46
|
| If that is what line 1094 looks like, it looks like your inc_functions.asp file might have gotten corrupted. Try reuploading a fresh copy of it and see if that fixes it. |
 |
|
|
rodwatkins
Starting Member
19 Posts |
Posted - 14 April 2001 : 07:43:18
|
I tried replacing the file, but I get the same error. Here is a link to the file (as a txt file). If anyone could take a look, I'd be very grateful.
thanks again
Rod
http://24.112.148.131/phl243/inc_functions.txt
|
|
|
|
rodwatkins
Starting Member
19 Posts |
Posted - 14 April 2001 : 08:43:13
|
One last question: could this problem be a database problem?
|
|
|
|
rodwatkins
Starting Member
19 Posts |
Posted - 14 April 2001 : 15:29:44
|
I've narrowed the problem down to this one line in the file:
strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
Is there something wrong with this line?
Thanks
Rod
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 April 2001 : 16:11:55
|
quote:
http://24.112.148.131/phl243/inc_functions.txt
Needs a password
quote:
color=violetred>", "</font id=violetred>")
This line from your 1st post ls not complete, it should resemble the subsequent lines you posted. Is there another incomplete line above this one?
quote:
strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
This line is part of a series of lines that build the SQL query and couldn't be causing the error you quoted (the first code you posted couldn't cause the error either). This line looks OK to me.
======
Doug G
====== |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 14 April 2001 : 17:01:28
|
I have the same problem 
Here is the file:
http://www.eastpasco.com/files/inc_functions.txt
Also have the problem of not being able to use the ' AND " in the
subject line. I've been told it's in this file and maybe has something to do with this other error.
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 14 April 2001 17:04:41 |
|
|
|
rodwatkins
Starting Member
19 Posts |
Posted - 14 April 2001 : 17:17:28
|
My inc_finctions.txt is the same as Rick's above. Sorry about the password. Wasn't aware it was secured.
Rod
|
|
|
|
rodwatkins
Starting Member
19 Posts |
Posted - 14 April 2001 : 18:56:09
|
Okay, I've done some more searching. I have indicated what appears to be the wrong suspect line. I hadn't turned wordwrap off, so I guess my lines numbers were off.
Anyway,l I hope this is the correcte line:
getMemberID = rsGetMemberID("Members.MEMBER_ID")
This is part of the larger function:
function getMemberID(fUser_Name)
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
rsGetMemberID = my_Conn.Execute(strSql)
getMemberID = rsGetMemberID("Members.MEMBER_ID")
end function
Please accept my apologies for any confusion. As you can see, I am new to this and am trying my best to get this all functioning correctly.
Thanks again
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 14 April 2001 : 20:30:37
|
Put "Response.Write strSql" right before "rsGetMemberID = my_Conn.Execute(strSql)". Then copy and paste the SQL code here when you get the error.
And this line:
getMemberID = rsGetMemberID("Members.MEMBER_ID")
should be:
getMemberID = rsGetMemberID("MEMBER_ID")
where did you get the "Members." part from?
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 14 April 2001 : 20:59:59
|
I've compaired my inc_functions.asp with a new SR4 inc_functions.asp file
My File:
rsGetMemberID = my_Conn.Execute(strSql)
New File:
set rsGetMemberID = my_Conn.Execute(strSql)
would this be the problem?
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 14 April 2001 21:01:21 |
|
|
|
rodwatkins
Starting Member
19 Posts |
Posted - 14 April 2001 : 22:22:30
|
Well folks, I've been reading. Back some time agao when the new_mem_pm mod came out, some were also having the same problem as I and Rick are. Suspecting that it may be the new member personal message mod at fault, I removed all the related code from register.asp and what do you know, registration is working again.
Now I don't have any idea why it worked, but I thought I'd share this with you all.
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 April 2001 : 23:24:08
|
quote:
I've compaired my inc_functions.asp with a new SR4 inc_functions.asp file
My File:
rsGetMemberID = my_Conn.Execute(strSql)
New File:
set rsGetMemberID = my_Conn.Execute(strSql)
would this be the problem?
I don't know if this is 'the' problem, but it's necessary to use set with object variables.
======
Doug G
====== |
|
|
|
ktulu
Starting Member
13 Posts |
Posted - 20 April 2001 : 18:13:33
|
hi,
got the same prob...
when i traced the sql-messages i found out that it was a wrong declared
Forum Administrator in the New Member Private Message Mod.
See if the Admin (in table "MODS") is set to the right user account.
mine wasn't. Change and try it. Worked fine for me
Ktulu
|
|
|
| |
Topic |
|
Topic Locked
