Welcome Visitor, Please Login or Register Now Wednesday, April 24, 2024 07:36 PM 
Forums Index > Mewsoft Products > Auctionawy > MySQL Database error sqldriver.pm
New Topic   New Reply
Search for:
Author Message
bhlaserjet bhlaserjet's personal page
Registered Member
Posts: 88 Display member's posts
Joined: 04-24-24 07:36 PM
Member Offline
View Member's Profile Send private message
 
Back to top
MySQL Database error sqldriver.pm Edit Delete Reply with quote Quote
First Post Posted on: 05-10-08 09:17 PM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-24-24 07:36 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: MySQL Database error sqldriver.pm Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 05-13-08 10:37 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-24-24 07:36 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: MySQL Database error sqldriver.pm Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 05-14-08 11:58 AM next post previous post
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 toymanpaul's personal page
Registered Member
Posts: 16 Display member's posts
Joined: 04-24-24 07:36 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Edit Profile - problem Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 09-12-08 07:49 PM last post previous post
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.
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print  

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.1091 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation