| Author |
 Topic  |
|
|
(.)z
New Member
United Kingdom
85 Posts |
 Posted - 30 January 2001 : 09:21:52
|
Adding a forum (type URL) under MySQL gave me the following errorADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/technical/snitz/inc_functions.asp, line 657
The SQL being generated is SELECT TECHNICAL_FORUM_MEMBERS.MEMBER_ID FROM TECHNICAL_FORUM_MEMBERS WHERE M_NAME = 'adf' but M_NAME is the DB user ID not the NT user ID (adf is my NT user ID).
Looking in inc_functions.asp I can't see how this will ever work, or should the DB username always be passed into inc_functions.asp and its post_info.asp that wont work?
Topic Posting works however and it calls getMemberId(strDBNTUserName) also.
Totally Lost Now - Dont understand 
Regards -  z - http://www.discuss-online.co.uk/ |
|
|
(.)z
New Member
United Kingdom
85 Posts |
Posted - 30 January 2001 : 10:11:24
|
Right, I am no longer lost. I have found the bug(s).
In inc_functions.asp, function getMemberID (around line 648), the line strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
should be strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & fUser_Name & "'"
also, the same is true for the function GetSig (around line 928) which also does not work in NT mode (signatures not inserted when requested). Replace strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
should be strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & fUser_Name & "'"
Perhaps someone from Snitz could confirm I am not talking total rubbish. I appears to fix the problems though.
Regards - z - http://www.discuss-online.co.uk/ |
 |
|
|
barky81
Junior Member
USA
166 Posts |
Posted - 30 January 2001 : 10:32:08
|
This took me awhile to understand, but see the last few lines of config.asp....
if strAuthType = "db" then
STRdbntsqlname = "M_NAME"
strAutoLogon ="0"
strNTGroups ="0"
else
STRdbntsqlname = "M_USERNAME"
end if
Note that this code is s'posed to set M_NAME versus M_USERNAME; so yes, I am thinking that all M_*NAME references should be replaced. Right?
|
|
|
|
(.)z
New Member
United Kingdom
85 Posts |
Posted - 30 January 2001 : 10:51:52
|
quote:
Note that this code is s'posed to set M_NAME versus M_USERNAME; so yes, I am thinking that all M_*NAME references should be replaced. Right?
Only in a WHERE clase.
However, I am not sure about getMemberNumber() which has a WHERE M_NAME = still in it, because this is called from within inc_functions.asp (chkAccess function) and is passed Request.Cookies(strUniqueID & "User")("Name") as the username which from my investigation is the M_NAME even in NT mode.
Regards - z - http://www.discuss-online.co.uk/
Edited by - (.)z on 30 January 2001 10:53:13 |
|
|
|
Blade
New Member
66 Posts |
Posted - 01 February 2001 : 15:28:49
|
That fixed the problems with Web Links and signatures in NT mode! Thanks!
I found a problem when viewing the board in Windows 2000 (works fine in Windows NT) the preview window when posting says:
<center><b>< There is no text to preview! ></b></center>
no matter what you have entered, when you click the preview button. This has been a problem even before your fixes. Any ideas?
Edited by - blade on 01 February 2001 15:40:12 |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 20 February 2001 : 22:41:54
|
this was addressed in a previouse bugfix wasn't it?
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
Blade
New Member
66 Posts |
Posted - 21 February 2001 : 09:35:17
|
I believe so, because it seems to be working now.  |
|
|
|
barky81
Junior Member
USA
166 Posts |
Posted - 21 February 2001 : 09:43:50
|
quote:
this was addressed in a previouse bugfix wasn't it?
Which? The M_*Name issue, or the "no text to preview" issue?
Or are y'all saying *both* are now fixed?
Thanks,
barky81
|
|
|
|
Blade
New Member
66 Posts |
Posted - 21 February 2001 : 13:49:46
|
| Both are working for me... |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 22 February 2001 : 12:30:26
|
GREAT!!!!
fixed... and closed...
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
| |
Topic |
|
Forum Locked
Topic Locked
