Topic Admin

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
donstar Members Profile Find Members Posts Newbie Joined: 04 January 2004 Location: Scotland Status: Offline Points: 35	Post Options Post Reply Quote donstar Report Post Thanks(0) Quote Reply Topic: Topic Admin Posted: 07 August 2006 at 10:10am
	I have just posted a new Topic. I then click on the Edit Icon beside the Topic name to bring up the Topic Admin window. I select 'Closed Topic' checkbox and hit OK and I get the following error message. Microsoft OLE DB Provider for ODBC Drivers error '80004005' Query-based update failed because the row to update could not be found. /bulletinboard/pop_up_topic_admin.asp, line 165 The Topic and the new post are displayed in the Forum but I can't edit the Topic. I'm using mySQL version 8.03 Edited by donstar - 07 August 2006 at 10:12am

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 07 August 2006 at 10:26am
	mySQL with the myODBC driver can be very buggy at times. Try changing line 98 of pop_up_topic_admin.asp to:- strSQL = "SELECT " & strDbTable & "Topic.Forum_ID, " & strDbTable & "Topic.Subject, " & strDbTable & "Topic.Priority, " & strDbTable & "Topic.Locked, " & strDbTable & "Topic.Poll_ID, " & strDbTable & "Topic.Moved_ID, " & strDbTable & "Topic.Hide " & _
	Web Wiz Forums Hosting ASP.NET Web Hosting

donstar Members Profile Find Members Posts Newbie Joined: 04 January 2004 Location: Scotland Status: Offline Points: 35	Post Options Post Reply Quote donstar Report Post Thanks(0) Quote Reply Posted: 08 August 2006 at 10:05am
	That fixed it -boRg- Thank you

dr_who Members Profile Find Members Posts Newbie Joined: 26 July 2006 Location: Denmark Status: Offline Points: 26	Post Options Post Reply Quote dr_who Report Post Thanks(0) Quote Reply Posted: 08 August 2006 at 7:19pm
	thx.... same problem...thx again

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

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.