| Author |
 Topic  |
|
bobbart
Junior Member
USA
163 Posts |
 Posted - 19 August 2002 : 12:25:31
|
ADODB.Recordset.1 error '80020009'
Unsupported Lock Type.
/forum/default.asp, line 112
'## Forum_SQL
strSql = "SELECT MO.FORUM_ID, ME.MEMBER_ID, ME.M_NAME " & _
" FROM " & strTablePrefix & "MODERATOR MO" & _
" , " & strMemberTablePrefix & "MEMBERS ME" & _
" WHERE (MO.MEMBER_ID = ME.MEMBER_ID )" & _
" ORDER BY MO.FORUM_ID, ME.M_NAME"
Set rsChk = Server.CreateObject("ADODB.Recordset")
LINE 112-->rsChk.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
if rsChk.EOF then
recModeratorCount = ""
else
allModeratorData = rsChk.GetRows(adGetRowsRest)
recModeratorCount = UBound(allModeratorData,2)
end if
rsChk.close
set rsChk = nothing
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 12:30:39
|
windows server, or unix/linux server?
What version of MySQL ? |
 |
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 12:59:40
|
| Its on a linux server with Chili!ASP. MySQL 3.23.36 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 13:41:16
|
I am contacting my host. I hope that they may have an answer.
If anyone else can help please do. |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 20:34:48
|
| Well he stated that there should be no problems. He suggested calling open after I am not sure if I should do that. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 20:38:30
|
try changing it to this:
rsChk.open strSql, my_Conn, 0, 1, &H0001
if you still get the error try changing it to this:
rsChk.open strSql, my_Conn |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 20:45:44
|
| ok I did the 2nd option and it then found another line with it in it. Am I going to have to go over all the pages and change this? |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 20:52:08
|
so the first line caused the same error?
If so, then yes, that is what you'll need to do. If you have Windows 2000 you can use the search option from your start menu to search for all *.asp files in the directory where you have the forum files. In the "containing text" box put:
adOpenForwardOnly, adLockReadOnly, adCmdText |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 20:54:05
|
**** that sucks...
Do you know why this is not working?
And whats going to be effected? I am a novice with this and compleatly new to mysql and hosting on a linux system |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 21:50:24
|
did you try this:
rsChk.open strSql, my_Conn, 0, 1, &H0001
did you get an error with it? |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 21:52:07
|
| yep I still got the error |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 22:36:06
|
Ok I set all the pages back to there original state. Of coure the error was there again.
I replaced it with rsChk.open strSql, my_Conn, 0, 1, &H0001
And it then found another line with the same error. So I guess it is taking this line. It came up again so I changed it to rs.open strSql, my_Conn, 0, 1, &H0001
And it came up with the other error again.
So now what? Do we have any idea whats causing this? |
Edited by - bobbart on 19 August 2002 22:40:58 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 22:42:23
|
| just keep fixing the errors until there aren't any more on that page. this is on default.asp right? And the errors are on different lines each time? |
|
|
|
bobbart
Junior Member
USA
163 Posts |
Posted - 19 August 2002 : 22:52:36
|
There were 2 on the default page.
Line 112 rsChk.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
When I replace this with rsChk.open strSql, my_Conn, 0, 1, &H0001
I get this one
Line 165 rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
And if I relace this line with
rs.open strSql, my_Conn, 0, 1, &H0001
I get this one
ADODB.Recordset.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/default.asp, line 170
Line 170 --> allCategoryData = rs.GetRows(adGetRowsRest)
|
Edited by - bobbart on 19 August 2002 22:57:28 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 23:05:43
|
can you try changing that to:
allCategoryData = rs.GetRows |
|
|
|
Topic |
|
Topic Locked
