android.database.sqlite.SQLiteException

conflicting ON CONFLICT clauses specified (code 1): , while compiling: CREATE TABLE IF NOT EXISTS `SIPUser`(`extension` INTEGER,`id` INTEGER UNIQUE ON CONFLICT FAIL,`status` TEXT,`username` TEXT, UNIQUE(`id`) ON CONFLICT REPLACE, PRIMARY KEY(`id`));


Solutions on the web1766

Solution icon of github
via GitHub by radvansky-tomas
, 7 months ago
conflicting ON CONFLICT clauses specified (code 1): , while compiling: CREATE TABLE IF NOT EXISTS `SIPUser`(`extension` INTEGER,`id` INTEGER UNIQUE ON CONFLICT FAIL,`status` TEXT,`username` TEXT, UNIQUE(`id`) ON CONFLICT REPLACE, PRIMARY KEY(`id`));

Solution icon of stackoverflow
via Stack Overflow by varun
, 1 year ago
table passwordtb already exists (code 1): , while compiling: CREATE TABLE passwordtb (_id INTEGER PRIMARY KEY, host TEXT, remember INTEGER, signon_realm TEXT, origin_signon_realm TEXT, origin_spec TEXT, action_spec TEXT, username_name TEXT, username_value TEXT, password_name TEXT, password_value TEXT, UNIQUE (host) ON CONFLICT REPLACE);

Solution icon of stackoverflow
table httpauth already exists (code 1): , while compiling: CREATE TABLE httpauth (_id INTEGER PRIMARY KEY, host TEXT, realm TEXT, username TEXT, password TEXT, UNIQUE (host, realm) ON CONFLICT REPLACE);

Solution icon of github
via GitHub by Hyperiunn
, 1 year ago
near "UPDATE": syntax error (code 1): , while compiling: CREATE TABLE actions (id TEXT PRIMARY KEY ON CONFLICT UPDATE,user TEXT NOT NULL,parent TEXT,read TEXT,votedirection INTEGER,saved INTEGER,hidden INTEGER,dirty INTEGER,lastupdate INTEGER)

Solution icon of github
table A already exists (code 1): , while compiling: CREATE TABLE A ( ID INTEGER PRIMARY KEY AUTOINCREMENT , C TEXT, D TEXT, E TEXT, F TEXT, G TEXT UNIQUE, H INTEGER NULL, I INTEGER )

Solution icon of stackoverflow
via Stack Overflow by Unknown author, 1 year ago
AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY (code 1): , while compiling: CREATE TABLE teacher_table (_id id INTEGER PRIMARY KEY AUTOINCREMENT, teacher_name TEXT,father_name TEXT,mother_name TEXT,);

Solution icon of stackoverflow
near "all": syntax error (code 1): , while compiling: create table IF NOT EXISTS Patterns (ID INTEGER primary key,name TEXT,current INTEGER,all INTEGER)

Solution icon of stackoverflow
near "KEY_PHONE": syntax error (code 1): , while compiling: CREATE TABLE BLOCKED_PHONES_TABLE ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL DEFAULT 1, KEY_PHONE TEXT, KEY_IS_BLOCKED BIT, UNIQUE KEY_PHONE )

Solution icon of web
via rishitnandan.com by Unknown author, 1 year ago
near "KEY_PHONE": syntax error (code 1): , while compiling: CREATE TABLE BLOCKED_PHONES_TABLE ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL DEFAULT 1, KEY_PHONE TEXT, KEY_IS_BLOCKED BIT, UNIQUE KEY_PHONE )

Solution icon of stackoverflow
near "TABLE": syntax error (code 1): , while compiling: CREATE TABLE TABLE DATA (ID integer primary key autoincrement,USERNAME text,PASSWORD text,WEIGHT integer,HEIGHT integer,AGE integer,GENDER integer,CALORIES integer,CALORIES_BURNED integer,CALORIES_PEDO integer );

Stack trace

  • android.database.sqlite.SQLiteException: conflicting ON CONFLICT clauses specified (code 1): , while compiling: CREATE TABLE IF NOT EXISTS `SIPUser`(`extension` INTEGER,`id` INTEGER UNIQUE ON CONFLICT FAIL,`status` TEXT,`username` TEXT, UNIQUE(`id`) ON CONFLICT REPLACE, PRIMARY KEY(`id`)); at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58) at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31) at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674) at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605) at com.raizlabs.android.dbflow.structure.database.AndroidDatabase.execSQL(AndroidDatabase.java:27) at com.raizlabs.android.dbflow.structure.database.BaseDatabaseHelper.executeCreations(BaseDatabaseHelper.java:79) at com.raizlabs.android.dbflow.structure.database.BaseDatabaseHelper.onCreate(BaseDatabaseHelper.java:46) at com.raizlabs.android.dbflow.structure.database.DatabaseHelperDelegate.onCreate(DatabaseHelperDelegate.java:70) at com.raizlabs.android.dbflow.structure.database.FlowSQLiteOpenHelper.onCreate(FlowSQLiteOpenHelper.java:71) at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251) at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163) at com.raizlabs.android.dbflow.structure.database.FlowSQLiteOpenHelper.getDatabase(FlowSQLiteOpenHelper.java:54) at com.raizlabs.android.dbflow.config.DatabaseDefinition.getWritableDatabase(DatabaseDefinition.java:207) at com.raizlabs.android.dbflow.sql.queriable.ModelLoader.load(ModelLoader.java:35) at com.raizlabs.android.dbflow.sql.language.BaseModelQueriable.queryList(BaseModelQueriable.java:57) at com.raizlabs.android.dbflow.sql.language.Where.queryList(Where.java:237) at com.sixpmplc.iworkforce.model.Message.getSortedMessages(Message.java:205) at com.sixpmplc.iworkforce.activities.MainActivity.LoadSqlData(MainActivity.java:383) at com.sixpmplc.iworkforce.fragments.MainFragment$2.onResponse(MainFragment.java:145) at com.sixpmplc.iworkforce.helpers.Core$4.onResponse(Core.java:321) at retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:68) at android.os.Handler.handleCallback(Handler.java:739) at android.os.Handler.dispatchMessage(Handler.java:95) at android.os.Looper.loop(Looper.java:135) at android.app.ActivityThread.main(ActivityThread.java:5254) at java.lang.reflect.Method.invoke(Native Method) at java.lang.reflect.Method.invoke(Method.java:372) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

33 times, 1 year ago
3 times, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
3 times, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 1 year ago
112 more bugmates