Forums / Bug Reports / SQL Syntax Error when updating Account Information

SQL Syntax Error when updating Account Information

Locked

Started by charagg on 24 Dec 2009, 9:13 PM · Views: 1,182

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
24 Dec 2009, 9:13 PM
#1
charagg avatar

charagg

New Zenner

Join Date:
Dec 2008
Posts:
45
Plugin Contributions:
0

SQL Syntax Error when updating Account Information

I am running ZC 1.3.8a with PHP 5.2.9 - I have several add-ons, but hopefully providing the error message will help.

When I hit the Update button from the My Account Information page, I get the following error:

1064 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 '[email protected]'' at line 1
in:
[update phpbb_users set user_email='[email protected]', user_email_hash = '-191172413323'' where user_email = '[email protected]']

in my server's error log, I get the following:

[Thu Dec 24 14:08:08 2009] [error] [client 68.124.134.68] File does not exist: /var/www/vhosts/myaccountname/httpdocs/greybox, referer: https://www.myurl.net/index.php?main_page=account_edit
[Thu Dec 24 14:08:08 2009] [error] [client 68.124.134.68] File does not exist: /var/www/vhosts/myaccountname/httpdocs/includes/templates/mydirectory/css/"", referer: https://www.bemyrul.net/index.php?main_page=account_edit

I am at a loss - can anyone offer some help or insight as to how I can correct this? Is it in the DB or in a file? Trying to get site live for 1/1/2010.

Thanks - Merry Christmas!

AC

BenchmarkDesign.Net - Integrated Media Solutions

25 Dec 2009, 2:16 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: SQL Syntax Error when updating Account Information

Assuming that you have created a personal template - - Try swtching to the default classic/contempoary green template and see if the issue persists

Zen-Venom Get Bitten