App will "get stuck" while refreshing some series

[robinpaulson]

For example, it refreshes the first ten series in my list, then hangs (I left it for 1hr) on "American horror story". When I remove that from the list and refresh the shows again, it hangs on "ashes to ashes". Removing that, refreshing again makes it hang on "Babylon Berlin".

[red-coracle]

Is this on v0.16.0? I tried adding all three shows on a fresh install and it worked for me.

[robinpaulson]

Yes, latest version.

[robinpaulson]

After removing them, i readded and refreshed again. It hangs st the same point.

[red-coracle]

Are you able to upload a backup file and/or the ADB log output from when you refresh?

[robinpaulson]

FATAL EXCEPTION: main
Process: com.redcoracle.episodes, PID: 12220
java.lang.NullPointerException: Attempt to invoke virtual method 'java.lang.String android.content.Context.getPackageName()' on a null object reference
at android.preference.PreferenceManager.getDefaultSharedPreferencesName(PreferenceManager.java:537)
at android.preference.PreferenceManager.getDefaultSharedPreferences(PreferenceManager.java:526)
at r3.e.(SourceFile:8)
at com.redcoracle.episodes.b$c.(Unknown Source:11)
at com.redcoracle.episodes.b.y(SourceFile:12)
at androidx.fragment.app.i0.a(SourceFile:42)
at androidx.fragment.app.i0.k(SourceFile:140)
at androidx.fragment.app.b0.M(SourceFile:58)
at androidx.fragment.app.b0.t(SourceFile:34)
at androidx.fragment.app.t.onStart(SourceFile:34)
at f.h.onStart(Unknown Source:0)
at android.app.Instrumentation.callActivityOnStart(Instrumentation.java:1391)
at android.app.Activity.performStart(Activity.java:7165)
at android.app.ActivityThread.handleStartActivity(ActivityThread.java:2975)
at android.app.servertransaction.TransactionExecutor.performLifecycleSequence(TransactionExecutor.java:180)
at android.app.servertransaction.TransactionExecutor.cycleToPath(TransactionExecutor.java:165)
at android.app.servertransaction.TransactionExecutor.executeLifecycleState(TransactionExecutor.java:142)
at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:70)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1816)
at android.os.Handler.dispatchMessage(Handler.java:106)
at android.os.Looper.loop(Looper.java:193)
at android.app.ActivityThread.main(ActivityThread.java:6718)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:491)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:858)

[robinpaulson]

I get this, or similar, a lot.
android.database.sqlite.SQLiteException: near "WHERE": syntax error (code 1 SQLITE_ERROR): , while compiling: UPDATE episodes SET tmdb_id=?,overview=?,episode_number=?,show_id=?,name=?,season_number=?, WHERE _id=12995

[robinpaulson]

Also this: (1) near "WHERE": syntax error

[robinpaulson]

I get the last two errors for each of the problematic shows listed above. I assume "_id" matches those in the tmdb db. 12995, 12581, 11215. I can't tell what about those shows is causing the failure though

[robinpaulson]

I wonder if it's related to the first_aired column being empty? The hangs appear to happen when that's the case. Possibly

[robinpaulson]

These shows also cause the app to hang:
American horror story
Ashes to ashes
Babylon Berlin
Black books
Black mirror
Bottom
Coupling
Fargo
Father ted
Friday night dinner
I'm Alan partridge
Jonathan creek
Life on mars
Lost
Malcolm in the middle
Mr robot
Oliver Stone's untold history of the united states
Party down
Person of interest
Roots
Seinfeld

They all appear to have "specials" with no info or date.

[robinpaulson]

I can provide more info, let me know which

[red-coracle]

Sorry, my time has been in short supply as of late. I think there are potentially two issues here: the first stacktrace is about a null context when getting the shared preferences, while the SQL error is because there's a comma directly before the WHERE keyword. I've not been able to reproduce either issue though. I've tried adding those shows to a new 0.16.0 install as well as upgrading from 0.15.1 and not had any errors.

[robinpaulson]

I could provide my db export, but don't think I can upload it here?

[robinpaulson]

I can email it, if you provide an address?

[red-coracle]

I'll add you to a temporary private repo where you can upload it.