title: SQLState 23000 - Integrity constraint violation 1062 Duplicate Entry
body: <p>I am using a custom made API Request to my database to generate a new entry. </p>
  
  <p>My table structure looks like this:</p>
  
  <p><strong>Table Structure</strong></p>
  
  <pre><code>    Schema::create('incidents', function (Blueprint $table) {
          $table-&gt;increments('id');
          $table-&gt;string('incident_id')-&gt;unique();
          $table-&gt;integer('incident_type')-&gt;unsigned();
          $table-&gt;string('location');
          $table-&gt;string('street');
          $table-&gt;string('city');
          $table-&gt;double('latitude', 10, 6);
          $table-&gt;double('longitude', 10, 6);
          $table-&gt;date('date');
          $table-&gt;time('time');
          $table-&gt;smallInteger('incident_archived')-&gt;default(0);
          $table-&gt;timestamps();
      });
  </code></pre>
  
  <p>I set the Incident_Type to Unique as this is a requirement for my system. When I post a new entry to the system:</p>
  
  <pre><code>SERVER_IP/v1/incidents?incident_id=1&amp;city=Muenchen&amp;street=Fichtenstr.20&amp;latitude=100&amp;longitude=300
  </code></pre>
  
  <p>The first time works fine.</p>
  
  <p>The second time:</p>
  
  <pre><code>SERVER_IP/v1/incidents?incident_id=2&amp;city=Muenchen&amp;street=Fichtenstr.20&amp;latitude=100&amp;longitude=300
  </code></pre>
  
  <p>when I use different incident_id I get the error:</p>
  
  <pre><code>SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'incidents_incident_id_unique' (SQL: insert into `incidents` (`street`, `city`, `latitude`, `longitude`, `updated_at`, `created_at`) values (Fichtenstr.20, Muenchen, 100, 300, 2015-10-17 12:28:11, 2015-10-17 12:28:11))
  </code></pre>
  
  <p>Why is sending the request using the exact same entry even if I changed the data? And how can I fix this?</p>