android.database.sqlite.SQLiteException: no such table: address (code 1): , while compiling: REPLACE INTO address(id,city,isDefault,locationInfo,mobile,name)VALUES(?,?,?,?,?,?) 06-16 18:08:11.194 20224-21214/? W/System.err: at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) 06-16 18:08:11.194 20224-21214/? W/System.err: at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:898)

GitHub | LiuTaw | 6 months ago
  1. 0

    我在魅族m2 note上面发现一个很严重的问题

    GitHub | 6 months ago | LiuTaw
    android.database.sqlite.SQLiteException: no such table: address (code 1): , while compiling: REPLACE INTO address(id,city,isDefault,locationInfo,mobile,name)VALUES(?,?,?,?,?,?) 06-16 18:08:11.194 20224-21214/? W/System.err: at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) 06-16 18:08:11.194 20224-21214/? W/System.err: at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:898)
  2. 0

    SQLite Database (why do this?)

    Stack Overflow | 6 years ago | Dugs
    android.database.sqlite.SQLiteException: table mytable10 has no column named latitude: , while compiling: insert into mytable10(name,latitude,longitude,address,contectno) values(?,?,?,?,?)
  3. 0

    Missing field in table while connecting to db in android

    Stack Overflow | 5 years ago | Praveenbabu
    android.database.sqlite.SQLiteException: table registration has no column named email: , while compiling: insert into registration(name,email,password)values(?,?,?)</strong>
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Adding column to existing Database

    GitHub | 11 months ago | mustansarsaeed
    android.database.sqlite.SQLiteException: table TempFormData has no column named TEMP_COMMENTS (code 1): , while compiling: INSERT INTO `TempFormData` (`TEMP_FORMDATA`, `TEMP_INCHARGENAME`, `TEMP_INCHARGEPHONENUMBER`, `TEMP_FACILITYTYPE`, `TEMP_FACILITYNAME`, `TEMP_DISTRICTNAME`, `TEMP_TEHSILNAME`, `TEMP_TEHSILID`, `TEMP_COMMENTS`, `TEMP_FACILITY_TYPE_CODE`, `TEMP_FACILITYID`, `TEMP_DISTRICTID`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  6. 0

    GPXParserTest throws SQLiteException in DataStore.getGeocodeForTitle

    GitHub | 8 months ago | pstorch
    android.database.sqlite.SQLiteException: no such column: title (code 1): , while compiling: SELECT geocode FROM cg_caches WHERE title = ?

  1. jk 6 times, last 7 months ago
  2. Macapon 2 times, last 9 months ago
2 unregistered visitors
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

    no such table: address (code 1): , while compiling: REPLACE INTO address(id,city,isDefault,locationInfo,mobile,name)VALUES(?,?,?,?,?,?) 06-16 18:08:11.194 20224-21214/? W/System.err: at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) 06-16 18:08:11.194 20224-21214/? W/System.err: at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:898)

    at android.database.sqlite.SQLiteConnection.prepare()
  2. Android Platform
    SQLiteDatabase.compileStatement
    1. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:509)
    2. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    3. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    4. android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
    5. android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1024)
    5 frames
  3. com.litesuits.orm
    SingleSQLiteImpl.save
    1. com.litesuits.orm.db.assit.SQLStatement.execInsertWithMapping(SQLStatement.java:102)
    2. com.litesuits.orm.db.assit.SQLStatement.execInsert(SQLStatement.java:93)
    3. com.litesuits.orm.db.impl.SingleSQLiteImpl.save(SingleSQLiteImpl.java:58)
    3 frames
  4. me.liutaw.data
    UserRepostitoryImpl$3.call
    1. me.liutaw.data.repository.UserRepostitoryImpl$3.call(UserRepostitoryImpl.java:105)
    2. me.liutaw.data.repository.UserRepostitoryImpl$3.call(UserRepostitoryImpl.java:93)
    2 frames
  5. rxjava
    ExecutorScheduler$ExecutorSchedulerWorker.run
    1. rx.Observable.unsafeSubscribe(Observable.java:8098)
    2. rx.internal.operators.OperatorSubscribeOn$1$1.call(OperatorSubscribeOn.java:62)
    3. rx.internal.schedulers.ScheduledAction.run(ScheduledAction.java:55)
    4. rx.schedulers.ExecutorScheduler$ExecutorSchedulerWorker.run(ExecutorScheduler.java:98)
    4 frames
  6. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)
    3. java.lang.Thread.run(Thread.java:818)
    3 frames