Problème requête select

**Pepito39** · 12/06/2013, 09h48

Bonjour,

Voilà, je souhaite faire une requête select d'un seul, mais quand je l'éxécute, il me dise qu'il y a la colonne, mais la row est manquante..

J'ai essayé plusieurs trucs mais je n'arrive pas à faire fonctionner cette requête...

J'aimerais retourner un nombre
Et voici où j'en suis :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
public int getNbpizzawithNom(String nom) {
		Cursor c = bdd.query(TABLE_CLIENT, new String[] { COL_PIZZAENCOURS },
				COL_NOM + " LIKE \"" + nom + "\"", null, null, null, null);
		c.moveToFirst();
		int nombre = c.getInt(NUM_COL_PIZZAENCOURS);
		return nombre;
	}

Comment puis je remédier à ce problème?
Merci d'avance

**Simon MARQUIS** · 12/06/2013, 09h51

Comme toujours, peux-tu copier le contenu du logcat correspondant à cette erreur ?

**Pepito39** · 12/06/2013, 10h14

L'erreur semble différente en fait.. Hier, ça m'affichait pas la même erreur..
Enfin, ça reste une erreur quand même..

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
06-12 09:41:23.446: E/SQLiteDatabase(575): close() was never explicitly called on database '/data/data/com.example.cartedefidelite/databases/client.db' 
06-12 09:41:23.446: E/SQLiteDatabase(575): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1943)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1007)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:986)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1051)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:770)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at com.example.cartedefidelite.clientBDD.open(clientBDD.java:43)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at com.example.cartedefidelite.DetailClientActivity.onCreate(DetailClientActivity.java:16)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.app.Activity.performCreate(Activity.java:4465)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1919)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1980)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.app.ActivityThread.access$600(ActivityThread.java:122)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1146)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.os.Handler.dispatchMessage(Handler.java:99)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.os.Looper.loop(Looper.java:137)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at android.app.ActivityThread.main(ActivityThread.java:4340)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at java.lang.reflect.Method.invokeNative(Native Method)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at java.lang.reflect.Method.invoke(Method.java:511)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
06-12 09:41:23.446: E/SQLiteDatabase(575): 	at dalvik.system.NativeStart.main(Native Method)
06-12 09:41:23.455: E/System(575): Uncaught exception thrown by finalizer
06-12 09:41:23.907: E/System(575): java.lang.IllegalStateException: Don't have database lock!
06-12 09:41:23.907: E/System(575): 	at android.database.sqlite.SQLiteDatabase.verifyLockOwner(SQLiteDatabase.java:2090)
06-12 09:41:23.907: E/System(575): 	at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2182)
06-12 09:41:23.907: E/System(575): 	at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2178)
06-12 09:41:23.907: E/System(575): 	at android.util.LruCache.trimToSize(LruCache.java:197)
06-12 09:41:23.907: E/System(575): 	at android.util.LruCache.evictAll(LruCache.java:285)
06-12 09:41:23.907: E/System(575): 	at android.database.sqlite.SQLiteDatabase.deallocCachedSqlStatements(SQLiteDatabase.java:2143)
06-12 09:41:23.907: E/System(575): 	at android.database.sqlite.SQLiteDatabase.closeClosable(SQLiteDatabase.java:1126)
06-12 09:41:23.907: E/System(575): 	at android.database.sqlite.SQLiteDatabase.finalize(SQLiteDatabase.java:1914)
06-12 09:41:23.907: E/System(575): 	at java.lang.Daemons$FinalizerDaemon.doFinalize(Daemons.java:182)
06-12 09:41:23.907: E/System(575): 	at java.lang.Daemons$FinalizerDaemon.run(Daemons.java:168)
06-12 09:41:23.907: E/System(575): 	at java.lang.Thread.run(Thread.java:856)
06-12 09:41:24.017: E/SQLiteDatabase(575): close() was never explicitly called on database '/data/data/com.example.cartedefidelite/databases/client.db' 
06-12 09:41:24.017: E/SQLiteDatabase(575): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1943)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1007)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:986)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1051)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:770)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at com.example.cartedefidelite.clientBDD.open(clientBDD.java:43)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at com.example.cartedefidelite.DetailClientActivity.onCreate(DetailClientActivity.java:16)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.app.Activity.performCreate(Activity.java:4465)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1919)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1980)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.app.ActivityThread.access$600(ActivityThread.java:122)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1146)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.os.Handler.dispatchMessage(Handler.java:99)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.os.Looper.loop(Looper.java:137)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at android.app.ActivityThread.main(ActivityThread.java:4340)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at java.lang.reflect.Method.invokeNative(Native Method)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at java.lang.reflect.Method.invoke(Method.java:511)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
06-12 09:41:24.017: E/SQLiteDatabase(575): 	at dalvik.system.NativeStart.main(Native Method)
06-12 09:41:24.017: E/System(575): Uncaught exception thrown by finalizer
06-12 09:41:24.044: E/System(575): java.lang.IllegalStateException: Don't have database lock!
06-12 09:41:24.044: E/System(575): 	at android.database.sqlite.SQLiteDatabase.verifyLockOwner(SQLiteDatabase.java:2090)
06-12 09:41:24.044: E/System(575): 	at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2182)
06-12 09:41:24.044: E/System(575): 	at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2178)
06-12 09:41:24.044: E/System(575): 	at android.util.LruCache.trimToSize(LruCache.java:197)
06-12 09:41:24.044: E/System(575): 	at android.util.LruCache.evictAll(LruCache.java:285)
06-12 09:41:24.044: E/System(575): 	at android.database.sqlite.SQLiteDatabase.deallocCachedSqlStatements(SQLiteDatabase.java:2143)
06-12 09:41:24.044: E/System(575): 	at android.database.sqlite.SQLiteDatabase.closeClosable(SQLiteDatabase.java:1126)
06-12 09:41:24.044: E/System(575): 	at android.database.sqlite.SQLiteDatabase.finalize(SQLiteDatabase.java:1914)
06-12 09:41:24.044: E/System(575): 	at java.lang.Daemons$FinalizerDaemon.doFinalize(Daemons.java:182)
06-12 09:41:24.044: E/System(575): 	at java.lang.Daemons$FinalizerDaemon.run(Daemons.java:168)
06-12 09:41:24.044: E/System(575): 	at java.lang.Thread.run(Thread.java:856)
06-12 09:49:31.344: E/CursorWindow(575): Failed to read row 0, column 8 from a CursorWindow which has 1 rows, 1 columns.
06-12 09:49:31.364: E/AndroidRuntime(575): FATAL EXCEPTION: main
06-12 09:49:31.364: E/AndroidRuntime(575): java.lang.IllegalStateException: Couldn't read row 0, col 8 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it.
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.database.CursorWindow.nativeGetLong(Native Method)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.database.CursorWindow.getLong(CursorWindow.java:526)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.database.CursorWindow.getInt(CursorWindow.java:596)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.database.AbstractWindowedCursor.getInt(AbstractWindowedCursor.java:69)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at com.example.cartedefidelite.clientBDD.getNbpizzawithNom(clientBDD.java:102)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at com.example.cartedefidelite.FideliteActivity$1.onClick(FideliteActivity.java:39)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.view.View.performClick(View.java:3480)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.view.View$PerformClick.run(View.java:13983)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.os.Handler.handleCallback(Handler.java:605)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.os.Handler.dispatchMessage(Handler.java:92)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.os.Looper.loop(Looper.java:137)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at android.app.ActivityThread.main(ActivityThread.java:4340)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at java.lang.reflect.Method.invokeNative(Native Method)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at java.lang.reflect.Method.invoke(Method.java:511)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
06-12 09:49:31.364: E/AndroidRuntime(575): 	at dalvik.system.NativeStart.main(Native Method)
06-12 10:11:10.775: E/SQLiteDatabase(638): close() was never explicitly called on database '/data/data/com.example.cartedefidelite/databases/client.db' 
06-12 10:11:10.775: E/SQLiteDatabase(638): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1943)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1007)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:986)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1051)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:770)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at com.example.cartedefidelite.clientBDD.open(clientBDD.java:43)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at com.example.cartedefidelite.DetailClientActivity.onCreate(DetailClientActivity.java:16)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.app.Activity.performCreate(Activity.java:4465)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1919)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1980)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.app.ActivityThread.access$600(ActivityThread.java:122)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1146)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.os.Handler.dispatchMessage(Handler.java:99)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.os.Looper.loop(Looper.java:137)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at android.app.ActivityThread.main(ActivityThread.java:4340)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at java.lang.reflect.Method.invokeNative(Native Method)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at java.lang.reflect.Method.invoke(Method.java:511)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
06-12 10:11:10.775: E/SQLiteDatabase(638): 	at dalvik.system.NativeStart.main(Native Method)
06-12 10:11:10.775: E/System(638): Uncaught exception thrown by finalizer
06-12 10:11:10.995: E/System(638): java.lang.IllegalStateException: Don't have database lock!
06-12 10:11:10.995: E/System(638): 	at android.database.sqlite.SQLiteDatabase.verifyLockOwner(SQLiteDatabase.java:2090)
06-12 10:11:10.995: E/System(638): 	at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2182)
06-12 10:11:10.995: E/System(638): 	at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2178)
06-12 10:11:10.995: E/System(638): 	at android.util.LruCache.trimToSize(LruCache.java:197)
06-12 10:11:10.995: E/System(638): 	at android.util.LruCache.evictAll(LruCache.java:285)
06-12 10:11:10.995: E/System(638): 	at android.database.sqlite.SQLiteDatabase.deallocCachedSqlStatements(SQLiteDatabase.java:2143)
06-12 10:11:10.995: E/System(638): 	at android.database.sqlite.SQLiteDatabase.closeClosable(SQLiteDatabase.java:1126)
06-12 10:11:10.995: E/System(638): 	at android.database.sqlite.SQLiteDatabase.finalize(SQLiteDatabase.java:1914)
06-12 10:11:10.995: E/System(638): 	at java.lang.Daemons$FinalizerDaemon.doFinalize(Daemons.java:182)
06-12 10:11:10.995: E/System(638): 	at java.lang.Daemons$FinalizerDaemon.run(Daemons.java:168)
06-12 10:11:10.995: E/System(638): 	at java.lang.Thread.run(Thread.java:856)
06-12 10:11:13.766: E/CursorWindow(638): Failed to read row 0, column 8 from a CursorWindow which has 1 rows, 1 columns.
06-12 10:11:13.827: E/AndroidRuntime(638): FATAL EXCEPTION: main
06-12 10:11:13.827: E/AndroidRuntime(638): java.lang.IllegalStateException: Couldn't read row 0, col 8 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it.
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.database.CursorWindow.nativeGetLong(Native Method)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.database.CursorWindow.getLong(CursorWindow.java:526)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.database.CursorWindow.getInt(CursorWindow.java:596)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.database.AbstractWindowedCursor.getInt(AbstractWindowedCursor.java:69)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at com.example.cartedefidelite.clientBDD.getNbpizzawithNom(clientBDD.java:102)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at com.example.cartedefidelite.FideliteActivity$1.onClick(FideliteActivity.java:39)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.view.View.performClick(View.java:3480)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.view.View$PerformClick.run(View.java:13983)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.os.Handler.handleCallback(Handler.java:605)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.os.Handler.dispatchMessage(Handler.java:92)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.os.Looper.loop(Looper.java:137)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at android.app.ActivityThread.main(ActivityThread.java:4340)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at java.lang.reflect.Method.invokeNative(Native Method)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at java.lang.reflect.Method.invoke(Method.java:511)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
06-12 10:11:13.827: E/AndroidRuntime(638): 	at dalvik.system.NativeStart.main(Native Method)

Mais je doute sur ma requête, est elle correcte? Renvoie t'elle bien le nombre de pizza demandé?

**Pepito39** · 12/06/2013, 10h16

J'ai déjà rajouté le cliBDD.close() qui supprime une erreur déjà

**Simon MARQUIS** · 12/06/2013, 10h20

Quelle est donc l'erreur que tu obtiens maintenant ?
As-tu essayer de désinstaller l'application et de la réinstaller ?

**Pepito39** · 12/06/2013, 10h25

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
06-12 10:23:28.504: E/CursorWindow(698): Failed to read row 0, column 8 from a CursorWindow which has 1 rows, 1 columns.
06-12 10:23:28.626: E/AndroidRuntime(698): FATAL EXCEPTION: main
06-12 10:23:28.626: E/AndroidRuntime(698): java.lang.IllegalStateException: Couldn't read row 0, col 8 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it.
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.database.CursorWindow.nativeGetLong(Native Method)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.database.CursorWindow.getLong(CursorWindow.java:526)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.database.CursorWindow.getInt(CursorWindow.java:596)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.database.AbstractWindowedCursor.getInt(AbstractWindowedCursor.java:69)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at com.example.cartedefidelite.clientBDD.getNbpizzawithNom(clientBDD.java:102)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at com.example.cartedefidelite.FideliteActivity$1.onClick(FideliteActivity.java:39)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.view.View.performClick(View.java:3480)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.view.View$PerformClick.run(View.java:13983)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.os.Handler.handleCallback(Handler.java:605)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.os.Handler.dispatchMessage(Handler.java:92)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.os.Looper.loop(Looper.java:137)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at android.app.ActivityThread.main(ActivityThread.java:4340)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at java.lang.reflect.Method.invokeNative(Native Method)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at java.lang.reflect.Method.invoke(Method.java:511)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
06-12 10:23:28.626: E/AndroidRuntime(698): 	at dalvik.system.NativeStart.main(Native Method)

J'ai cette erreur désormais..
Oui, j'ai essayé de la désinstaller et de la réinstaller, seulement, j'essaye des choses pour faire marcher cette requête, donc, je vais retenter de la réinstaller.