Page 7 of 11

Re: Music Archive

Posted: Sat Dec 04, 2010 3:52 pm
by Ross
For some reason My archive list includes "future on the Road" which I did not submit for, but does not include "After Hours."

Thanks

Ross

Re: Music Archive

Posted: Sat Dec 04, 2010 3:56 pm
by fluffy
Holy cats you have a lot of songs in the archive. I'm surprised you don't have MORE mislabeled songs.

Re: Music Archive

Posted: Fri Dec 10, 2010 8:13 am
by Niveous
I'm having trouble streaming "Influential Film" by Daddy Bop for some reason.

Re: Music Archive

Posted: Mon Dec 13, 2010 11:02 pm
by Spud
Niveous wrote:I'm having trouble streaming "Influential Film" by Daddy Bop for some reason.
I am having no such problem.

Re: Music Archive

Posted: Fri Dec 17, 2010 9:24 am
by fluffy
Hey, it looks like the same thing happened to my archive, too. I suspect it happened to all the After Hours entries.

Re: Music Archive

Posted: Fri Feb 11, 2011 7:20 am
by BBABM
hey, just happened to notice that in the archive there are both "Bad Boys at Bat Mitzvahs" and "Bad Boys At Bat Mitzvahs. this is probably my fault in some way for labeling my song, or email wrong. i don't really care about that, however, both links go to "Bad Boys at Bat Mitzvahs" and so only half my songs are on there. again, its not a super big problem for me, because i obviously have all my songs on hard copy, but it may cause problems for later cover fights, etc. i may enter. take your time, as im sure everybody has more pressing and important issues. thanks!


p.s. if you were somehow able to combine them, the "at" is correct... not the "At"

Re: Music Archive

Posted: Fri Feb 11, 2011 9:41 am
by Niveous
BBABM wrote: however, both links go to "Bad Boys at Bat Mitzvahs" and so only half my songs are on there.
There are a couple of bands with that same problem like BLT & Paco; The Booty Chesterfield Trio; and Chonny (there's a whole bunch). Something about merging the two names doesn't merge the two lists of songs.

Re: Music Archive

Posted: Fri Feb 11, 2011 11:02 am
by Lunkhead
The problem is that people can't consistently type their artist names, and that there is any case sensitivity in the system. All case variations should be treated the same, I think. I don't think it really adds any value to make it possible for there to be two distinct artists whose names only vary in their case. In my app case is ignored in artist names:

http://sfjukebox.org/sf/artists/Bad%20B ... 20Mitzvahs

Re: Music Archive

Posted: Fri Feb 11, 2011 11:21 am
by Niveous
Lunkhead,

I have to say that the SFjukebox is looking great these days. Nice work.

Re: Music Archive

Posted: Fri Feb 11, 2011 1:58 pm
by BBABM

Re: Music Archive

Posted: Fri Feb 11, 2011 3:04 pm
by Lunkhead
Niveous wrote:Lunkhead,

I have to say that the SFjukebox is looking great these days. Nice work.
Thanks Niv! I hope to keep adding to it and improving whenever I have time, though lately that hasn't been as often as I'd like.

Re: Music Archive

Posted: Sun Feb 13, 2011 10:28 pm
by Lunkhead
Would it be possible to merge "Tobin’s Spirit Guide" (with a special curvy Microsoft-y single-quote) into "Tobin's Spirit Guide" (with a normal single-quote)?

Re: Music Archive

Posted: Sun Feb 13, 2011 10:51 pm
by Lunkhead
Also, what is up with "Poppetshuw", an artist with one fight entry for which there is no URL, just "none"?

http://www.songfight.org/artistpage.php ... rtkey=date

It's breaking my s#@%. :( I accidentally just hosed my whole database and am trying to re-import but am having a problem because of that one thing. Aargh.

Re: Music Archive

Posted: Sun Feb 13, 2011 11:32 pm
by fluffy
That is one of the mp3s which got lost in the Great Transition from Meanwhile to songfight.org. I'm surprised this didn't cause you a problem before.

Re: Music Archive

Posted: Mon Feb 14, 2011 8:50 am
by Lunkhead
Good point. It looks like it started being a problem after I kludged in support for parsing late entries. I managed to kludge around it last night and get the data imported again.

As another lesson on the evils of manual updates of data, I wiped out my database because I forgot my "where" clause in a SQL statement. Doh!

Re: Music Archive

Posted: Mon Feb 14, 2011 8:53 am
by fluffy
Two things are your friend:

1. Transactions
2. Database snapshotting

In the case of 2, a daily cron job that just does mysqldump is handy. Here's mine (which I have in addition to Dreamhost's default one, since Dreamhost's can't be automatically backed up by my account mirroring script):

Code: Select all

#!/bin/sh

mkdir -p $HOME/db-backup
cd $HOME/db-backup
mysqldump -u #### --password=#### -h #### --all-databases | gzip -c > mysql-backup-`date +%Y%m%d`.sql.gz
find . -name 'mysql-backup-*.sql.gz' -mtime +10 -print0 | xargs -0 rm
with the ####s replaced by the appropriate values, obviously.

Re: Music Archive

Posted: Mon Feb 14, 2011 11:04 am
by irwin
Obviously transactions are the better answer, but if you're using MySQL, the command line has an "--i-am-a-dummy" option which will cause it to reject an update statement without a "WHERE" clause.

Re: Music Archive

Posted: Mon Feb 14, 2011 11:06 pm
by Lunkhead
Irwin, I assume you are joking, but I wish you weren't.

fluffy, I don't snapshot because i am lazy and I can just re-import from the real data source. For now I don't have any significant other data in that db, and also I have no need to manually futz with the non-archive data and possibly fubar it. But otherwise, that would be a good solution. Probably I should replace my "mysql" command with one that does a snapshot first every time I invoke it... Really though I should write some code to do the kind of maintenance tasks I do, so that I can't screw them up so easily.

Re: Music Archive

Posted: Mon Feb 14, 2011 11:15 pm
by fluffy
There's always just using phpMyAdmin as a GUI-ish frontend. It's pretty decent as a general-purpose table and schema editor, at least.

Re: Music Archive

Posted: Mon Feb 14, 2011 11:17 pm
by fluffy
Lunkhead wrote:Irwin, I assume you are joking, but I wish you weren't.
Actually, it's for real. It's a synonym for --safe-updates which is also shortened -U. You can also set it in a config file.

Re: Music Archive

Posted: Tue Feb 15, 2011 11:48 pm
by irwin
No, really, I wasn't trying to be insulting. Sorry if it came across that way!

I just think "--i-am-a-dummy" is more fun that "--safe-updates".

Probably because I am a dummy and that flag has saved me.

Though really I think it is SQL that is the dummy. Seriously, the default action would be to affect all rows?! If I were king, there would be a "WHERE ALL" clause to explicitly request that.

Re: Music Archive

Posted: Wed Feb 16, 2011 12:38 am
by fluffy
Daily snapshots have saved my ass on more than one occasion. Never underestimate the security blanket afforded by cron.