2013-05-03, 23:41
I have junk in my database and no amount of "cleaning" the Library will strip it out. I'm hoping for a solution short of deleting the existing database tables in MySQL and starting over. Here is a description of my environment.
* All media stored on \\Louise (a FreeNAS server). This replaced \\Buffy (a Buffalo Linkstation NAS).
* MySQL runs on a Windows XP Pro box. XBMC 12.1 is also installed there.
* I have two Windows 7 computers running XBMC 12.1.
* I have three Android tablets with XBMC 12.1 installed on them (but rarely used).
* I have an Intel NUC ("Next Unit of Computing") running XBMCbuntu 12.1.
* I have a NUC running XBMC 12.1 for Linux on a Ubuntu 12.04 LTS workstation.
My database if full of entries for media that begin smb://buffy/ but not one XBMC in my home has any \\Buffy sources still existing. Despite doing Clean Library routines at every station, the database remains full of ghost smb://buffy entries.
Is there a solution that is better than simply going into MySQL, deleting the current tables and letting the mothership rebuild it?
* All media stored on \\Louise (a FreeNAS server). This replaced \\Buffy (a Buffalo Linkstation NAS).
* MySQL runs on a Windows XP Pro box. XBMC 12.1 is also installed there.
* I have two Windows 7 computers running XBMC 12.1.
* I have three Android tablets with XBMC 12.1 installed on them (but rarely used).
* I have an Intel NUC ("Next Unit of Computing") running XBMCbuntu 12.1.
* I have a NUC running XBMC 12.1 for Linux on a Ubuntu 12.04 LTS workstation.
My database if full of entries for media that begin smb://buffy/ but not one XBMC in my home has any \\Buffy sources still existing. Despite doing Clean Library routines at every station, the database remains full of ghost smb://buffy entries.
Is there a solution that is better than simply going into MySQL, deleting the current tables and letting the mothership rebuild it?