Erreur logcat Android (Permission denied)

Version imprimable

Je viens de créer une base de données sqlite via Android mais j'ai un problème. J'ai un message lors de lancement de ADV !

Citation:

Process android.process.media is not responding
Force close / wait

Puis lorsque je clique sur l'application :

Citation:

The application tes_forms (process com.tuto) has stopped unexpectedly.please try again.

Voici le logcat :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
03-01 16:35:49.951: ERROR/vold(26): Error opening switch name path '/sys/class/switch/test' (No such file or directory)
03-01 16:35:49.951: ERROR/vold(26): Error bootstrapping switch '/sys/class/switch/test' (No such file or directory)
03-01 16:35:49.991: ERROR/vold(26): Error opening switch name path '/sys/class/switch/test2' (No such file or directory)
03-01 16:35:49.991: ERROR/vold(26): Error bootstrapping switch '/sys/class/switch/test2' (No such file or directory)
03-01 16:35:59.301: ERROR/BatteryService(51): usbOnlinePath not found
03-01 16:35:59.301: ERROR/BatteryService(51): batteryVoltagePath not found
03-01 16:35:59.301: ERROR/BatteryService(51): batteryTemperaturePath not found
03-01 16:35:59.311: ERROR/SurfaceFlinger(51): Couldn't open /sys/power/wait_for_fb_sleep or /sys/power/wait_for_fb_wake
03-01 16:36:02.922: ERROR/EventHub(51): could not get driver version for /dev/input/mouse0, Not a typewriter
03-01 16:36:02.922: ERROR/EventHub(51): could not get driver version for /dev/input/mice, Not a typewriter
03-01 16:36:03.541: ERROR/System(51): Failure starting core service
03-01 16:36:03.541: ERROR/System(51): java.lang.SecurityException
03-01 16:36:03.541: ERROR/System(51): at android.os.BinderProxy.transact(Native Method)
03-01 16:36:03.541: ERROR/System(51): at android.os.ServiceManagerProxy.addService(ServiceManagerNative.java:146)
03-01 16:36:03.541: ERROR/System(51): at android.os.ServiceManager.addService(ServiceManager.java:72)
03-01 16:36:03.541: ERROR/System(51): at com.android.server.ServerThread.run(SystemServer.java:176)
03-01 16:36:03.551: ERROR/AndroidRuntime(51): Crash logging skipped, no checkin service
03-01 16:36:08.534: ERROR/ActivityThread(92): Failed to find provider info for android.server.checkin
03-01 16:36:09.634: ERROR/ActivityThread(92): Failed to find provider info for android.server.checkin
03-01 16:36:09.705: ERROR/ActivityThread(92): Failed to find provider info for android.server.checkin
03-01 16:36:11.674: ERROR/vold(26): Cannot start volume '/sdcard' (volume is not bound)
03-01 16:36:11.755: ERROR/MediaPlayerService(30): Couldn't open fd for content://settings/system/notification_sound
03-01 16:36:11.764: ERROR/MediaPlayer(51): Unable to to create media player
03-01 16:36:15.765: ERROR/ActivityThread(51): Failed to find provider info for com.google.settings
03-01 16:36:15.765: ERROR/ActivityThread(51): Failed to find provider info for com.google.settings
03-01 16:36:29.624: ERROR/AndroidRuntime(210): ERROR: thread attach failed
03-01 16:36:31.344: ERROR/AndroidRuntime(221): ERROR: thread attach failed
03-01 16:36:31.974: ERROR/AndroidRuntime(234): Uncaught handler: thread main exiting due to uncaught exception
03-01 16:36:31.994: ERROR/AndroidRuntime(234): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.formation.sql/com.formation.sql.Main}: android.database.sqlite.SQLiteException: no such column: desciption: , while compiling: SELECT _id, codebarre, titre, desciption FROM produits
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2496)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2512)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.app.ActivityThread.access$2200(ActivityThread.java:119)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.os.Handler.dispatchMessage(Handler.java:99)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.os.Looper.loop(Looper.java:123)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.app.ActivityThread.main(ActivityThread.java:4363)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at java.lang.reflect.Method.invokeNative(Native Method)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at java.lang.reflect.Method.invoke(Method.java:521)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at dalvik.system.NativeStart.main(Native Method)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): Caused by: android.database.sqlite.SQLiteException: no such column: desciption: , while compiling: SELECT _id, codebarre, titre, desciption FROM produits
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteProgram.native_compile(Native Method)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:110)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:49)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1220)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1107)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1065)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1142)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at com.formation.sql.DBAdapter.recupererLaListeDesProduits(DBAdapter.java:91)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at com.formation.sql.Main.DataBind(Main.java:37)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at com.formation.sql.Main.onCreate(Main.java:26)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2459)
03-01 16:36:31.994: ERROR/AndroidRuntime(234): ... 11 more
03-01 16:36:32.014: ERROR/dalvikvm(234): Unable to open stack trace file '/data/anr/traces.txt': Permission denied

J'espère que vous pourrez m'éclairer

Merci infiniment a tous

01/03/2012, 20h19
adiGuba

Salut,

Dans ces cas là il faut remonter le stacktrace de l'exception.
Et en particulier les "Caused by" qui peuvent contenir plus d'info sur la cause originale du problème...

Dans ton log on peut lire ceci :

Citation:

03-01 16:36:31.994: ERROR/AndroidRuntime(234): Caused by: android.database.sqlite.SQLiteException: no such column: desciption: , while compiling: SELECT _id, codebarre, titre, desciption FROM produits

desciption ? Ou description ?

a++
02/03/2012, 19h16
neo777

après tout, c'est quoi le stacktrace !?
le domaine de développement androïde est nouveau pour moi.
merci de me donner plus de détail.
:?

Le stacktrace ? ca n'a rien a voir avec android et ca remonte aux premiers processeurs capables de faire des appels de sous-routines (donc ayant une "pile" et étant capable d'empiler / dépiler des parametres / variables de cette pile).

Tous les langages informatiques avec appels de sous-routine / fonction on une forme de "stack-trace", c'est à dire, la liste de tous les points d'appels de sous-routine jusqu'à l'execution présente...

En Java, quand une exception est créée (new ....() ) la stack trace courant lui est associée...
Quand l'exception est affichée (par le LogCat par exemple), la stack-trace est affichée aussi, en l'occurence:
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 java.lang.RuntimeException: Unable to start activity ComponentInfo{com.formation.sql/com.formation.sql.Main}: android.database.sqlite.SQLiteException: no such column: desciption: , while compiling: SELECT _id, codebarre, titre, desciption FROM produits at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2496) at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2512) at android.app.ActivityThread.access$2200(ActivityThread.java:119) at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863) at android.os.Handler.dispatchMessage(Handler.java:99) at android.os.Looper.loop(Looper.java:123) at android.app.ActivityThread.main(ActivityThread.java:4363) 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 at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618) at dalvik.system.NativeStart.main(Native Method)
Là ou ca se complique c'est qu'en Java, une exception peut être lancée du à une autre exception, c'est le "caused by" qu'on voit apparaitre ensuite... En général ce sont *ces* exceptions qui sont interessantes, dans ton cas:
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Caused by: android.database.sqlite.SQLiteException: no such column: desciption: , while compiling: SELECT _id, codebarre, titre, desciption FROM produits at android.database.sqlite.SQLiteProgram.native_compile(Native Method) at android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:110) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59) at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:49) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1220) at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1107) at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1065) at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1142) at com.formation.sql.DBAdapter.recupererLaListeDesProduits(DBAdapter.java:91) at com.formation.sql.Main.DataBind(Main.java:37) at com.formation.sql.Main.onCreate(Main.java:26) at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047) at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2459) ... 11 more
Les ".... 11 more" sont en fait la stacktrace déjà affichée précédemment.. peu d'interet.
Par contre, on voit bien ton code:
com.formation.sql.DBAdapter.recupererLaListeDesProduits(DBAdapter.java:91)
qui appelle "query" qui plante... avec:
"no such column: desciption: , while compiling: SELECT _id, codebarre, titre, desciption FROM produits"