Forums Index > Mewsoft Products > Auctionawy > error when updating user profile
toymanpaul First Post Posted on: 09-13-08 12:42 PM
error when updating user profile

This error occured when updating User Profile. Can anyone please help/advise, How do I fix it.\ Thanks.\ \ SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'City1='',State1='',Password='ehu9qsaf',LName='Scoggins',FName='George',Country1=' at line 1\ Query: \ UPDATE Users SET Country='United States'City1='',State1='',Password='ehu9qsaf',LName='Scoggins',FName='George',Country1='',Street1='',Mobile='',Phone='8302174301',Payment_Method='',State='Tx',CC_Name='',Website='',City='La Vernia',Fax='',CC_Month='',CC_Type='',Job_Title='',CC_Number='',Zip='78121',CC_Year='',Email='bidsa@isp.com',Company='',Street='273 Hickory Run',Zip1='',Last_Updated='1110214233', WHERE User_ID='rebel'\ Line 742, File /www/b/bidup2wincom/cgi-bin/auction/sqldriver.pm.
mewsoft Reply #: 1 Posted on: 09-13-08 07:59 PM
Re: error when updating user profile

What version are you using? That was an old issue with NE 6.xx, make sure you are using the latest Netauction 6.xx if you still using it or upgrade to Auctionawy 2005.

Mewsoft Support
www.mewsoft.com