Comments (2)
I tried exactly the same item and had the same problem !
Original comment by [email protected]
on 3 Jul 2012 at 9:57
from trolly.
There is a SQLiteException...
E/AndroidRuntime( 647): FATAL EXCEPTION: main
E/AndroidRuntime( 647): android.database.sqlite.SQLiteException: near
"olives": syntax error (code 1): , while compiling: SELECT _id, item, status
FROM shopping_list WHERE (item='Huile D'olives') ORDER BY item ASC
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnecti
on.java:882)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.
java:44)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1
314)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:400)
E/AndroidRuntime( 647): at
android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:294)
E/AndroidRuntime( 647): at
caldwell.ben.trolly.TrollyProvider.query(TrollyProvider.java:128)
E/AndroidRuntime( 647): at
android.content.ContentProvider.query(ContentProvider.java:652)
E/AndroidRuntime( 647): at
android.content.ContentProvider$Transport.query(ContentProvider.java:189)
E/AndroidRuntime( 647): at
android.content.ContentResolver.query(ContentResolver.java:370)
E/AndroidRuntime( 647): at
android.content.ContentResolver.query(ContentResolver.java:313)
E/AndroidRuntime( 647): at
caldwell.ben.trolly.Trolly$2.onClick(Trolly.java:265)
E/AndroidRuntime( 647): at android.view.View.performClick(View.java:4084)
E/AndroidRuntime( 647): at android.view.View$PerformClick.run(View.java:16966)
E/AndroidRuntime( 647): at android.os.Handler.handleCallback(Handler.java:615)
E/AndroidRuntime( 647): at android.os.Handler.dispatchMessage(Handler.java:92)
E/AndroidRuntime( 647): at android.os.Looper.loop(Looper.java:137)
E/AndroidRuntime( 647): at
android.app.ActivityThread.main(ActivityThread.java:4745)
E/AndroidRuntime( 647): at java.lang.reflect.Method.invokeNative(Native
Method)
E/AndroidRuntime( 647): at java.lang.reflect.Method.invoke(Method.java:511)
E/AndroidRuntime( 647): at
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
E/AndroidRuntime( 647): at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
E/AndroidRuntime( 647): at dalvik.system.NativeStart.main(Native Method)
W/ActivityManager( 150): Force finishing activity caldwell.ben.trolly/.Trolly
Original comment by [email protected]
on 8 Apr 2014 at 10:25
from trolly.
Related Issues (20)
- Preferences page HOT 1
- Add translation strings HOT 1
- Send shopping list via xml email attachment
- Merge to single layout HOT 1
- Shake to checkout
- Auto cleanup database HOT 1
- Trolly background image
- No mode switch in 1.3 HOT 5
- Support for landscape devices HOT 3
- Enhancement - Sorting
- Enhancement - Desktop widget
- Enhancement - Spelling
- Quantities of items
- Documentation
- Scale the view for large screens
- Attached Spanish translation
- UI mode unclear
- list items too large, space is wasted, please make it more compact
- French translation
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from trolly.