title: MySQL: Duplicate Entry for Key 2
body: <p>I'm not sure what I'm doing to cause this error. The query:</p>
  
  <pre><code>INSERT INTO node (type, language, title) VALUES ('bout', 'en', 'the title 3')
  </code></pre>
  
  <p>The error:</p>
  
  <pre><code>#1062 - Duplicate entry '0' for key 2 
  </code></pre>
  
  <p>The table:</p>
  
  <pre><code>CREATE TABLE `node` (
    `nid` int(10) unsigned NOT NULL auto_increment,
    `vid` int(10) unsigned NOT NULL default '0',
    `type` varchar(32) NOT NULL default '',
    `language` varchar(12) NOT NULL default '',
    `title` varchar(255) NOT NULL default '',
    `uid` int(11) NOT NULL default '0',
    `status` int(11) NOT NULL default '1',
    `created` int(11) NOT NULL default '0',
    `changed` int(11) NOT NULL default '0',
    `comment` int(11) NOT NULL default '0',
    `promote` int(11) NOT NULL default '0',
    `moderate` int(11) NOT NULL default '0',
    `sticky` int(11) NOT NULL default '0',
    `tnid` int(10) unsigned NOT NULL default '0',
    `translate` int(11) NOT NULL default '0',
    PRIMARY KEY  (`nid`),
    UNIQUE KEY `vid` (`vid`),
    KEY `node_changed` (`changed`),
    KEY `node_created` (`created`),
    KEY `node_moderate` (`moderate`),
    KEY `node_promote_status` (`promote`,`status`),
    KEY `node_status_type` (`status`,`type`,`nid`),
    KEY `node_title_type` (`title`,`type`(4)),
    KEY `node_type` (`type`(4)),
    KEY `uid` (`uid`),
    KEY `tnid` (`tnid`),
    KEY `translate` (`translate`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2586 ;
  </code></pre>
  
  <p>What am I doing wrong? By not specifying a nid for the new entry, it will auto-increment, right?</p>