osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

1064 error when creating new account

This is a discussion on 1064 error when creating new account within the osCommerce 2.2 Installation Help forums, part of the osCommerce 2.2 Forums category; Please assist I've just installed PWA on 2.2 and managed to create a new account. When I tried to create ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Installation Help

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 09-30-2004, 05:41 PM
Lurker
 
Join Date: Jun 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
CTapia
Default 1064 error when creating new account

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 09-30-2004, 09:31 PM
Member
 
Join Date: Aug 2004
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
wenzlerpaul
Default

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 10-01-2004, 02:20 AM
Lurker
 
Join Date: Jun 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
CTapia
Default

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Creating an account Milmod osCommerce 2.2 Installation Help 0 09-05-2005 08:30 PM
1064 - You have an error in your SQL syntax. jamie74 osCommerce 2.2 Modification Help 0 10-20-2004 11:45 AM
Runtime error when creating account kjscannondale osCommerce 2.2 Installation Help 9 07-03-2004 04:39 PM
Error when creating account herwig osCommerce 2.2 Installation Help 1 12-14-2003 11:19 AM
Fatal error in sessions.php when creating a new account f10 osCommerce 2.2 Modification Help 1 06-14-2003 10:11 PM


All times are GMT -8. The time now is 09:33 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax