实际上我有两个与Android错误相关的问题.我发布了一个之前运行正常的应用程序的更新,并在我的Nexus One,G1和模拟器上使用当前版本.但是,自上次更新以来,我通过Android市场控制台获得了大量错误日志,我无法重现错误.该应用程序非常简单,只有两个活动,因此手动测试应该很容易.然而,在发布之前我经常会发现错误.
所以第一个问题是,有没有办法更加精确地测试？
我的第二个问题是关于当前的错误. sqlite数据库似乎无法找到表格存在问题.我想数据库不能首先创建,因此错误.这是堆栈跟踪：
BTW.有三个用户使用Desire HD进行投诉.有没有知道的错误？
java.lang.RuntimeException: Unable to resume activity {XXX/XXX}: android.database.sqlite.sqliteException: no such table: main_ger:,while compiling: SELECT _id,code,area FROM main_ger
at android.app.ActivityThread.performResumeActivity(ActivityThread.java:3394)
at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:3415)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2859)
at android.app.ActivityThread.access$2300(ActivityThread.java:136)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2179)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:143)
at android.app.ActivityThread.main(ActivityThread.java:5068)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:521)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:858)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
at dalvik.system.NativeStart.main(Native Method)
Caused by: android.database.sqlite.sqliteException: no such table: main_ger:,area FROM main_ger
at android.database.sqlite.sqliteCompiledsql.native_compile(Native Method)
at android.database.sqlite.sqliteCompiledsql.compile(sqliteCompiledsql.java:91)
at android.database.sqlite.sqliteCompiledsql.<init>(sqliteCompiledsql.java:64)
at android.database.sqlite.sqliteProgram.<init>(sqliteProgram.java:80)
at android.database.sqlite.sqliteQuery.<init>(sqliteQuery.java:46)
at android.database.sqlite.sqliteDirectCursorDriver.query(sqliteDirectCursorDriver.java:53)
at android.database.sqlite.sqliteDatabase.rawQueryWithFactory(sqliteDatabase.java:1417)
at android.database.sqlite.sqliteDatabase.queryWithFactory(sqliteDatabase.java:1301)
at android.database.sqlite.sqliteDatabase.query(sqliteDatabase.java:1256)
at android.database.sqlite.sqliteDatabase.query(sqliteDatabase.java:1336)
at XX.XXX.DataBaseHelper.fetchAll(DataBaseHelper.java:190)
at XX.XXX.fillData(mainactivity.java:240)
at XX.XXX.onResume(mainactivity.java:522)
at android.app.Instrumentation.callActivityOnResume(Instrumentation.java:1238)
at android.app.Activity.performResume(Activity.java:3904)
at android.app.ActivityThread.performResumeActivity(ActivityThread.java:3384)
... 12 more
解决方法
似乎还有更多人遇到此问题：
Database handling stoped working on Android 2.2.1 (Desire HD 1.72.405.3)
http://forum.xda-developers.com/showthread.php?t=895942
