sqlite 数据插入失败_sqlite select 1查询成功,insert失败-优快云博客

本文链接：https://blog.youkuaiyun.com/duty_is_codeing/article/details/9453323

07-24 17:02:04.866: E/SQLiteDatabase(19334): Error inserting usn=d9703267-c905-483b-ac0a-fce6ac9679af ip=192.168.100.10
07-24 17:02:04.866: E/SQLiteDatabase(19334): android.database.sqlite.SQLiteException: table pairing has no column named usn: , while compiling: INSERT INTO pairing(usn,ip) VALUES (?,?)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:150)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:368)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:272)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:115)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1832)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1705)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at cn.com.ammfe.application.MySqlLiteHelper.insertdata(MySqlLiteHelper.java:47)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at cn.com.ammfe.MyService$MyHandler.cusorinsertorupdate(MyService.java:157)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at cn.com.ammfe.MyService$MyHandler.handleMessage(MyService.java:146)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.os.Handler.dispatchMessage(Handler.java:99)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.os.Looper.loop(Looper.java:156)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at android.app.ActivityThread.main(ActivityThread.java:4977)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at java.lang.reflect.Method.invokeNative(Native Method)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at java.lang.reflect.Method.invoke(Method.java:511)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
07-24 17:02:04.866: E/SQLiteDatabase(19334): at dalvik.system.NativeStart.main(Native Method)
07-24 17:02:04.876: E/MyService(19334): handlemessage
07-24 17:02:04.926: E/SQLiteDatabase(19334): Error inserting usn=d9703267-c905-483b-ac0a-fce6ac9679af ip=192.168.100.10
07-24 17:02:04.926: E/SQLiteDatabase(19334): android.database.sqlite.SQLiteException: table pairing has no column named usn: , while compiling: INSERT INTO pairing(usn,ip) VALUES (?,?)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:150)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:368)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:272)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:115)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1832)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1705)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at cn.com.ammfe.application.MySqlLiteHelper.insertdata(MySqlLiteHelper.java:47)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at cn.com.ammfe.MyService$MyHandler.cusorinsertorupdate(MyService.java:157)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at cn.com.ammfe.MyService$MyHandler.handleMessage(MyService.java:146)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.os.Handler.dispatchMessage(Handler.java:99)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.os.Looper.loop(Looper.java:156)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at android.app.ActivityThread.main(ActivityThread.java:4977)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at java.lang.reflect.Method.invokeNative(Native Method)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at java.lang.reflect.Method.invoke(Method.java:511)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
07-24 17:02:04.926: E/SQLiteDatabase(19334): at dalvik.system.NativeStart.main(Native Method)