Web Wiz Forums - "Query-based update" error after Access -> MySQL

Print Page | Close Window

"Query-based update" error after Access -> 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=22309
Printed Date: 08 April 2026 at 4:49am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: "Query-based update" error after Access -> MySQL

Posted By: Imperator
Subject: "Query-based update" error after Access -> MySQL
Date Posted: 01 January 2007 at 9:22pm

I recently converted an 860 MB Access database, originally upgraded from version 7.x to MySQL. The conversion was done row by row INSERT through an on-server script. Everything is fine except when I update forum posts made before the conversion, which gives me the error Query-based update failed because the row to update could not be found..

For example, when I try to edit the post it gives me:

SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message,
tblThread.Show_signature, tblThread.IP_addr, tblThread.Hide,
tblThread.File_uploads FROM tblThread WHERE tblThread.Thread_ID=312611;

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Query-based update failed because the row to update could not be found.

/forum/edit_post.asp, line 685

A similar error occurs when I sticky or unsticky old posts or edit signatures. Interestingly, the error does not occur to any posts made after the database conversion.

I'm interested what others here think about the error. I was reading some other material on the internet, such as:

http://www.issociate.de/board/post/198565/Query-based_update_failed_because_the_row_to_update_could_not_be_found.html - http://www.issociate.de/board/post/198565/Query-based_update_failed_because_the_row_to_update_could_not_be_found.html

It appears that the error might be related to myODBC and not the database data. However, it also seems illogical why some parts of the data give that error and others don't. I've also been able to update the data using my own SQL queries.

Anyone have an idea? As you can see, my Access database is quite large and I need to get out of it. Unfortunately, I'm not sure if I can live with the current errors, since my members can't update their signatures.

Replies:

Posted By: Imperator
Date Posted: 04 January 2007 at 3:26pm

I couldn't really find a direct solution to the problem. I guess the only solution would be to remove the recordset update function calls and replace them with SQL queries.

Posted By: diogomoura
Date Posted: 06 February 2007 at 2:26pm

I'm having the same issue deleting post's!! If I delete an entire post it won't fail, but if I delete one singular post it will give me the exact same error than you.

I'd migrated from v7 access to latest v8 mySQL, just like you and did all the steps with careful.

I' d already tried to re-upload the file delete_post.asp put no sucess.