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.
Topic Options
Post Options
Thanks(0)
