android - SQLiteException: no such table: USER (Sqlite code 1): , while compile: SELECT * FROM USER WHERE id=? 限制 1
问题描述
我正在处理其他人的代码,但我对 android sql 数据库不是很熟悉在我的另一个系统上它运行良好,但是当我用这个系统克隆和构建它时突然崩溃并显示这个异常
java.lang.RuntimeException: Unable to create application net.theinnotech.mahmoole.Utilities.AppController: android.database.sqlite.SQLiteException: no such table: USER (Sqlite code 1): , while compiling: SELECT * FROM USER WHERE id=? LIMIT 1, (OS error - 2:No such file or directory)
at android.app.ActivityThread.handleBindApplication(ActivityThread.java:5685)
at android.app.ActivityThread.-wrap2(ActivityThread.java)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1637)
at android.os.Handler.dispatchMessage(Handler.java:105)
at android.os.Looper.loop(Looper.java:156)
at android.app.ActivityThread.main(ActivityThread.java:6531)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:941)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:831)
Caused by: android.database.sqlite.SQLiteException: no such table: USER (Sqlite code 1): , while compiling: SELECT * FROM USER WHERE id=? LIMIT 1, (OS error - 2:No such file or directory)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:910)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:521)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:603)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:63)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1397)
at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1239)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1110)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1316)
at com.orm.SugarRecord.find(SugarRecord.java:201)
at com.orm.SugarRecord.findById(SugarRecord.java:135)
at net.theinnotech.mahmoole.Utilities.AppController.onCreate(AppController.java:67)
at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1028)
at android.app.ActivityThread.handleBindApplication(ActivityThread.java:5666)
at android.app.ActivityThread.-wrap2(ActivityThread.java)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1637)
at android.os.Handler.dispatchMessage(Handler.java:105)
at android.os.Looper.loop(Looper.java:156)
at android.app.ActivityThread.main(ActivityThread.java:6531)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:941)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:831)
我四处搜索并SugarContext.init(this);
在清单文件中添加并增加了我的版本数据库,但没有任何改变
解决方案
推荐阅读
- python - 编辑使用乘法生成的嵌套列表的值时出现错误
- flutter - Flutter - 在 ListView 顶部添加图层以滚动
- python - 如何使用表单数据在 Robot Framework/Python 中创建发布请求以上传文件和其他键值
- php - 通过来自移动设备的电子邮件验证用户时创建新会话
- sql - 如何在postgres中将唯一行从一个表插入到另一个表?
- flutter - Flutter 应用发布构建挂起调用 getApplicationDocumentsDirectory();
- python - 使用不区分大小写的 Pandas str.contains
- javascript - 任何 babel 插件可以删除不必要的分配?
- php - 缺少页面重定向器 Laravel 实现 Redirector
- microsoft-teams - 在 Microsoft Teams 的 Adaptive Card 中使用 Action.OpenUrl 触发电话(电话或 sip)