Simply download and install the sqlite cli program. Then find out where .slimserversql.db is located -- mine is in /usr/local/slimserver, and type:
sqlite .slimserversql.db Use ".help" for basic usage instructions. Al max.spicer wrote:
I'm in the process of tidying up my music's tags, having gone through the process of ripping it all. At some point in the future, I intend to go through the process of enjoying listening to my music. ;-) When I browse year's in slimserver, I get several lines for seemingly blank years, and others for years with non numeric characters in (see screenshot). Unfortunately, the slimserver web interface doesn't let me find out what albums have generated these entries, as there isn't a clickable link in many cases, and in others clicking the link gives a blank list on the next page. What I'd like to do, is have look at the database itself to see what tracks have the dodgy years. Could someone suggest an easy way of firing sql at the database? I have no problem with SQL, but no experience of SQLite. Thanks, Max PS My first thought was to do a grep of the source code for something like select *, but I thought I'd ask here first. :-) +-------------------------------------------------------------------+ |Filename: screenshot.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=146| +-------------------------------------------------------------------+
_______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
