1064 error when creating new account

[CTapia]

Please assist

I've just installed PWA on 2.2 and managed to create a new account. When I tried to create another I get this....

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 '= 'ctapia@telstra.com'' at line 1

select customers_id, customers_email_address, purchased_without_account from customerswhere customers_email_address = 'ctapia@telstra.com'

[TEP STOP]

The posts related to this error do not seem to address my problem with account creation.

Any ideas..?

Thanks
Claudio

[wenzlerpaul]

Hi Claudio,

If you are using PWA, the pattern that this MOD does is it registers your temporary info via session and via mysql, after every purchase/session expiry/log out or closing down the page, it unregisters all temporary information, and by default, anybody that opens up your store will prompt the system to also delete any remaining temporary account(s) that were not successfully removed, however, what may cause your error is you may have not closed the page or the session is still active when you tried to create a new one, this will likely cause a conflict of session plus the current information that is already logged in, you may issue a session_destroy(); on the top of login page to kill all possible session that are still alive.

Also, another issue that may cause this is that you may have not updated the sql tables, please check if you were able to successfully change the required table updates.

These are only pure assumptions and there may be some other explanation that causes your error, another suggestion is that you revert back to the original state of your system before the PWA addon you did, carefully do the PWA MOD again and carefully take note of the instructions provided.

Hope it helps,
Paul

[CTapia]

Thanks for your quick reply Paul, while checking your assumptions I run a test on a fresh install using the same DB. This time I got an error telling me the email already exists and suggesting to sign in as a returning customer. This made me realise that although I was creating the account with different customer details I was including existing email addresses (which I assume need to be unique for each customer in osc) resulting in the 1064 error.....??

I've since deleted test customers via Admin and recreated them successfuly...

Thanks once again

Regards
Claudio