- March 10, 2006
- 4,434
- 1,897
- Moderator
- #1
Do *NOT* proceed if you do not know how to make a backup of your DB3 database.
If you want to first see what will get deleted from the database then change the "DELETE FROM" part into "SELECT * FROM" and it will show you.
Use at your own risk.
That being said, I've done it multiple times myself to verify it is reproducable, and everything worked great.
#1 - Make backup of your "TVSeriesDatabase4.db3" (always a good thing anyway)
#2 - Download an SQLite tool, such as SQLite Browser.
#3 - Make sure no instance of MP-TVSeries is running (otherwise bad things will happen), then File -> Open Database -> locate and open the "TVSeriesDatabase4.db3" file.
#4 - Click on the "Execute SQL" tab, and copy and paste the following command:
and click on "Execute query" button.
#5. Repeat for:
#6 - Save the database and close SQLite Browser
#7 - Open MP-TVSeries config and re-run the import wizard, and everything should work again.
If you want to first see what will get deleted from the database then change the "DELETE FROM" part into "SELECT * FROM" and it will show you.
Use at your own risk.
That being said, I've done it multiple times myself to verify it is reproducable, and everything worked great.
#1 - Make backup of your "TVSeriesDatabase4.db3" (always a good thing anyway)
#2 - Download an SQLite tool, such as SQLite Browser.
#3 - Make sure no instance of MP-TVSeries is running (otherwise bad things will happen), then File -> Open Database -> locate and open the "TVSeriesDatabase4.db3" file.
#4 - Click on the "Execute SQL" tab, and copy and paste the following command:
DELETE FROM local_episodes WHERE (SELECT COUNT(*) FROM local_series WHERE local_series.id = local_episodes.seriesid) = 0;
and click on "Execute query" button.
#5. Repeat for:
DELETE FROM local_episodes WHERE originalcomposite = '';
DELETE FROM online_series WHERE ID < 1; --Do not use if you want to keep hidden series
DELETE FROM season WHERE SeasonIndex < 0; --Do not use if you want to keep hidden seasons
DELETE FROM online_series WHERE ID < 1; --Do not use if you want to keep hidden series
DELETE FROM season WHERE SeasonIndex < 0; --Do not use if you want to keep hidden seasons
#6 - Save the database and close SQLite Browser
#7 - Open MP-TVSeries config and re-run the import wizard, and everything should work again.