Xtremer360 Posted June 18, 2011 Share Posted June 18, 2011 I'm getting the following error in the db when I try and run the query because its not performing the query in the script. Any ideas why? #1062 - Duplicate entry '' for key 'registrationKey' UPDATE manager_users_registrations, manager_users SET manager_users_registrations.registrationKey = '', manager_users.statusID = 2 WHERE manager_users_registrations.userID = '10008' AND manager_users.userID = '10008' Quote Link to comment https://forums.phpfreaks.com/topic/239750-not-performing-update/ Share on other sites More sharing options...
.josh Posted June 19, 2011 Share Posted June 19, 2011 error is pretty straight forward... you have your registrationKey column set to only allow unique values (no two rows can have the same value). And there is another row with '' as the value Quote Link to comment https://forums.phpfreaks.com/topic/239750-not-performing-update/#findComment-1231606 Share on other sites More sharing options...
Xtremer360 Posted June 19, 2011 Author Share Posted June 19, 2011 Oops forgot I did that. Quote Link to comment https://forums.phpfreaks.com/topic/239750-not-performing-update/#findComment-1231607 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.