Försökte lägga till It's Always Sunny in Philadelphia men fick FC.
Antar att du glömt escapa '-tecknet i din sql-insert.
Kod:
06-05 01:57:47.511: WARN/SQLiteDirectCursorDriver(2679): Found SQL string that ends in ; -- select nameId from serie where nameId = 'Its_Always_Sunny_In_Philadelphia';
06-05 01:57:47.511: ERROR/Database(2679): Failure 1 (near "s": syntax error) on 0x149bb8 when preparing 'insert into serie (name, nameId) values('It's Always Sunny in Philadelphia', 'Its_Always_Sunny_In_Philadelphia');'.
06-05 01:57:47.511: DEBUG/AndroidRuntime(2679): Shutting down VM
06-05 01:57:47.511: WARN/dalvikvm(2679): threadid=3: thread exiting with uncaught exception (group=0x4001b390)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): Uncaught handler: thread main exiting due to uncaught exception
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): android.database.sqlite.SQLiteException: near "s": syntax error: insert into serie (name, nameId) values('It's Always Sunny in Philadelphia', 'Its_Always_Sunny_In_Philadelphia');
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1700)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at se.northdivision.android.tvjunkie.utils.DataBaseHelper.addSerie(DataBaseHelper.java:192)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at se.northdivision.android.tvjunkie.activity.SearchSerieActivity$3.onItemClick(SearchSerieActivity.java:92)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.widget.AdapterView.performItemClick(AdapterView.java:284)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.widget.ListView.performItemClick(ListView.java:3285)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.widget.AbsListView$PerformClick.run(AbsListView.java:1640)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.os.Handler.handleCallback(Handler.java:587)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.os.Handler.dispatchMessage(Handler.java:92)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.os.Looper.loop(Looper.java:123)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at android.app.ActivityThread.main(ActivityThread.java:4595)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at java.lang.reflect.Method.invokeNative(Native Method)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at java.lang.reflect.Method.invoke(Method.java:521)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
06-05 01:57:47.521: ERROR/AndroidRuntime(2679): at dalvik.system.NativeStart.main(Native Method)