egd;226502 Wrote: > I think I may have found a bug in the Database Query plugin. Selecting > Database Query / Custom Scan Statistics returns the following: > > Error: DBD::mysql::st execute failed: Incorrect key file for table > '/tmp/#sql_c15_0.MYI'; try to repair it at > /raid0/data/module/SLIMSERVER/slimserver/Plugins/DatabaseQuery/Plugin.pm > line 455. , Incorrect key file for table '/tmp/#sql_c15_0.MYI'; try to > repair it >
I think the problem is that some of your MySQL database tables are corrupt and needs to be repaired. The simple solution is to just delete your SlimServer database. If you do this, remember to make sure you have backups on data you like to keep. For example if you are using TrackStat you should to a backup of the TrackStat data before you delete the database. You can delete the database by deleting the Cache directory in the SlimServer installation dir. The more advanced solution is to startup SlimServer and connect with a MySQL client and try to repair the tables. Since you get this from the Custom Scan statistics query I'm guessing that at least some of the Custom Scan tables are corrupt. Which means that you should try to repair the tables: customscan_track_attributes; customscan_album_attributes; customscan_contributor_attributes; Personally I would just delete the SlimServer database after I had taken backup of all necessary data, because that is probably going to solve the problem a lot easier unless you have deeper knowledge in MySQL. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and RandomPlayList plugins' (http://wiki.erland.homeip.net/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=37633 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
