Hi Ng,
Sorry to post again, but I was doing some other testing and when I signed up for an account with a duplicate email address i got this ugly sql error:
Code:
1062 Duplicate entry '[email protected]' for key 2
in:
[INSERT INTO subscribers (customers_id, email_address, email_format, confirmed) VALUES ('9', '[email protected]', 'HTML', '1')]
If I refresh, it goes back to my cart with the proper error displayed. I can try to submit again, and an alert pops up stating my 'state' needs to have more than 2 characters.
I found this code in a post a while back:
Code:
ALTER TABLE `subscribers` CHANGE `subscriber_id` `subscriber_id` INT( 11 ) NOT NULL AUTO_INCREMENT
Is this something I should run from my ZC admin?
Thanks again,
Colin
Bookmarks