Flutter DatabaseException(UNIQUE constraint failed)

Question

I`m trying to insert some data into sqflite table but there is an error while executing insert query

await db.execute(
      'CREATE TABLE $catrgoryTable($category_id INTEGER PRIMARY KEY UNIQUE  , $colDeviceTypeId INTEGER, '
                '$room_id INTEGER)');
        print('category created!');

and here is the Error

SqfliteDatabaseException (DatabaseException(UNIQUE constraint failed: category_Table.category_id (code 1555)) sql 'INSERT INTO category_Table (category_id, device_type_id, room_id) VALUES (?, ?, ?)' args [1, 1, 1]})

Thanks for any help:)

Moujabr · Accepted Answer · 2019-05-08 18:38:49Z

7

The table category_Table has a unique constraint field on it, the error shows that you tried to enter a value for category_id that it already exists, which violates primary key's uniqueness constraint for this field. Only one row can exist with a given ID value. So If you're trying to insert a row, be sure that your category_id have a unique value, or if you don't care about generating ids by yourself, you can add AUTOINCREMENT setting to your category_id column definition. This way it will be filled automatically and each row will have its own unique value.

answered May 8, 2019 at 18:38

Moujabr

5571 gold badge5 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

muhammed kamal · Accepted Answer · 2021-04-12 21:21:38Z

4

static Future<void> insert(String table, Map<String, dynamic> data) async {
  final db = await DBHelper.database();
  db.insert(table, data, conflictAlgorithm: sql.ConflictAlgorithm.replace);
}

here is my code is thought if I use conflict algorithm replace it would replace that unique value ?

answered Apr 12, 2021 at 21:21

muhammed kamal

612 bronze badges

Comments

Syscall · Accepted Answer · 2022-01-23 16:36:54Z

4

In the insert function of database. Add

conflictAlgorithm: ConflictAlgorithm.replace.

it worked for me

edited Jan 23, 2022 at 16:36

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

answered Jan 23, 2022 at 16:23

Flutter Expert

411 bronze badge

Collectives™ on Stack Overflow

Flutter DatabaseException(UNIQUE constraint failed)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related