# MySQL Duplicate Key Error **URL:** \ **Category:** Rails\ **Created:** [February 23, 2006, 3:39am UTC](https://www.ruby-forum.com/t/mysql-duplicate-key-error/54101 "2006-02-23T03:39:25Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Navin\_Samuel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/7ea924/32.png) [@Navin\_Samuel](https://www.ruby-forum.com/u/Navin_Samuel)\ **Post date:** [February 23, 2006, 3:39am UTC](https://www.ruby-forum.com/t/mysql-duplicate-key-error/54101/1 "2006-02-23T03:39:25Z")
I am a newbie and I am running into a problem which I cant understand. I have a table called ‘privileges’ which has the following fields CREATE TABLE `sdqualplanner`.`privileges` ( `id` int(10) unsigned NOT NULL auto\_increment, `name` varchar(20) NOT NULL default ‘’, `description` varchar(100) NOT NULL default ‘’, `section_id` int(10) unsigned NOT NULL default ‘0’, `designation_id` int(10) unsigned NOT NULL default ‘0’, `department_id` int(10) unsigned NOT NULL default ‘0’, `view` varchar(1) NOT NULL default ‘1’, `create` varchar(1) NOT NULL default ‘0’, `modify` varchar(1) NOT NULL default ‘0’, `delete` varchar(1) NOT NULL default ‘0’, `created_on` timestamp NOT NULL default ‘0000-00-00 00:00:00’, `updated_on` timestamp NOT NULL default ‘0000-00-00 00:00:00’, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Relted tables ‘sections’, ‘designations’ & ‘departments’ are all populated. When I create a new ‘privilege’ entry using the generated scaffold code, I get this error. I am attaching the development log below ============================================ Processing PrivilegesController#create (for 127.0.0.1 at 2006-02-22 18:25:17) [POST] Parameters: {“commit”=\>“Create”, “action”=\>“create”, “controller”=\>“privileges”, “privilege”=\>{“delete”=\>“0”, “name”=\>"Hey ", “designation\_id”=\>“1”, “section\_id”=\>“1”, “modify”=\>“0”, “description”=\>“Again”, “create”=\>“0”, “department\_id”=\>“1”, “view”=\>“1”}} e[4;35;1mPrivilege Columns (0.020000)e[0m e[0mSHOW FIELDS FROM privilegese[0m e[4;36;1mSQL (0.010000)e[0m e[0;1mBEGINe[0m e[4;35;1mSQL (0.010000)e[0m e[0mINSERT INTO privileges (`created_on`, `delete`, `name`, `designation_id`, `section_id`, `updated_on`, `modify`, `create`, `description`, `department_id`, `view`) VALUES(‘2006-02-22 18:25:17’, ‘0’, 'Hey ', 1, 1, ‘2006-02-22 18:25:17’, ‘0’, ‘0’, ‘Again’, 1, ‘1’)e[0m e[4;36;1mSQL (0.050000)e[0m e[0;1mCOMMITe[0m Redirected to [http://localhost:3000/privileges/list](http://localhost:3000/privileges/list) Completed in 0.11000 (9 reqs/sec) | DB: 0.09000 (81%) | 302 Found [[http://localhost/privileges/create](http://localhost/privileges/create)] Processing PrivilegesController#list (for 127.0.0.1 at 2006-02-22 18:25:18) [GET] Parameters: {“action”=\>“list”, “controller”=\>“privileges”} e[4;35;1mPrivilege Count (0.000000)e[0m e[0mSELECT COUNT(\*) FROM privileges e[0m e[4;36;1mPrivilege Load (0.000000)e[0m e[0;1mSELECT \* FROM privileges LIMIT 0, 10e[0m Rendering within layouts/privileges Rendering privileges/list e[4;35;1mPrivilege Columns (0.020000)e[0m e[0mSHOW FIELDS FROM privilegese[0m e[4;36;1mSQL (0.000000)e[0m e[0;1mMysql::Error: #23000Duplicate entry ‘1’ for key 1: INSERT INTO privileges (`created_on`, `delete`, `name`, `designation_id`, `section_id`, `updated_on`, `modify`, `id`, `create`, `description`, `department_id`, `view`) VALUES(‘2006-02-22 18:21:56’, ‘0’, ‘Navin’, 0, 0, ‘2006-02-22 18:25:18’, ‘0’, 1, ‘0’, ‘Samuel’, 0, ‘1’)e[0m ============================================ What I dont understand is that after successlly creating the row in the table, why is the code trying to do a second insert? Please help me. I am struggling with this for the past two days! ---
**Author:** ![Navin\_Samuel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/7ea924/32.png) [@Navin\_Samuel](https://www.ruby-forum.com/u/Navin_Samuel)\ **Post date:** [February 23, 2006, 3:48am UTC](https://www.ruby-forum.com/t/mysql-duplicate-key-error/54101/2 "2006-02-23T03:48:16Z")
Here is the log once again with the code in which the error was triggered ===================================================== Processing PrivilegesController#create (for 127.0.0.1 at 2006-02-22 18:25:17) [POST] Parameters: {“commit”=\>“Create”, “action”=\>“create”, “controller”=\>“privileges”, “privilege”=\>{“delete”=\>“0”, “name”=\>"Hey ", “designation\_id”=\>“1”, “section\_id”=\>“1”, “modify”=\>“0”, “description”=\>“Again”, “create”=\>“0”, “department\_id”=\>“1”, “view”=\>“1”}} e[4;35;1mPrivilege Columns (0.020000)e[0m e[0mSHOW FIELDS FROM privilegese[0m e[4;36;1mSQL (0.010000)e[0m e[0;1mBEGINe[0m e[4;35;1mSQL (0.010000)e[0m e[0mINSERT INTO privileges (`created_on`, `delete`, `name`, `designation_id`, `section_id`, `updated_on`, `modify`, `create`, `description`, `department_id`, `view`) VALUES(‘2006-02-22 18:25:17’, ‘0’, 'Hey ', 1, 1, ‘2006-02-22 18:25:17’, ‘0’, ‘0’, ‘Again’, 1, ‘1’)e[0m e[4;36;1mSQL (0.050000)e[0m e[0;1mCOMMITe[0m Redirected to [http://localhost:3000/privileges/list](http://localhost:3000/privileges/list) Completed in 0.11000 (9 reqs/sec) | DB: 0.09000 (81%) | 302 Found [[http://localhost/privileges/create](http://localhost/privileges/create)] Processing PrivilegesController#list (for 127.0.0.1 at 2006-02-22 18:25:18) [GET] Parameters: {“action”=\>“list”, “controller”=\>“privileges”} e[4;35;1mPrivilege Count (0.000000)e[0m e[0mSELECT COUNT(\*) FROM privileges e[0m e[4;36;1mPrivilege Load (0.000000)e[0m e[0;1mSELECT \* FROM privileges LIMIT 0, 10e[0m Rendering within layouts/privileges Rendering privileges/list e[4;35;1mPrivilege Columns (0.020000)e[0m e[0mSHOW FIELDS FROM privilegese[0m e[4;36;1mSQL (0.000000)e[0m e[0;1mMysql::Error: #23000Duplicate entry ‘1’ for key 1: INSERT INTO privileges (`created_on`, `delete`, `name`, `designation_id`, `section_id`, `updated_on`, `modify`, `id`, `create`, `description`, `department_id`, `view`) VALUES(‘2006-02-22 18:21:56’, ‘0’, ‘Navin’, 0, 0, ‘2006-02-22 18:25:18’, ‘0’, 1, ‘0’, ‘Samuel’, 0, ‘1’)e[0m ActionView::TemplateError (Mysql::Error: #23000Duplicate entry ‘1’ for key 1: INSERT INTO privileges (`created_on`, `delete`, `name`, `designation_id`, `section_id`, `updated_on`, `modify`, `id`, `create`, `description`, `department_id`, `view`) VALUES(‘2006-02-22 18:21:56’, ‘0’, ‘Navin’, 0, 0, ‘2006-02-22 18:25:18’, ‘0’, 1, ‘0’, ‘Samuel’, 0, ‘1’)) on line #13 of app/views/privileges/list.rhtml: 10: \<% for privilege in @privileges %\> 11: 12: \<% for column in Privilege.content\_columns %\> 13: \<%=h privilege.send(column.name) %\> 14: \<% end %\> 15: \<%= link\_to ‘Show’, :action =\> ‘show’, :id =\> privilege %\> 16: \<%= link\_to ‘Edit’, :action =\> ‘edit’, :id =\> privilege %\> ``` c:/Programs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in ``` `log' c:/Programs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/mysql_adapter.rb:180:in `execute’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/mysql\_adapter.rb:190:in `insert' c:/Programs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:1450:in `create\_without\_callbacks’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/callbacks.rb:261:in `create_without_timestamps' c:/Programs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/timestamp.rb:30:in `create’ #{RAILS\_ROOT}/app/views/privileges/list.rhtml:13:in `send' #{RAILS_ROOT}/app/views/privileges/list.rhtml:13 #{RAILS_ROOT}/app/views/privileges/list.rhtml:12:in `each’ #{RAILS\_ROOT}/app/views/privileges/list.rhtml:12 #{RAILS\_ROOT}/app/views/privileges/list.rhtml:10:in `each' #{RAILS_ROOT}/app/views/privileges/list.rhtml:10 c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/base.rb:268:in `send’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_view/base.rb:268:in `compile_and_render_template' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/base.rb:244:in `render\_template’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_view/base.rb:205:in `render_file' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:655:in `render\_file’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:595:in `render_with_no_layout' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/layout.rb:220:in `render\_without\_benchmark’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:53:in `render' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:53:in `measure’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:53:in `render' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:854:in `perform\_action\_without\_filters’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/filters.rb:332:in `perform_action_without_benchmark' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in `perform\_action\_without\_rescue’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:69:in `measure' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in `perform\_action\_without\_rescue’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/rescue.rb:82:in `perform_action' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in `send’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:369:in `process_without_session_management_support' c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/session_management.rb:116:in `process’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in `dispatch' c:/Programs/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:117:in `handle\_dispatch’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick\_server.rb:83:in `service' c:/Programs/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service’ c:/Programs/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' c:/Programs/ruby/lib/ruby/1.8/webrick/server.rb:155:in `start\_thread’ c:/Programs/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start' c:/Programs/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start\_thread’ c:/Programs/ruby/lib/ruby/1.8/webrick/server.rb:94:in `start' c:/Programs/ruby/lib/ruby/1.8/webrick/server.rb:89:in `each’ c:/Programs/ruby/lib/ruby/1.8/webrick/server.rb:89:in `start' c:/Programs/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start’ c:/Programs/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start' c:/Programs/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/webrick_server.rb:69:in `dispatch’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/commands/servers/webrick.rb:59 c:/Programs/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in `require__' c:/Programs/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require’ c:/Programs/ruby/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active\_support/dependencies.rb:214:in `require' c:/Programs/ruby/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/commands/server.rb:28 c:/Programs/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require\_\_’ c:/Programs/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in `require' c:/Programs/ruby/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies.rb:214:in `require’ script/server:3 # Rendering c:/Programs/ruby/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/templates/rescues/layout.rhtml (500 Internal Error) ---
**Author:** ![Navin\_Samuel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/7ea924/32.png) [@Navin\_Samuel](https://www.ruby-forum.com/u/Navin_Samuel)\ **Post date:** [February 23, 2006, 3:22pm UTC](https://www.ruby-forum.com/t/mysql-duplicate-key-error/54101/3 "2006-02-23T15:22:41Z")
Navin Samuel wrote: > Here is the log once again with the code in which the error was > triggered Your code is using “send” to call the read method for each content column. But one of your database fields is called “create”, which is creating a new record. Rather than calling “privilege.send(column.name)”, use “privilege[column.name]”. – We develop, watch us RoR, in numbers too big to ignore. ---
**Author:** ![Navin\_Samuel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/7ea924/32.png) [@Navin\_Samuel](https://www.ruby-forum.com/u/Navin_Samuel)\ **Post date:** [February 23, 2006, 3:46pm UTC](https://www.ruby-forum.com/t/mysql-duplicate-key-error/54101/4 "2006-02-23T15:46:47Z")
Navin Samuel wrote: > Here is the log once again with the code in which the error was > triggered If you can, I’d rename the fields ‘create’, ‘delete’ and ‘modify’ as they sound like method names. ‘create’ is the problem now (it _is_ a method), but the others may soon follow. perhaps ‘create\_flag’ or something ? Alan ---
**Author:** ![Navin\_Samuel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/7ea924/32.png) [@Navin\_Samuel](https://www.ruby-forum.com/u/Navin_Samuel)\ **Post date:** [February 23, 2006, 7:10pm UTC](https://www.ruby-forum.com/t/mysql-duplicate-key-error/54101/5 "2006-02-23T19:10:26Z")
Mark & Allan, Thanks a ton for your help. It worked. You guys are great!