SatoriGFX;351980 Wrote:
> So, am I doing it the right way, by selecting the subheadings under
> slimserver individually and running the scripts individually?
I don't need to do that. I just connect to the slimserver schema and
run the two updates.
SatoriGFX;351980 Wrote:
> I just tried it again and it did not work. I must be missing something.
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.
--
cliveb
Transporter -> ATC SCM100A
------------------------------------------------------------------------
cliveb's Profile: http://forums.slimdevices.com/member.php?userid=348
View this thread: http://forums.slimdevices.com/showthread.php?t=54004
_______________________________________________
ripping mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/ripping
