| Author |
 Topic  |
|
|
jrayk
Starting Member
6 Posts |
 Posted - 02 February 2006 : 17:09:06
|
I just installed the "complaint manager" mod for v3.4.
I can report complaints from topic.asp just fine and the complaint link and complaint count appear in the admins navigation links.... however when I try to view the complaint on complaintmanager.asp I receive the following error... Any ideas?
-----------------------------------------------------------
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.
/forum/complaintmanager.asp, line 350
------------------------------------------------------------
I can view the "solved complaints" page when the querystring is..
complaintmanager.asp?showsolved=1
but not the comaplaint page when the querystring is
complaintmanager.asp?showsolved=0
I am hosting on godaddy.com with thier basic service.
Thanks. |
|
|
jrayk
Starting Member
6 Posts |
Posted - 02 February 2006 : 17:13:41
|
Here is the chunk that is causing the trouble on complaintmanager.asp
----------------------
set rsComp = Server.CreateObject("ADODB.Recordset")
rsComp.cachesize = strPageSize
rsComp.open strSql, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
if not (rsComp.EOF or rsComp.BOF) then
rsComp.pagesize = strPageSize
rsComp.absolutepage = mypage '**LINE 350**
maxpages = cLng(rsComp.pagecount)
if maxpages >= mypage then
arrReportData = rsComp.GetRows(strPageSize)
iReportCount = UBound(arrReportData, 2)
else
iReportCount = ""
end if
else '## No replies found in DB
iReportCount = ""
end if
rsComp.Close
set rsComp = nothing
|
 |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 29 March 2006 : 05:32:45
|
I get the same error, did you solve this?
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 29 March 2006 : 15:30:29
|
I suppose you have MySql database
if so
Add
rsComp.CursorLocation=AdUseClient
after
set rsComp = Server.CreateObject("ADODB.Recordset")
so it looks like this:
set rsComp = Server.CreateObject("ADODB.Recordset")
rsComp.CursorLocation=AdUseClient
rsComp.cachesize = strPageSize
rsComp.open strSql, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
|
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 30 March 2006 : 02:21:21
|
Yes, that did it. If you have the time I would like to know why? ;)
Thank you =) |
/Tribaliztic
- www.gotlandrace.se -
|
Edited by - tribaliztic on 30 March 2006 02:28:18 |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 30 March 2006 : 03:59:37
|
Okay that's enough for me, thanks alot!
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 30 March 2006 : 04:03:39
|
I get another error.. When clicking on the "show post"-button I only get "an error occurred".
The link is like this:
javascript:openWindow6('pop_complaint_showpost.asp?TOPIC_ID=3805&REPLY_ID=0&IsTopic=0');
Seems like the REPLY_ID and IsTopic is not set, any hints?
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
| |
Topic |
|
Topic Locked
