Web Wiz Support and Community Forums : "Query-based update" error after Access -> MySQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 04:53:04 +0000 Tue, 06 Feb 2007 14:26:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22309 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA["Query-based update" error after Access -> MySQL : I&#039;m having the same issue...]]> https://forums.webwiz.net/querybased-update-error-after-access-mysql_topic22309_post120284.html#120284 Author: diogomoura
Subject: 22309
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.
]]> Tue, 06 Feb 2007 14:26:51 +0000 https://forums.webwiz.net/querybased-update-error-after-access-mysql_topic22309_post120284.html#120284 <![CDATA["Query-based update" error after Access -> MySQL : I couldn&#039;t really find a...]]> https://forums.webwiz.net/querybased-update-error-after-access-mysql_topic22309_post119060.html#119060 Author: Imperator
Subject: 22309
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.]]> Thu, 04 Jan 2007 15:26:32 +0000 https://forums.webwiz.net/querybased-update-error-after-access-mysql_topic22309_post119060.html#119060 <![CDATA["Query-based update" error after Access -> MySQL : I recently converted an 860 MB...]]> https://forums.webwiz.net/querybased-update-error-after-access-mysql_topic22309_post118957.html#118957 Author: Imperator
Subject: 22309
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

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.

]]> Mon, 01 Jan 2007 21:22:53 +0000 https://forums.webwiz.net/querybased-update-error-after-access-mysql_topic22309_post118957.html#118957