# Won't auto\_increment

**URL:** <https://www.ruby-forum.com/t/wont-auto-increment/64336>\
**Category:** Rails\
**Created:** [January 23, 2006, 5:04am UTC](https://www.ruby-forum.com/t/wont-auto-increment/64336 "2006-01-23T05:04:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bimo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/f05b48/32.png) [@bimo](https://www.ruby-forum.com/u/bimo)\
**Post date:** [January 23, 2006, 5:04am UTC](https://www.ruby-forum.com/t/wont-auto-increment/64336/1 "2006-01-23T05:04:16Z")

</div>

I am writing my first RoR ap and am having problems with ActiveRecord’s  
basic functions. The first one is that the id column is not auto  
incrementing. I can add one record but after that it says,  
“Mysql::Error: #23000Duplicate entry ‘0’ for key 1”…

b

---

<div class="post-metadata">

**Author:** ![bimo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/f05b48/32.png) [@bimo](https://www.ruby-forum.com/u/bimo)\
**Post date:** [January 23, 2006, 5:17am UTC](https://www.ruby-forum.com/t/wont-auto-increment/64336/2 "2006-01-23T05:17:20Z")

</div>

bimo remus wrote:

> I am writing my first RoR ap and am having problems with ActiveRecord’s  
> basic functions. The first one is that the id column is not auto  
> incrementing. I can add one record but after that it says,  
> “Mysql::Error: #23000Duplicate entry ‘0’ for key 1”…
> 
> b

Make sure your ‘id’ column in the MySQL table is defined as  
auto\_increment.

---

<div class="post-metadata">

**Author:** ![bimo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/f05b48/32.png) [@bimo](https://www.ruby-forum.com/u/bimo)\
**Post date:** [January 23, 2006, 5:45am UTC](https://www.ruby-forum.com/t/wont-auto-increment/64336/3 "2006-01-23T05:45:57Z")

</div>

… i’m so embarassed…

thanks, though

---

<div class="post-metadata">

**Author:** ![bimo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/f05b48/32.png) [@bimo](https://www.ruby-forum.com/u/bimo)\
**Post date:** [January 23, 2006, 5:47am UTC](https://www.ruby-forum.com/t/wont-auto-increment/64336/4 "2006-01-23T05:47:01Z")

</div>

embarrassed

---

<div class="post-metadata">

**Author:** ![bimo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/f05b48/32.png) [@bimo](https://www.ruby-forum.com/u/bimo)\
**Post date:** [January 23, 2006, 1:06pm UTC](https://www.ruby-forum.com/t/wont-auto-increment/64336/5 "2006-01-23T13:06:09Z")

</div>

Kevin O. wrote:

> 

And put ‘migrations’ on your list of things to look at soon. They take  
that sort of problem away quite nicely.