java.lang.RuntimeException: Unable to start activity ComponentInfo{net.network.alire.clientchat/net.network.alire.clientchat.MainActivity}: android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: CREATE TABLE Table_friend (_id INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(25), phoneNumber VARCHAR(25)

Stack Overflow | Alireza Amini | 5 months ago
  1. 0

    How to search in a SQLite database in android?

    Stack Overflow | 5 months ago | Alireza Amini
    java.lang.RuntimeException: Unable to start activity ComponentInfo{net.network.alire.clientchat/net.network.alire.clientchat.MainActivity}: android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: CREATE TABLE Table_friend (_id INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(25), phoneNumber VARCHAR(25)
  2. 0

    [APP][4.1+] BackPackTrack II, Record locatio… - Pg. 31 | Android Development and Hacking | XDA Forums

    xda-developers.com | 1 year ago
    android.database.sqlite.SQLiteException: duplicate column name: station_latitude (code 1): , whil e compiling: ALTER TABLE weather ADD COLUMN station_latitude REAL NULL
  3. 0

    Syntax Error in SQLite (Insert Statement)

    Stack Overflow | 9 months ago | Abhi
    android.database.sqlite.SQLiteException: near "Devices": syntax error (code 1): , while compiling: INSERT INTO book VALUES( Electronic Devices & Circuits,Jacob Millman & Christos C. Halkias,/storage/emulated/0/Android/data/dreamnyc.myapplication/files/MillmanHalkias-ElectronicDevicesCircuits/OEBPS/images/leaf-image0000.jpg );
  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

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

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

    near ")": syntax error (code 1): , while compiling: CREATE TABLE Table_friend (_id INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(25), phoneNumber VARCHAR(25)

    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:891)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:502)
    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. net.network.alire
    FriendStorage.onCreate
    1. net.network.alire.toolBox.FriendStorage.onCreate(FriendStorage.java:36)
    1 frame
  4. Android Platform
    SQLiteOpenHelper.getReadableDatabase
    1. android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
    2. android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
    2 frames
  5. net.network.alire
    MainActivity.onCreate
    1. net.network.alire.toolBox.FriendStorage.get(FriendStorage.java:56)
    2. net.network.alire.clientchat.MainActivity.onCreate(MainActivity.java:52)
    2 frames
  6. Android Platform
    ActivityThread.performLaunchActivity
    1. android.app.Activity.performCreate(Activity.java:5933)
    2. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1105)
    3. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2282)
    3 frames