bhlaserjet |
First Post Posted on: 05-10-08 09:17 PM |
MySQL Database error sqldriver.pm |
|
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 'CC_Number='',LName='H',Website='',City1='',CC_Year='',CC_Type=' Query: UPDATE Users SET Zip1=''CC_Number='',LName='H',Website='',City1='',CC_Year='',CC_Type='',Country='United States',City='Watersmeet',FName='Bob',Password="",CC_Month='',Fax='',CC_Name='',Country1='',Mobile='',State='Mi',Street='P.O. Box 400',Job_Title='',State1='',Phone='1-906-0000000',Email='bhlaserjet@netzero.net',Payment_Method='',Company='MaxAction',Last_Updated='1099400888',Zip='49969',Street1='', WHERE User_ID='' Line 742, File /home/bhlaserj/public_html/cgi-bin/auction/sqldriver.pm.
This error occured when updating User Profile. How do I fix it. Thanks |
|
|
|
|
|
|
mewsoft |
Reply #: 1 Posted on: 05-13-08 10:37 AM |
Re: MySQL Database error sqldriver.pm |
|
The above error code shows that the User_ID is empty, Make sure these form fields exists inside the editprofile template in the right place:
<INPUT TYPE="hidden" NAME="User_ID" VALUE="<!--User_ID-->"> <INPUT TYPE="hidden" NAME="Lang" VALUE="<!--Language-->"> <INPUT TYPE="hidden" NAME="action" VALUE="Save_Edit_Profile">
Or simply restore the editprofile template. |
Mewsoft Support www.mewsoft.com
|
|
|
|
|
mewsoft |
Reply #: 2 Posted on: 05-14-08 11:58 AM |
Re: MySQL Database error sqldriver.pm |
|
I am reposting your email as the solution for others:
Got it fixed . After looking a little closer. I found the directory path I was updating to did not match my configuration. It was the wrong path.
|
Mewsoft Support www.mewsoft.com
|
|
|
|
|
|
toymanpaul |
Reply #: 3 Posted on: 09-12-08 07:49 PM |
Edit Profile - problem |
|
This error occured when updating User Profile. 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. |
|
|
|
|
|
|