Me too. And it happens on final build of 2.2, too :( On May 23, 7:40 pm, Luis Santos <[email protected]> wrote: > Hi all, > > I've updated my Nexus One to Android 2.2 Froyo to test one of my > Android apps, and i'm having some issues with FTS3 queries. > I use a virtual table created like this: > > CREATE VIRTUAL TABLE table_lyrics USING FTS3( _id INTEGER PRIMARY KEY > AUTOINCREMENT, artist TEXT NOT NULL, title TEXT NOT NULL, lyrics TEXT > NOT NULL, path TEXT) > > This is what the logcat says: > > I/Database( 1385): sqlite returned: error code = 1, msg = prepared > statement aborts at 7: [SELECT lyrics, path FROM table_lyrics WHERE > table_lyrics MATCH 'artist:"radiohead" title:"paranoidandroid"'] > W/dalvikvm( 1385): threadid=11: thread exiting with uncaught exception > (group=0x4001d7f0) > E/AndroidRuntime( 1385): FATAL EXCEPTION: Thread-16 > E/AndroidRuntime( 1385): android.database.sqlite.SQLiteException: SQL > logic error or missing database > E/AndroidRuntime( 1385): at > android.database.sqlite.SQLiteQuery.native_fill_window(Native Method) > E/AndroidRuntime( 1385): at > android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:70) > E/AndroidRuntime( 1385): at > android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:283) > E/AndroidRuntime( 1385): at > android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:264) > E/AndroidRuntime( 1385): at > android.database.AbstractCursor.moveToPosition(AbstractCursor.java: > 171) > E/AndroidRuntime( 1385): at > android.database.AbstractCursor.moveToFirst(AbstractCursor.java:248) > E/AndroidRuntime( 1385): at > com.spartancoders.golyrics.LyricsUtils.cacheSearch(LyricsUtils.java: > 482) > > I've tested other no-FTS SQL queries and all works fine, but every > MATCH query gives an error like the one above. All worked fine in > earlier versions of Android (1.5, 1.6, 2.0 and 2.1) > > Any help will be much appreciated :) > > Thanks in advance! > > Luis. > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group > athttp://groups.google.com/group/android-developers?hl=en
-- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
