title: SQLite IntegrityError: UNIQUE constraint failed:
body: <p>I am just getting an weird error:</p>
  
  <pre><code>IntegrityError: UNIQUE constraint failed: jumptimes.player_id, jumptimes.map_id, jumptimes.runID
  </code></pre>
  
  <p>My SQL QUERY:</p>
  
  <pre><code>t = (playerid, mapid, timeTaken, (time() if not dateOverwrite else dateOverwrite), runID, runLeaveZoneVelocity, EnterZoneVelocity, averageVelocity, time())
  log("PlayerID: %s | mapid: %s | timeTaken: %s | Date: %s | runID: %s | rlvz: %s | ezv: %s | avgvel: %s | firstFinish: %s" % t)
  execute("INSERT INTO jumptimes (player_id, map_id, duration, date, runID, LeaveZoneVelocity, enterZoneVelocity, averageVelocity, firstFinish) VALUES (?,?,?,?,?,?,?,?,?)", t)
  </code></pre>
  
  <p>Log output:</p>
  
  <pre><code>17:45:11 - PlayerID: 13 | mapid: 34 | timeTaken: 55.2569999695 | Date: 1426265111.18 | runID: 0 | rlvz: 315.484661963 | ezv: 1159.06484472 | avgvel: 1374.49441131 | firstFinish: 1426265111.18
  </code></pre>
  
  <p>My Database structure:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS jumptimes (
       id INTEGER PRIMARY KEY AUTO_INCREMENT,
       player_id INTEGER REFERENCES players ON DELETE CASCADE,
       map_id INTEGER REFERENCES maps ON DELETE CASCADE,
       duration REAL,
       `date` REAL,
       runID INTEGER,
       leaveZoneVelocity INTEGER DEFAULT 0,
       enterZoneVelocity INTEGER DEFAULT 0,
       averageVelocity INTEGER DEFAULT 0,
       server INTEGER DEFAULT 0,
       firstFinish REAL,
       completions INTEGER DEFAULT 1,
       UNIQUE (player_id, map_id, runID)
  )
  </code></pre>
  
  <p>As the topic says, im always getting <code>SQLite IntegrityError: UNIQUE constraint failed:</code></p>