fairtomidland Posted April 29, 2012 Share Posted April 29, 2012 Error log showing errors for all new orders since updating to CC5.08- File: [user.class.php] Line: [335] "INSERT INTO `CubeCart_customer` (`title`,`first_name`,`last_name`,`email`,`phone`,`mobile`,`password`,`registered`,`new_password`,`type`) VALUES ('','Firstname','lastname','[email protected]','555-555-1212','','de0fd3dcc902a91f9720f6dd898e4291','1335711091','','2');" - Duplicate entry '[email protected]' for key 'email' I subbed actual customer's name with "Firstname, lastname. Any ideas? Quote Link to comment Share on other sites More sharing options...
Toucan Web Design Posted April 30, 2012 Share Posted April 30, 2012 The email field has to be unique on the database, means it won't accept duplicates no. It sounds like there's actually a problem with the registration script, it should either update the database when it finds a matching email (if they were just on a mailing list), or throw an error normally. Had a look on the file and it looks ok though.. so hmm.. ah.. no, that'd be the problem, I thought the type field was for mailing lists.. but that's actually checking if they want to be registered..so definitely a bug there. Ok, in that case, you'll need to edit your database so that the email field no longer has to be unique. In phpmyadmin this is relatively straightforward, just go to the table, hit structure, then at the bottom there'll be an indexes section with something like: email BTREE Yes No email 4 A You should be ok to just delete that particular line, but I'd take a backup first just in case. If not in phpmyadmin, it gets a little trickier, so would have to know what you were using Quote Link to comment Share on other sites More sharing options...
fairtomidland Posted April 30, 2012 Author Share Posted April 30, 2012 Went into phpmyadmin and deleted the line after doing a backup. Thank you for the response. That fixed the problem. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.