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`));

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by radvansky-tomas
, 1 year 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`));
via GitHub by Hyperiunn
, 2 years 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)
via GitHub by DVassilev
, 2 years ago
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 )
via Stack Overflow by Mo_Code
, 2 years ago
near "delete": syntax error (code 1): , while compiling: CREATE TABLE data_base_stuff( _id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT,color TEXT,priority TEXT,created_date TEXT,delete INTEGER)
via Stack Overflow by Andrey Rankov
, 1 year ago
near "CategoryProduct_MM": syntax error (code 1): , while compiling: DELETE CategoryProduct_MM FROM CategoryProduct_MM INNER JOIN superup.CategoryProduct_MM t2 ON CategoryProduct_MM.PrdID = t2.PrdID AND CategoryProduct_MM.CategoryID=t2.CategoryID
via Stack Overflow by Walker
, 1 year ago
near "sa": syntax error (code 1): , while compiling: DELETE sa FROM stubout_account sa INNER JOIN stubout s ON sa.parentid = s.objid INNER JOIN area r ON s.areaid = r.objid WHERE r.assigneeid = ?
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.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674)
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 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)

Users with the same issue

12 times, 1 month ago
40 times, 3 months ago
347 times, 3 months ago
9 times, 4 months ago
Once, 6 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.