Hi! I'm experiencing this issue on Android 2.2 and 2.3.3. Emulators/devices with 2.1 or 4.0.3 , 4.1 works fine. Is this a real deal breaker for FTS on these versions or is there any work-arounds known ?
Regards Rafael Em segunda-feira, 12 de julho de 2010 07h36min13s UTC-3, Yuku Sugianto escreveu: > > 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
