reinholdk wrote: > I agree that an album named 0 is pretty unusual, but I just got one > (https://en.wikipedia.org/wiki/0_(Low_Roar_album)).
Found that too after i your post ;) reinholdk wrote: > Not sure if I get your point about the queries. The Album tag in the > files is present and is neither null nor empty. So if the tag is read > correctly it should be no problem to create a record in the albums table > and set its title appropriately. But there's no record for this album in > the albums table and both the tracks and the contributor_album tables > are referring to the "No Album" record of the albums table. > > So maybe it's rather an issue of reading the tags and performing some > inappropriate sanitizing checks before passing them on to the stage that > adds the records to the database. "WHERE albumname is not null" -> whenever that statement is used every further statement is followed except: albumname is empty/unfilled or even 0. "WHERE Albumname <> '' "its the same - except it must be "not empty" - 0 is <> ''. Lets wait for Michael, i am not that familar with sql like i am with mysql. There might be a (good?) reason or something back from the mysql days left. ------------------------------------------------------------------------ DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=106700 _______________________________________________ Squeezecenter mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/squeezecenter
