2011-02-08, 21:08
Hello
I have a system with a central NAS where all movies etc. are mantained and where several instances of XBMC (3 XBMC-Linux, 1 XBMC-Windows 7 and a couple old xbox) go to get its media. I maintain also a MySQL database where the databases for all but the Xbox are stored, and there are several databases because each instance of XBMC uses several profiles (shared between machines, like "children movies&series", "movies&series in spanish", "subtitled movies&series in original languaje", "documentaries, recipes, etc"). One and only one instance (the windows 7 one) is used to import new data to the database manually several times a week selecting each one of the profiles. All the non-xbox xbmc with all profiles share a "thumbnails" directory in the server.
It mostly works and it is proof of how far has gone and what a high level of sophistication xbmc has reached.
The problem is, sometimes the database gets corrupted somehow, I do not really know why, and some entries get duplicated (or triplicated or more), or I need to move files around or a few other problems that forces to re-create part or everything in the database for a profile. It is not such a big deal because I maintain nfo, thumb and fanart files in place along the media files themselves (created manually, or with Media Companion or with XBMC "export library to separate files" function)
The problem is, the information that is in the database but not on the nfo files is lost, for example, date of incorporation to the database (that allows that useful feature, "recent movies", "recent episodes"), watched status, actual codec and resolution...
It would be great to keep that information up to date, that way almost any problem that I have now could be solved with maybe moving directories, library clean and library update, without affecting anything else.
I suppose that, if I have this problem, devs which are constantly tinkering with the database code would find it now and then too.
The thing would work as, if an option is set, when importing media a nfo/tbn/fanart will be created if it doesn't already exist (as it is created with "export to separate files") in place, and among other things it will add the date of scraping also (so if it is imported later, it will not appear in "recent movies"). Then, every time the files is used and some info updated in the XBMC database, it will go to the nfo file also, and so if the database needs to be recreated, no info will be lost. if a disk becomes full and files are moved to another location, a database cleaning and a database update later, everything would be in perfect order without interfering with the users whatsoever.
Maybe it is too much work or it is too complicated, but if some dev find the idea interesting and could implement it, I think it would be great for many people.
I have a system with a central NAS where all movies etc. are mantained and where several instances of XBMC (3 XBMC-Linux, 1 XBMC-Windows 7 and a couple old xbox) go to get its media. I maintain also a MySQL database where the databases for all but the Xbox are stored, and there are several databases because each instance of XBMC uses several profiles (shared between machines, like "children movies&series", "movies&series in spanish", "subtitled movies&series in original languaje", "documentaries, recipes, etc"). One and only one instance (the windows 7 one) is used to import new data to the database manually several times a week selecting each one of the profiles. All the non-xbox xbmc with all profiles share a "thumbnails" directory in the server.
It mostly works and it is proof of how far has gone and what a high level of sophistication xbmc has reached.
The problem is, sometimes the database gets corrupted somehow, I do not really know why, and some entries get duplicated (or triplicated or more), or I need to move files around or a few other problems that forces to re-create part or everything in the database for a profile. It is not such a big deal because I maintain nfo, thumb and fanart files in place along the media files themselves (created manually, or with Media Companion or with XBMC "export library to separate files" function)
The problem is, the information that is in the database but not on the nfo files is lost, for example, date of incorporation to the database (that allows that useful feature, "recent movies", "recent episodes"), watched status, actual codec and resolution...
It would be great to keep that information up to date, that way almost any problem that I have now could be solved with maybe moving directories, library clean and library update, without affecting anything else.
I suppose that, if I have this problem, devs which are constantly tinkering with the database code would find it now and then too.
The thing would work as, if an option is set, when importing media a nfo/tbn/fanart will be created if it doesn't already exist (as it is created with "export to separate files") in place, and among other things it will add the date of scraping also (so if it is imported later, it will not appear in "recent movies"). Then, every time the files is used and some info updated in the XBMC database, it will go to the nfo file also, and so if the database needs to be recreated, no info will be lost. if a disk becomes full and files are moved to another location, a database cleaning and a database update later, everything would be in perfect order without interfering with the users whatsoever.
Maybe it is too much work or it is too complicated, but if some dev find the idea interesting and could implement it, I think it would be great for many people.