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 | 9 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 | 9 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

    Single quote in SQL

    Stack Overflow | 2 months ago | shisushi
    android.database.sqlite.SQLiteException: near "hand": syntax error (code 1): , while compiling: INSERT INTO Result (Date, Name, Content) VALUES ('20170330_005134', 'Next, adjust the collar.', 'Next, adjust the collar. First, put your left'hand into miyatsukuchi and adjust the collar on the right side so It lies flat. Then, adjust the left collar so it lies flat. There should be a fist-sized space between the back of your neck and the collar.');
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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);
  6. 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)
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