Update Error on MySQL - Web Wiz Support and Community Forums

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_update_USR
File Name:- register.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
Query-based update failed because the row to update could not be found.

----------------------------------------

i was use Access i convered my access db to mysql. but now my new users can't update him or her profils

Response.write "Asp"
Document.write("JavaScript")
Echo("Php")
WriteIn('Pascal-Delphi')
Printf("C")

Mail & GTalk : BeyazSeytan@gmail.com

thks for ansver. i convert sql query * to all tag. now problem is not

--------------------------------------------------------------------

'******************************************
'*** Read in user details from database ***
'******************************************

'Intialise the strSQL variable with an SQL string to open a record set for the Author table
strSQL = "SELECT " & strDbTable & "Author.* " & _
"FROM " & strDbTable & "Author" & strRowLock & " " & _
"WHERE " & strDbTable & "Author.Author_ID=" & lngUserProfileID & ";"

'Set the cursor type property of the record set to Dynamic so we can navigate through the record set
rsCommon.CursorType = 2

'Set the Lock Type for the records so that the record set is only locked when it is updated
rsCommon.LockType = 3

'Open the author table
rsCommon.Open strSQL, adoCon

convert to :

'******************************************
'*** Read in user details from database ***
'******************************************

'Intialise the strSQL variable with an SQL string to open a record set for the Author table
strSQL = "SELECT tblauthor.Author_ID, tblauthor.Group_ID, tblauthor.Username, tblauthor.Real_name, tblauthor.User_code, tblauthor.Password, tblauthor.Salt, tblauthor.Author_email, tblauthor.Homepage, tblauthor.Location, tblauthor.MSN, tblauthor.Yahoo, tblauthor.ICQ, tblauthor.AIM, tblauthor.Occupation, tblauthor.Interests, tblauthor.DOB, tblauthor.Signature, tblauthor.No_of_posts, tblauthor.No_of_PM, tblauthor.Join_date, tblauthor.Avatar, tblauthor.Avatar_title, tblauthor.Last_visit, tblauthor.Time_offset, tblauthor.Time_offset_hours, tblauthor.Date_format, tblauthor.Show_email, tblauthor.Attach_signature, tblauthor.Active, tblauthor.Rich_editor, tblauthor.Reply_notify, tblauthor.PM_notify, tblauthor.Skype, tblauthor.Login_attempt, tblauthor.Banned, tblauthor.Info " &_
"FROM " & strDbTable & "Author" & strRowLock & " " & _
"WHERE " & strDbTable & "Author.Author_ID=" & lngUserProfileID & ";"

'Set the cursor type property of the record set to Dynamic so we can navigate through the record set
rsCommon.CursorType = 2

'Set the Lock Type for the records so that the record set is only locked when it is updated
rsCommon.LockType = 3

'Open the author table
rsCommon.Open strSQL, adoCon

Response.write "Asp"
Document.write("JavaScript")
Echo("Php")
WriteIn('Pascal-Delphi')
Printf("C")

Mail & GTalk : BeyazSeytan@gmail.com