Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - can’t post messages..pls help
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

can’t post messages..pls help

 Post Reply Post Reply
Author
PrivateEye View Drop Down
Groupie
Groupie
Avatar

Joined: 21 March 2003
Location: United Kingdom
Status: Offline
Points: 168
Post Options Post Options   Thanks (0) Thanks(0)   Quote PrivateEye Quote  Post ReplyReply Direct Link To This Post Topic: can’t post messages..pls help
    Posted: 20 July 2003 at 2:33pm

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
The Judgement Day
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 20 July 2003 at 4:15pm
Change:

strSQL = "SELECT TOP 1 " & strDbTable & "Topic.* FROM " & strDbTable & "Topic "
strSQL = strSQL & "WHERE Forum_ID =" & intForumID & " "
strSQL = strSQL & "ORDER By " & strDbTable & "Topic.Start_date DESC;"


To:

strSQL = "SELECT " & strDbTable & "Topic.* FROM " & strDbTable & "Topic "
strSQL = strSQL & "WHERE Forum_ID =" & intForumID & ";"
Back to Top
PrivateEye View Drop Down
Groupie
Groupie
Avatar

Joined: 21 March 2003
Location: United Kingdom
Status: Offline
Points: 168
Post Options Post Options   Thanks (0) Thanks(0)   Quote PrivateEye Quote  Post ReplyReply Direct Link To This Post Posted: 20 July 2003 at 4:19pm
I have fixed the bug by adding rsCommon.CursorLocation = 3 'Client Side cursor :)
The Judgement Day
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.