Reply to thread

Message

SQLite is the database system of choice for Moving-Pictures and many other plugins such as MP-TVSeries, mainly based on the fact that MediaPortal used it as well (recently you can switch to more robust solutions such as MySQL).

What it means is that corruption on a database can occur without you sometimes even knowing it, which can lead to weird/random behaviour. Since filters/custom-categories do not dissapear for the majority of users, you are clearly dealing with gremlins, which then makes dbase corruption one of the many possible culprits.

It does not have to be it, it could be that you got some concurrency issue going on with another plugin, or stumbled on some combination of settings that cause a not-yet fixed bug to surface, sometimes it is really a needle in a haystack. For me the Sherlock Holmes way of debugging always makes things easy, and that is once you start excluding all other possabilities, then whatever you are left, how unlikely it is, has to be the cause.

You might have spend a lot of time creating custom categories, in which case deleting the database is going to be painfull, because you wll have to redo them all, but at the same time that gives you the ideal oppertunity to restructure it the way you really want, as after usage of a system that you slowly expand a fresh start usually leads to a better structure.

Before you go crazy and delete the existing database, why don't you just re-locate it to a safe location, and reconfigure MovPic with basic setting, perhaps set it to a path that only holds a few movies and another path with some 3D movies, then you create the 3D category/filter and see if it sticks. If that works then you know 100% sure already that something is wrong with the old database and you simply start over again, but this time configure it for your entire collection and redo all your categories/settings.

If it still dissapears, then what you did was create a very centric test case which if you run MediaPortal in debug verbosity log mode, should allow the developers of MovPic to locate that astranged bug.

Odds are redoing it fresh will fix it all, as it works fine for majority of users.

PS: You can also use an SQLite tool to run a PRAGMA integrity test on your database, it will reveal instantly if there is a technical detectable corruption in your database. If you search the forums you will find a post of me where I share a batch-script that does this fully automatic as part of an automatic backup/restore system (in the event of corruption). I can't remember if I posted it in MovPic, MP-TVSeries, or both, but I am sure you can find it.

<blockquote data-quote="RoChess" data-source="post: 1055248" data-attributes="member: 18896">SQLite is the database system of choice for Moving-Pictures and many other plugins such as MP-TVSeries, mainly based on the fact that MediaPortal used it as well (recently you can switch to more robust solutions such as MySQL).&nbsp;What it means is that corruption on a database can occur without you sometimes even knowing it, which can lead to weird/random behaviour. Since filters/custom-categories do not dissapear for the majority of users, you are clearly dealing with gremlins, which then makes dbase corruption one of the many possible culprits.&nbsp;It does not have to be it, it could be that you got some concurrency issue going on with another plugin, or stumbled on some combination of settings that cause a not-yet fixed bug to surface, sometimes it is really a needle in a haystack. For me the Sherlock Holmes way of debugging always makes things easy, and that is once you start excluding all other possabilities, then whatever you are left, how unlikely it is, has to be the cause.&nbsp;You might have spend a lot of time creating custom categories, in which case deleting the database is going to be painfull, because you wll have to redo them all, but at the same time that gives you the ideal oppertunity to restructure it the way you really want, as after usage of a system that you slowly expand a fresh start usually leads to a better structure.&nbsp;Before you go crazy and delete the existing database, why don't you just re-locate it to a safe location, and reconfigure MovPic with basic setting, perhaps set it to a path that only holds a few movies and another path with some 3D movies, then you create the 3D category/filter and see if it sticks. If that works then you know 100% sure already that something is wrong with the old database and you simply start over again, but this time configure it for your entire collection and redo all your categories/settings.&nbsp;If it still dissapears, then what you did was create a very centric test case which if you run MediaPortal in debug verbosity log mode, should allow the developers of MovPic to locate that astranged bug.&nbsp;Odds are redoing it fresh will fix it all, as it works fine for majority of users.&nbsp;PS: You can also use an SQLite tool to run a PRAGMA integrity test on your database, it will reveal instantly if there is a technical detectable corruption in your database. If you search the forums you will find a post of me where I share a batch-script that does this fully automatic as part of an automatic backup/restore system (in the event of corruption). I can't remember if I posted it in MovPic, MP-TVSeries, or both, but I am sure you can find it.</blockquote>

[QUOTE="RoChess, post: 1055248, member: 18896"] SQLite is the database system of choice for Moving-Pictures and many other plugins such as MP-TVSeries, mainly based on the fact that MediaPortal used it as well (recently you can switch to more robust solutions such as MySQL). What it means is that corruption on a database can occur without you sometimes even knowing it, which can lead to weird/random behaviour. Since filters/custom-categories do not dissapear for the majority of users, you are clearly dealing with gremlins, which then makes dbase corruption one of the many possible culprits. It does not have to be it, it could be that you got some concurrency issue going on with another plugin, or stumbled on some combination of settings that cause a not-yet fixed bug to surface, sometimes it is really a needle in a haystack. For me the Sherlock Holmes way of debugging always makes things easy, and that is once you start excluding all other possabilities, then whatever you are left, how unlikely it is, has to be the cause. You might have spend a lot of time creating custom categories, in which case deleting the database is going to be painfull, because you wll have to redo them all, but at the same time that gives you the ideal oppertunity to restructure it the way you really want, as after usage of a system that you slowly expand a fresh start usually leads to a better structure. Before you go crazy and delete the existing database, why don't you just re-locate it to a safe location, and reconfigure MovPic with basic setting, perhaps set it to a path that only holds a few movies and another path with some 3D movies, then you create the 3D category/filter and see if it sticks. If that works then you know 100% sure already that something is wrong with the old database and you simply start over again, but this time configure it for your entire collection and redo all your categories/settings. If it still dissapears, then what you did was create a very centric test case which if you run MediaPortal in debug verbosity log mode, should allow the developers of MovPic to locate that astranged bug. Odds are redoing it fresh will fix it all, as it works fine for majority of users. PS: You can also use an SQLite tool to run a PRAGMA integrity test on your database, it will reveal instantly if there is a technical detectable corruption in your database. If you search the forums you will find a post of me where I share a batch-script that does this fully automatic as part of an automatic backup/restore system (in the event of corruption). I can't remember if I posted it in MovPic, MP-TVSeries, or both, but I am sure you can find it. [/QUOTE]