title: Duplicate entry '2147483647' for key 'PRIMARY'
body: <p>Based on what I've read here and on the web, you get this error if you try to store an integer >  <a href="http://dev.mysql.com/doc/refman/5.0/en/integer-types.html" rel="nofollow">INT's maximum signed value; 2147483647</a>. As you can see below, I used <code>bigint(20)</code> for <code>user_id</code>. So, I don't know why I'm getting this error.</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `users` (
    `user_id` bigint(20) unsigned NOT NULL,
    `screen_name` varchar(20) NOT NULL,
    `name` varchar(20) DEFAULT NULL,
    `profile_image_url` varchar(200) DEFAULT NULL,
    `created_at` datetime NOT NULL,
    `followers_count` int(10) unsigned DEFAULT NULL,
    `friends_count` int(10) unsigned DEFAULT NULL,
    `statuses_count` int(10) unsigned DEFAULT NULL,
    `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`user_id`),
    KEY `user_name` (`name`),
    KEY `last_update` (`last_update`),
    KEY `screen_name` (`screen_name`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>The php script that handles the insertion:</p>
  
  <pre><code>/* Prepare an insert statement */
  $query = "INSERT INTO users (user_id, screen_name, name, profile_image_url, created_at, followers_count, friends_count, statuses_count) VALUES (?,?,?,?,?,?,?,?)";
  $stmt = $mysqli-&gt;prepare($query);
  $stmt-&gt;bind_param("issssiii", $user_id, $screen_name, $name, $profile_image_url, $created_at, $followers_count, $friends_count, $statuses_count);
  /* Execute the statement */
  $stmt-&gt;execute()
  </code></pre>
  
  <p>FYI: the purpose of this script &amp; table is to store some of Twitter's users data</p>