RSS Forums RSS

Duplicate entry '' for key 2

Reply
Posts: 28
Reputation: cali_dotcom is an unknown quantity at this point 
Solved Threads: 0
cali_dotcom cali_dotcom is offline Offline
Light Poster

Duplicate entry '' for key 2

  #1  
Nov 17th, 2008
hi everyone,
i keep on getting this error when i try to insert a value into a table via php.
Duplicate entry '' for key 2

i've tried a lot of solutions from the web including changing the the primary key from int to bigint. i also flushed the database and deleted all entries from the database but i still got that error. i could insert records from the nysql command prompt but not from the php script.
does anyone know what might be wrong?
the table in question looks like this:

  1. CREATE TABLE `article_fields` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `field_title` varchar(75) NOT NULL,
  4. `field_type` varchar(75) NOT NULL,
  5. PRIMARY KEY (`id`)
  6. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


and my php code to insert data into the table looks like this:
$sql = 'INSERT INTO article_fields VALUES("NULL","'.$new_text.'","'.$field_type.'")';
			$insert = mysql_query($sql) or die(mysql_error());
Last edited by peter_budo : Nov 20th, 2008 at 11:42 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
AddThis Social Bookmark Button
Reply With Quote  
Posts: 1,006
Reputation: kkeith29 will become famous soon enough kkeith29 will become famous soon enough 
Solved Threads: 121
kkeith29's Avatar
kkeith29 kkeith29 is offline Offline
Veteran Poster

Re: Duplicate entry '' for key 2

  #2  
Nov 17th, 2008
you can't have the same primary key twice. hence the "duplicate entry". you are setting it as NULL. just omit the primary key entry in the values all together.

like this:

$sql = "INSERT INTO `article_fields` (`field_title`,`field_type`) VALUES ('{$new_text}','{$field_type}')";
Last edited by kkeith29 : Nov 17th, 2008 at 11:10 pm.
Reply With Quote  
Posts: 14
Reputation: jack239 is an unknown quantity at this point 
Solved Threads: 1
jack239's Avatar
jack239 jack239 is offline Offline
Newbie Poster

Re: Duplicate entry '' for key 2

  #3  
Nov 18th, 2008
Because you have set the primary key to be auto incremented so you don't need to pass anything here.
Stuck in the middle of Java/PHP/Ajax development?

For free help on any technology and free articles visit http://www.techcubetalk.com
Reply With Quote  
Posts: 232
Reputation: Rhyan is an unknown quantity at this point 
Solved Threads: 24
Rhyan's Avatar
Rhyan Rhyan is offline Offline
Posting Whiz in Training

Re: Duplicate entry '' for key 2

  #4  
Nov 18th, 2008
Keith,

You can insert records in a table exactly as cali_dotcom does, it is not oblgatory to do it by mentioning the column names where you want to insert data. Your approach is OK when you want to insert data in different order than the columns in the table.
The problem with the script is that "NULL" is different from NULL without quotes. MySQL considers "NULL" to be a string and does not validate it as the value NULL.

So this should work perfectly
$sql = 'INSERT INTO article_fields VALUES(NULL,"'.$new_text.'","'.$field_type.'")';

Also, when inserting numbers it is good to insert them not surrounded by "" as MySQL validates numbers correctly.
" Of all the things I've lost,
I miss my mind the most...."
Mark Twain
Reply With Quote  
Posts: 28
Reputation: cali_dotcom is an unknown quantity at this point 
Solved Threads: 0
cali_dotcom cali_dotcom is offline Offline
Light Poster

Re: Duplicate entry '' for key 2

  #5  
Nov 18th, 2008
i've tried every single suggestion i found on the web, but i still wont work. actually, it worked just one time and then i clicked again, and then it gave me the same error again. i,ve tried flushing the table, emptying the table checking and repairing the table from phpmyadmin.

does anyone know what could still be wrong?
Reply With Quote  
Posts: 232
Reputation: Rhyan is an unknown quantity at this point 
Solved Threads: 24
Rhyan's Avatar
Rhyan Rhyan is offline Offline
Posting Whiz in Training

Re: Duplicate entry '' for key 2

  #6  
Nov 18th, 2008
I suggest you do the following :

echo $sql;

Then simply copy the string from your browser and paste it into phpmyadmin sql statement and run it.
If it shouts an error, and it is still the same, paste here the sql string and we'll see. I don't see anything wrong there, but you never know, a single ' may ruin the whole thing...
" Of all the things I've lost,
I miss my mind the most...."
Mark Twain
Reply With Quote  
Posts: 28
Reputation: cali_dotcom is an unknown quantity at this point 
Solved Threads: 0
cali_dotcom cali_dotcom is offline Offline
Light Poster

Re: Duplicate entry '' for key 2

  #7  
Nov 18th, 2008
i ran this code on php myadmin:
INSERT INTO `article_fields`(`field_title`, `field_type`) VALUES("'.$new_text.'","'.$field_type.'")
and it worked. the problem is running that code from a php script. did i mention that i was using the zend framework.
Reply With Quote  
Posts: 232
Reputation: Rhyan is an unknown quantity at this point 
Solved Threads: 24
Rhyan's Avatar
Rhyan Rhyan is offline Offline
Posting Whiz in Training

Re: Duplicate entry '' for key 2

  #8  
Nov 18th, 2008
No, you did not mention the ZEND.
However, this insert as you have typed it contains the variable names instead of variable values. Is this the php code or the result from the php echo command?

I am not 100% sure you need the table and field names surrounded by ' ', but, still if it works, maybe it is ok.
Why don't you try this code. It works fine for me in multiple pages, so I have it verified numerous times.

  1. $sql = 'INSERT INTO article_fields VALUES (NULL, \''.$new_text.'\', \''.$field_type.'\')';

I think that this code will be ok also for the zend framework.
" Of all the things I've lost,
I miss my mind the most...."
Mark Twain
Reply With Quote  
Posts: 28
Reputation: cali_dotcom is an unknown quantity at this point 
Solved Threads: 0
cali_dotcom cali_dotcom is offline Offline
Light Poster

Re: Duplicate entry '' for key 2

  #9  
Nov 18th, 2008
Originally Posted by Rhyan View Post
However, this insert as you have typed it contains the variable names instead of variable values. Is this the php code or the result from the php echo command?

.

i'm not sure what you mean but those are vaiables i got from a command like:

$new_text = $_GET['new_text'];
Reply With Quote  
Posts: 28
Reputation: cali_dotcom is an unknown quantity at this point 
Solved Threads: 0
cali_dotcom cali_dotcom is offline Offline
Light Poster

Re: Duplicate entry '' for key 2

  #10  
Nov 18th, 2008
Originally Posted by Rhyan View Post

  1. $sql = 'INSERT INTO article_fields VALUES (NULL, \''.$new_text.'\', \''.$field_type.'\')';



i just tried this code but it still didn't work.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Views: 1765 | Replies: 13 | Currently Viewing: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 1:47 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC