1064 syntax error when creating account

[mayleine]

Hi! Happy new year!!

I've been looking for threads about 1064 SQL error but I haven't seen one that is same as my problem. Hoping someone could help.

When my customers create account, after clicking submit, they get

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 '/ from zen_customers// w' at line 1
in:
[select customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax// from zen_customers// where customers_id = '31']

I tried making one account to test and I did get the error, however the customer was added in the database, it's just that the "create account success" page is missing and instead we are getting this error.

Please give me direction to solve this please. Thanks!

[mayleine]

By the way, i tried to look for the

customers_fax// from zen_customers// in the developer's tool kit but to no avail.

Hope someone could help, thanks!

[mayleine]

I reverted back to the classic template and it did the same thing. I know i shouldn't have changed any of those files there. I was looking into simplifying the account creation process and I read somewhere here that they usually edit it at the default templates. I shouldnt have done or even tried tinkering with it. Now i can't remember what file went wrong. Haha. curiosity killed the cat

[mayleine]

ok, so after the many things i did, what fixed it was this:
i logged into my other zen cart site, got the create.php file from the module folder and transferred it to the other site and it started acting normally.

sorry for the bother. happy new year!