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 web

Solution icon of github
via GitHub by radvansky-tomas
, 9 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, 9 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
114 more bugmates