| jm |
First Post Posted on: 03-22-08 06:23 PM |
| Users canīt edit his accounts |
|
Since i have made the upgrade and update, people canīt edit his register
information.
I have a SQL error:
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 'City='Villanueva de la Torre',FName='José Manuel',State='Guadal
Query:
UPDATE Users SET Street='Monte de Encinas 12'City='Villanueva de la Torre',FName='José Manuel',State='Guadalajara',Password='jmcj',Website='http://www.bricomadelmania.com',Zip='19209',Email='jmcortes2@bricomadelmania.com',Company='Bricomadelmanía',CC_Year='',Country1='',Mobile='',State1='',CC_Name='',Payment_Method='',Phone='949273757',Country='Any',CC_Month='',Last_Updated='1095182810',Zip1='',LName='Cortés Jiménez',CC_Number='',Street1='',City1='',Job_Title='Director de Arte',Fax='',CC_Type='', WHERE User_ID='brico'
Line 742, File C:/Inetpub/wwwroot/coleccionalia/subast/sqldriver.pm.
all other utilities in the auction play very well
thanks |
|
|
|
|
|
 |
| Marty |
Reply #: 1 Posted on: 03-22-08 07:47 PM |
| Re: Users canīt edit his accounts |
|
|
|
|
| mewsoft |
Reply #: 2 Posted on: 03-22-08 09:22 PM |
| Re: Users canīt edit his accounts |
|
| You need to do all the upgrade steps, see the post on the upgrade forum. You need to upload the file Upgrade.cgi and call it once from the browser. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| jm |
Reply #: 3 Posted on: 03-23-08 02:45 AM |
| Re: Users canīt edit his accounts |
|
i have make all the upgrade steps and play upgrade.cgi. (user1, user2,....)
In fact my database is OK during users register . The problem is when edit the users data. |
|
|
|
|
|
| mewsoft |
Reply #: 4 Posted on: 03-24-08 07:24 AM |
| Re: Users canīt edit his accounts |
|
| Did you uograded the Editprofile.pm file, you need to use the latest file from our site. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| jm |
Reply #: 5 Posted on: 03-25-08 11:55 PM |
| Re: Users canīt edit his accounts |
|
I have the last "editprofile.pm" file but all is the same.
other solution or posibility?
Thanks |
|
|
|
|
|
| mewsoft |
Reply #: 6 Posted on: 03-26-08 01:11 AM |
| Re: Users canīt edit his accounts |
|
| Update the file sqldriver.pm, it is better to update all *.pm files. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| jm |
Reply #: 7 Posted on: 03-28-08 12:27 PM |
| Re: Users canīt edit his accounts |
|
|
|
|
|