# Cannot insert data into mysql

**URL:** <https://www.ruby-forum.com/t/cannot-insert-data-into-mysql/193979>\
**Category:** Rails\
**Created:** [August 27, 2010, 2:30pm UTC](https://www.ruby-forum.com/t/cannot-insert-data-into-mysql/193979 "2010-08-27T14:30:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![irfan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/8797f3/32.png) [@irfan](https://www.ruby-forum.com/u/irfan)\
**Post date:** [August 27, 2010, 2:30pm UTC](https://www.ruby-forum.com/t/cannot-insert-data-into-mysql/193979/1 "2010-08-27T14:30:55Z")

</div>

When I am going to create a new product Item into my depot application  
I  
got the following error:

Mysql::Error: #23000Duplicate entry ‘0’ for key 1: INSERT INTO  
products (`image_url`, `date_available`, `price`, `title`,  
`description`) VALUES(‘[http://www.facebook.com/Meghkabbo.png](http://www.facebook.com/Meghkabbo.png)’,  
‘2010-08-27 12:23:00’, ‘90.0’, ‘jjhjh’, ‘hgjgjhjkhjhkhkkkkkhkhkhkh’)

I am new to ruby on rails and following Agile Web D. with  
Rails.

Please help me about the problem.

–  
Thanks  
Irfan

---

<div class="post-metadata">

**Author:** ![irfan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/8797f3/32.png) [@irfan](https://www.ruby-forum.com/u/irfan)\
**Post date:** [August 27, 2010, 8:26pm UTC](https://www.ruby-forum.com/t/cannot-insert-data-into-mysql/193979/2 "2010-08-27T20:26:57Z")

</div>

the id is not auto-increment but unique

2010/8/27 Irfan A. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![irfan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/8797f3/32.png) [@irfan](https://www.ruby-forum.com/u/irfan)\
**Post date:** [August 27, 2010, 11:26pm UTC](https://www.ruby-forum.com/t/cannot-insert-data-into-mysql/193979/3 "2010-08-27T23:26:06Z")

</div>

yap I have solved that problem it was not set to auto increment. Thanks  
dear:)

On 28 August 2010 00:25, Sergio S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> > To unsubscribe from this group, send email to  
> > To unsubscribe from this group, send email to  
> > removed\_email\_address@domain.invalid[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> > .  
> > For more options, visit this group at  
> > [http://groups.google.com/group/rubyonrails-talk?hl=en](http://groups.google.com/group/rubyonrails-talk?hl=en).

–  
Irfan A. Rizvi  
[http://www.creativemake.com](http://www.creativemake.com)