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' 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 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. Link to comment https://forums.phpfreaks.com/topic/239750-not-performing-update/#findComment-1231607 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.