lAZLf Posted February 19, 2010 Share Posted February 19, 2010 help me find out what this error message means: "Duplicate entry '0' for key 'PRIMARY'" the sql for it is INSERT INTO accounts (firstname, lastname, username, password, joined, email, level) VALUES ('$_POST[fname]','$_POST[lname]','$_POST[user]',sha1('$_POST[pass]'),'$date','$_POST[email]','norm')"; $sqlcheck= mysql_query("SELECT * FROM accounts WHERE username = '$_POST[user]' OR email = '$_POST[email]' Quote Link to comment https://forums.phpfreaks.com/topic/192586-mysql-error-message/ Share on other sites More sharing options...
djfox Posted February 19, 2010 Share Posted February 19, 2010 I`m no expert, but I would think that means that when you set up the database table, you made two or more entries primary when only one needs to be primary. Quote Link to comment https://forums.phpfreaks.com/topic/192586-mysql-error-message/#findComment-1014625 Share on other sites More sharing options...
lAZLf Posted February 19, 2010 Author Share Posted February 19, 2010 Nope thats not it. I checked my database setup. Quote Link to comment https://forums.phpfreaks.com/topic/192586-mysql-error-message/#findComment-1014628 Share on other sites More sharing options...
lAZLf Posted February 19, 2010 Author Share Posted February 19, 2010 Bump. And to clearify the sql i used was: INSERT INTO accounts (firstname, lastname, username, password, joined, email, level) VALUES ('$_POST[fname]','$_POST[lname]','$_POST[user]',sha1('$_POST[pass]'),'$date','$_POST[email]','norm') (on the original post I accidentally included the variable below it) Quote Link to comment https://forums.phpfreaks.com/topic/192586-mysql-error-message/#findComment-1014829 Share on other sites More sharing options...
PFMaBiSmAd Posted February 19, 2010 Share Posted February 19, 2010 The error message does state what the problem is - one of your columns is defined as a primary key and you are trying to insert a duplicate value for that column. What do you want to happen when this condition (duplicate data values) occurs? Quote Link to comment https://forums.phpfreaks.com/topic/192586-mysql-error-message/#findComment-1014833 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.