cliveb;352057 Wrote: > I don't need to do that. I just connect to the slimserver schema and run > the two updates. > > > The message at the bottom tells you how many records it has updated. If > there are no records to be updated (ie. you have no positive replaygain > settings that would cause clipping), then it updates no records and > does indeed say "Query returned no resultset". So since you've already > done the update once (and fixed all the replaygain values), nothing > happens the second time you run it. > > If you're interested in seeing the effects, you can check the values > before and after running the update. Execute this SQL statement: > > Code: -------------------- > > > select * from albums where replay_gain>0; > -------------------- > > > This will display all the records where the album replaygain is > positive. If you run it before and after doing the update, you can > take a look at the replay_gain and replay_peak values to see what's > changed. You can of course do the same for the tracks table to check > out the track gain values. Of course, since you've already fixed your > replay_gain values, in order to try this out you'd need to do another > wipe/scan. > > And finally: I've noticed something weird. If you run the update to > fix the gain values, and then run a select to check them: > > Code: -------------------- > > > select * from albums > where -20*log10(replay_peak) < replay_gain; > -------------------- > > > Then MYSQL Query Browser actually displays some records. It looks to > me as if there are some differences in comparison of floating point > values between select and update statements. The error appears to be > after several decimal points, so I believe it is not significant.
Thanks. So, I rescanned the library and then ran: update albums set replay_gain = -20*log10(replay_peak) where -20*log10(replay_peak) < replay_gain; and then: update tracks set replay_gain = -20*log10(replay_peak) where -20*log10(replay_peak) < replay_gain; There were quite a few files that were affacted. Then, I ran: select * from albums where replay_gain>0; and I still had some files listed, all files that were supposed to be fixed with the first 2 scripts. I'm not sure what I am doing wrong. -- SatoriGFX ------------------------------------------------------------------------ SatoriGFX's Profile: http://forums.slimdevices.com/member.php?userid=8852 View this thread: http://forums.slimdevices.com/showthread.php?t=54004 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/ripping
