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

GitHub | radvansky-tomas | 4 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Updated Version - Crashing

    GitHub | 4 months ago | radvansky-tomas
    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`));
  2. 0

    Meizu devices on Android 5.x trigger: SQLiteException: table httpauth already exists

    Stack Overflow | 1 year ago | user1026605
    android.database.sqlite.SQLiteException: 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);
  3. 0

    Proguard - Table A Already Exists

    GitHub | 2 years ago | DVassilev
    android.database.sqlite.SQLiteException: 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 )
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [bug] Crash on Startup

    GitHub | 4 years ago | Hyperiunn
    android.database.sqlite.SQLiteException: 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)
  6. 0

    Database causes app to crash

    Stack Overflow | 2 years ago | Alexander Boman Skoug
    java.lang.RuntimeException: Unable to start activity ComponentInfo{se.welovecode.wdmmg/se.welovecode.wdmmg.MainActivity}: android.database.sqlite.SQLiteException: near "transaction": syntax error (code 1): , while compiling: CREATE TABLE mainTransactions (_id INTEGER PRIMARY KEY AUTOINCREMENT, transaction TEXT NOT NULL, item TEXT NOT NULL, sum TEXT,);
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Android Platform
    SQLiteDatabase.execSQL
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    6. android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
    7. android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674)
    8. android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605)
    8 frames
  3. com.raizlabs.android
    FlowSQLiteOpenHelper.onCreate
    1. com.raizlabs.android.dbflow.structure.database.AndroidDatabase.execSQL(AndroidDatabase.java:27)
    2. com.raizlabs.android.dbflow.structure.database.BaseDatabaseHelper.executeCreations(BaseDatabaseHelper.java:79)
    3. com.raizlabs.android.dbflow.structure.database.BaseDatabaseHelper.onCreate(BaseDatabaseHelper.java:46)
    4. com.raizlabs.android.dbflow.structure.database.DatabaseHelperDelegate.onCreate(DatabaseHelperDelegate.java:70)
    5. com.raizlabs.android.dbflow.structure.database.FlowSQLiteOpenHelper.onCreate(FlowSQLiteOpenHelper.java:71)
    5 frames
  4. Android Platform
    SQLiteOpenHelper.getWritableDatabase
    1. android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
    2. android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
    2 frames
  5. com.raizlabs.android
    Where.queryList
    1. com.raizlabs.android.dbflow.structure.database.FlowSQLiteOpenHelper.getDatabase(FlowSQLiteOpenHelper.java:54)
    2. com.raizlabs.android.dbflow.config.DatabaseDefinition.getWritableDatabase(DatabaseDefinition.java:207)
    3. com.raizlabs.android.dbflow.sql.queriable.ModelLoader.load(ModelLoader.java:35)
    4. com.raizlabs.android.dbflow.sql.language.BaseModelQueriable.queryList(BaseModelQueriable.java:57)
    5. com.raizlabs.android.dbflow.sql.language.Where.queryList(Where.java:237)
    5 frames
  6. com.sixpmplc.iworkforce
    Core$4.onResponse
    1. com.sixpmplc.iworkforce.model.Message.getSortedMessages(Message.java:205)
    2. com.sixpmplc.iworkforce.activities.MainActivity.LoadSqlData(MainActivity.java:383)
    3. com.sixpmplc.iworkforce.fragments.MainFragment$2.onResponse(MainFragment.java:145)
    4. com.sixpmplc.iworkforce.helpers.Core$4.onResponse(Core.java:321)
    4 frames
  7. retrofit2
    ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run
    1. retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:68)
    1 frame
  8. Android Platform
    ActivityThread.main
    1. android.os.Handler.handleCallback(Handler.java:739)
    2. android.os.Handler.dispatchMessage(Handler.java:95)
    3. android.os.Looper.loop(Looper.java:135)
    4. android.app.ActivityThread.main(ActivityThread.java:5254)
    4 frames
  9. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invoke(Native Method)
    2. java.lang.reflect.Method.invoke(Method.java:372)
    2 frames
  10. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
    2 frames