Hi - I am using wwf v 7.01 (SQL Server) I am getting problem with the posting. It is running well on my local machine, but displaying following error message in post_message.asp page when I run my forum on internet web server.
ADODB.Recordset error '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
post_message.asp, line 599
Line 599 looks like this:
'If this is a new topic then save the new subject heading and read back the new topic ID number
If strMode = "new" AND (blnPost = True OR (blnAdmin = True OR blnModerator = True)) Then
'Initalise the SQL string with a query to get the Topic details
strSQL = "SELECT TOP 1 " & strDbTable & "Topic.* FROM " & strDbTable & "Topic "
strSQL = strSQL & "WHERE Forum_ID =" & intForumID & " "
strSQL = strSQL & "ORDER By " & strDbTable & "Topic.Start_date DESC;"
With rsCommon
'Set the cursor type property of the record set to Dynamic so we can navigate through the record
set .CursorType = 2
'Set the Lock Type for the records so that the record set is only locked when it is updated
.LockType = 3
'Open the author table .Open strSQL, adoCon 'Insert the new topic details in the recordset
.AddNew (Line # 599)
I also re-uploaded the file but same problem. Any help is appreciated. Thank you.
Edited by PrivateEye