Web Wiz Support and Community Forums : Update Error on MySQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 07:30:35 +0000 Mon, 07 Aug 2006 20:05:35 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20942 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Update Error on MySQL : Glad you have found a solution...]]> https://forums.webwiz.net/update-error-on-mysql_topic20942_post112275.html#112275 Author: WebWiz-Bruce
Subject: 20942
Posted: 07 August 2006 at 8:05pm

Glad you have found a solution to this problem, I will look into the solution you have offered. Thanks
]]> Mon, 07 Aug 2006 20:05:35 +0000 https://forums.webwiz.net/update-error-on-mysql_topic20942_post112275.html#112275 <![CDATA[Update Error on MySQL : thks for ansver. i convert sql...]]> https://forums.webwiz.net/update-error-on-mysql_topic20942_post112267.html#112267 Author: beyaz_seytan
Subject: 20942
Posted: 07 August 2006 at 4:36pm

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

]]> Mon, 07 Aug 2006 16:36:48 +0000 https://forums.webwiz.net/update-error-on-mysql_topic20942_post112267.html#112267 <![CDATA[Update Error on MySQL : Sounds like it maybe an issue...]]> https://forums.webwiz.net/update-error-on-mysql_topic20942_post112261.html#112261 Author: WebWiz-Bruce
Subject: 20942
Posted: 07 August 2006 at 2:58pm

Sounds like it maybe an issue with the way you have created or moved your database from Access to mySQL.]]> Mon, 07 Aug 2006 14:58:15 +0000 https://forums.webwiz.net/update-error-on-mysql_topic20942_post112261.html#112261 <![CDATA[Update Error on MySQL : Server Error in Forum ApplicationAn...]]> https://forums.webwiz.net/update-error-on-mysql_topic20942_post112254.html#112254 Author: beyaz_seytan
Subject: 20942
Posted: 07 August 2006 at 1:46pm

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
]]> Mon, 07 Aug 2006 13:46:33 +0000 https://forums.webwiz.net/update-error-on-mysql_topic20942_post112254.html#112254