View Single Post
  #46  
Old 06-29-2006, 07:49 AM
 
taltos1 taltos1 is offline
 

Senior Member
  
Join Date: Mar 2005
Location: USA
Posts: 160
 

Default

Hello all! I need some expert advice. I am trying to get this patch to work.

ALTER TABLE `xcart_customers` ADD UNIQUE (
`email`
);

it does seem to work (i patched through the xcart admin), however, when I try to create a account to test this, and use the same email as an existing account after i press submit I get this error on a blank white page:
Code:
INVALID SQL: 1062 : Duplicate entry 'email@hotmail.com' for key 3 SQL QUERY FAILURE: INSERT INTO xcart_customers ....

Also, there are not duplicate emails in the database.

then it goes to "user created" dialog message but upon checking in the admin the user is not actually created. Any insight about this error.

Any insight please let me know..
__________________
X-Cart Gold Version 4.0.18
EWDHosting.com is my Host
Unix Servers
Reply With Quote