Databases
StackOverflow2013
Postsdbo
POSQLITE3 Constraint Failed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQLITE3 Constraint Failed
    primarykey
    data
    text
    <p>My first question on stackoverflow and I really hope you guys can help me.</p> <p>I've been trying to get prepared statements running in objective C and so far so good. But now I keep getting "Constraint failed" on my database when trying to add a track.</p> <p>I've already deleted the db and created it again but the error remains. Also I have been looking into the duplicate key but I don't see me adding a duplicate anywhere. The locations table adds just fine and it's built kind of the same.</p> <p>My DB:</p> <pre><code>CREATE TABLE locations (LocationID INTEGER PRIMARY KEY AUTOINCREMENT, TimestampGPS DATE NOT NULL, Longitude REAL NOT NULL, Latitude REAL NOT NULL, Altitude REAL NOT NULL, Accuracy REAL NOT NULL, Bearing REAL NOT NULL, Speed REAL NOT NULL, TimestampDevice DATE NOT NULL); CREATE TABLE tracks (TrackID INTEGER PRIMARY KEY AUTOINCREMENT, Title VARCHAR, Description VARCHAR, StartTrackDeviceTime DATE NOT NULL, EndTrackDeviceTime DATE NOT NULL); CREATE TABLE track_locations (TrackID INTEGER NOT NULL REFERENCES tracks(TrackID), LocationID INTEGER NOT NULL REFERENCES locations(LocationID), PRIMARY KEY (TrackID, LocationID)); </code></pre> <p>My code to add a track. (I have got code to add a location which is similar and that one works just fine)</p> <pre class="lang-c prettyprint-override"><code>const char *sqlTrack = "INSERT INTO tracks(Title, Description, StartTrackDeviceTime, EndTrackDeviceTime) VALUES(?, ?, ?, ?)"; if(sqlite3_prepare_v2(db.dataBase, sqlTrack, -1, &amp;addTrackStatement, NULL) != SQLITE_OK) { NSLog(@"Error: %s", sqlite3_errmsg(db.dataBase)); } sqlite3_bind_text(addTrackStatement, 1, [track.title UTF8String], -1, SQLITE_TRANSIENT); sqlite3_bind_text(addTrackStatement, 2, [track.description UTF8String], -1, SQLITE_TRANSIENT); sqlite3_bind_text(addLocationStatement, 3, [[dateFormatter stringFromDate:track.startTime] UTF8String], -1, SQLITE_TRANSIENT); sqlite3_bind_text(addTrackStatement, 4, [[dateFormatter stringFromDate:track.endTime] UTF8String], -1, SQLITE_TRANSIENT); NSLog(@"Going to execute the statement"); if(SQLITE_DONE != sqlite3_step(addTrackStatement)) { NSLog(@"First step failed"); NSLog(@"Error: %s", sqlite3_errmsg(db.dataBase)); return NO; } else { long insertedTrack = sqlite3_last_insert_rowid(db.dataBase); NSLog(@"Inserted id on TRACK: %ld", insertedTrack); //HERE I ALSO ADD LOCATIONS sqlite3_clear_bindings(addTrackStatement); sqlite3_reset(addTrackStatement); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMPelletier
    1. USTikkes
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQLITE3 Constraint Failed
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSQLITE3 Constraint Failed
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat is contained within the track.title & description fields, and what is spat out by the NSDateFormatter lines you have? I'd log exactly what is being passed into the four sqlite3_bind_text functions before they are called and post that here. Perhaps something is not what you expect (e.g. "" or <null> instead of nil) or a blank date where you have a not null constraint.
      singulars
      1. POSQLITE3 Constraint Failed
      1. USDiziet
    2. COI've used NSLog on everything and all values are filled in just fine Title: MyTitle Descr: MyDescr Startdate: 2012-04-19 10:26:52GMT+02:00 Enddate: 2012-04-19 10:26:52GMT+02:00 The NSDateFormatter is built as following: dateFormatter = [[NSDateFormatter alloc] init]; [dateFormatter setDateFormat: @"yyyy-MM-dd HH:mm:ss zzz"]; Dateformatter is also used within locations where it works just fine
      singulars
      1. POSQLITE3 Constraint Failed
      1. USTikkes
    3. COCool. Hmm. Another user has a similar question here: http://stackoverflow.com/questions/9426843/iphone-sqliteconstraint-failed-error . The provided solution to that was to use an alternative insert syntax. Now I'm not recommending it as I don't like it, but does that make the problem go away?
      singulars
      1. POSQLITE3 Constraint Failed
      1. USDiziet
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload