The time has come (actually, long passed) where you _need_ to validate ALL data being inserted into your database. Numeric columns need to be properly formatted and within range, and string columns must not exceed the defined length of the column. Is it any wonder there are so many daily reports of library scans crashing when you have such a loose approach?
Bitrate calculations seem to be a particularly difficult thing for Squeezebox Server lately. The worst part about crashing the scanner over it is that the bitrate is nothing more than informational in its use. Crashing over some bogus computed value is inexcusable. If you can't come up with a value that is valid then just throw it out, enter '0.0' and move on. -- JJZolx Jim ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=70093 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
