Web Wiz Forums - error in admin

Print Page | Close Window

error in admin_register With MySQL

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27839
Printed Date: 02 April 2026 at 9:26am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: error in admin_register With MySQL

Posted By: fabrixnet
Subject: error in admin_register With MySQL
Date Posted: 15 September 2009 at 6:52pm

Hello,
I use Web Wiz Forums® version 9.60 With MySQL 4.1.16 database
When I update a Member I have this error with all the Members:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Query-based update failed because the row to update could not be found.
/forum/admin_register.asp, line 399

if for example I use this method found the row

strSQL = "UPDATE tblAuthor SET PM_notify=-1 where Author_ID = 16 ;"
adoCon.Execute strSQL

As can I resolve This problem?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 16 September 2009 at 8:44am

Have looked through the code and run a number of tests in the lab and can not see an issue with it.

The only thing that can suggest is that you update mySQL to a version 5 of higher. Or better still using SQL Server as SQL Server works much better with ASP and can also handle allot larger amount of users and posts.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting