java.lang.RuntimeException: Unable to create application org.sufficientlysecure.keychain.KeychainApplication: android.database.sqlite.SQLiteException: duplicate column name: name (code 1): , while compiling: ALTER TABLE user_packets ADD COLUMN name TEXT

GitHub | dschuermann | 7 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

    SQLiteException

    GitHub | 7 months ago | dschuermann
    java.lang.RuntimeException: Unable to create application org.sufficientlysecure.keychain.KeychainApplication: android.database.sqlite.SQLiteException: duplicate column name: name (code 1): , while compiling: ALTER TABLE user_packets ADD COLUMN name TEXT
  2. 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,);
  3. 0

    Android sqlLite create table

    Stack Overflow | 4 years ago | Victor Kiricheiko
    java.lang.RuntimeException: Unable to create application com.activeandroid.app.Application: android.database.sqlite.SQLiteException: duplicate column name: id: CREATE TABLE IF NOT EXISTS Quote (Id INTEGER PRIMARY KEY AUTOINCREMENT, author TEXT, id INTEGER, text TEXT);
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    dalvik.system.NativeStart

    Stack Overflow | 5 years ago | Anouar Elmekki
    android.database.sqlite.SQLiteException: duplicate column name: email: CREATE TABLE login(id INTEGER PRIMARY KEY,name TEXT,email TEXT UNIQUE,uid TEXT,created_at TEXT,email TEXT UNIQUE)
  6. 0

    android.database.sqlite.SQLiteException: duplicate column name: bookmark (code 1): , while compiling: ALTER TABLE draft_messages ADD COLUMN bookmark VARCHAR

    GitHub | 4 years ago | 2fast2fourier
    android.database.sqlite.SQLiteException: duplicate column name: bookmark (code 1): , while compiling: ALTER TABLE draft_messages ADD COLUMN bookmark VARCHAR
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

    duplicate column name: name (code 1): , while compiling: ALTER TABLE user_packets ADD COLUMN name TEXT

    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:1093)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:670)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
    6. android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
    7. android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1798)
    8. android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1729)
    8 frames
  3. org.sufficientlysecure.keychain
    KeychainDatabase.onUpgrade
    1. org.sufficientlysecure.keychain.provider.KeychainDatabase.onUpgrade(KeychainDatabase.java:311)
    1 frame
  4. Android Platform
    SQLiteOpenHelper.getReadableDatabase
    1. android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:256)
    2. android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
    2 frames
  5. org.sufficientlysecure.keychain
    KeychainApplication.onCreate
    1. org.sufficientlysecure.keychain.KeychainApplication.onCreate(KeychainApplication.java:125)
    1 frame
  6. Android Platform
    ActivityThread.main
    1. android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1020)
    2. android.app.ActivityThread.handleBindApplication(ActivityThread.java:5228)
    3. android.app.ActivityThread.access$1600(ActivityThread.java:181)
    4. android.app.ActivityThread$H.handleMessage(ActivityThread.java:1535)
    5. android.os.Handler.dispatchMessage(Handler.java:102)
    6. android.os.Looper.loop(Looper.java:145)
    7. android.app.ActivityThread.main(ActivityThread.java:6117)
    7 frames
  7. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invoke(Native Method)
    2. java.lang.reflect.Method.invoke(Method.java:372)
    2 frames
  8. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1399)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1194)
    2 frames