Database migration nukes episode table about bazarr HOT 4 CLOSED

This issue seems resolved with the latest migration fix!

from bazarr.

In the last migration, we do some cleanup of an old left over column that have been recreated under a new name since then (alternativeTitle from table_shows) and that is causing issue while migrating to postgresql. This removal of column requires, under sqlite, to recreate the table under a temporary name, delete the old table and rename the new to the old name.

Unfortunately, the side effect of the old table deletion is that there's a ForeignKey constraint that cascade this deletion in table_episodes and, consequently, in table_history and table_blacklist.

I'll try to see if I can make alembic disable ForeignKey constraints before trying to migrate schema.

from bazarr.

Should be fixed in upcoming beta. Can you test and confirm please. I haven't been able to reproduce on my side with this fix. Thanks for reporting BTW!

from bazarr.

Thanks!

from bazarr.