Music Archive

Let us know when something isn't working correctly, or if you find a typo. Do not post complaints or suggestions here.
Post Reply
User avatar
Ross
Jump
Posts: 2739
Joined: Sun Feb 27, 2005 3:27 pm
Instruments: Guitar, Vox, Bass, Tuned glasses, etc...
Recording Method: Logic on a Macbook.
Submitting as: Ross Durand
Location: Orange CA
Contact:

Re: Music Archive

Post 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
"I don't like this song, but at least it's good." - veGetar Ianra Ge
http://www.rossdurandmusic.com
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: Music Archive

Post by fluffy »

Holy cats you have a lot of songs in the archive. I'm surprised you don't have MORE mislabeled songs.
User avatar
Niveous
Beat It
Posts: 7177
Joined: Mon Sep 27, 2004 6:45 am
Instruments: vocals, songwriting, guitar
Submitting as: Lucky Witch and the Righteous Ghost
Pronouns: He/him
Location: Staten Island, NY
Contact:

Re: Music Archive

Post by Niveous »

I'm having trouble streaming "Influential Film" by Daddy Bop for some reason.
"I'd like to see 1984 redubbed with this in the soundtrack."- Furrypedro.
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
User avatar
Spud
Hot for Teacher
Posts: 4770
Joined: Fri Sep 24, 2004 10:25 am
Instruments: Bass, Keyboards, eHorn
Submitting as: Octothorpe
Location: Seattle
Contact:

Re: Music Archive

Post by Spud »

Niveous wrote:I'm having trouble streaming "Influential Film" by Daddy Bop for some reason.
I am having no such problem.
"I only listen to good music. And Octothorpe." - Marcus Kellis
Song Fight! The Rockening
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: Music Archive

Post by fluffy »

Hey, it looks like the same thing happened to my archive, too. I suspect it happened to all the After Hours entries.
User avatar
BBABM
Mean Street
Posts: 666
Joined: Sun Aug 15, 2010 11:34 pm
Instruments: Guitar, Voice, drums
Recording Method: Session, fruity loops
Submitting as: Bad Boys at Bat Mitzvahs, Fitzroy
Location: Charlottesville, Va

Re: Music Archive

Post 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"
User avatar
Niveous
Beat It
Posts: 7177
Joined: Mon Sep 27, 2004 6:45 am
Instruments: vocals, songwriting, guitar
Submitting as: Lucky Witch and the Righteous Ghost
Pronouns: He/him
Location: Staten Island, NY
Contact:

Re: Music Archive

Post 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.
"I'd like to see 1984 redubbed with this in the soundtrack."- Furrypedro.
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
User avatar
Lunkhead
You're No Good
Posts: 8106
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Pronouns: he/him
Location: Berkeley, CA
Contact:

Re: Music Archive

Post 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
User avatar
Niveous
Beat It
Posts: 7177
Joined: Mon Sep 27, 2004 6:45 am
Instruments: vocals, songwriting, guitar
Submitting as: Lucky Witch and the Righteous Ghost
Pronouns: He/him
Location: Staten Island, NY
Contact:

Re: Music Archive

Post by Niveous »

Lunkhead,

I have to say that the SFjukebox is looking great these days. Nice work.
"I'd like to see 1984 redubbed with this in the soundtrack."- Furrypedro.
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
User avatar
BBABM
Mean Street
Posts: 666
Joined: Sun Aug 15, 2010 11:34 pm
Instruments: Guitar, Voice, drums
Recording Method: Session, fruity loops
Submitting as: Bad Boys at Bat Mitzvahs, Fitzroy
Location: Charlottesville, Va

Re: Music Archive

Post by BBABM »

User avatar
Lunkhead
You're No Good
Posts: 8106
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Pronouns: he/him
Location: Berkeley, CA
Contact:

Re: Music Archive

Post 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.
User avatar
Lunkhead
You're No Good
Posts: 8106
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Pronouns: he/him
Location: Berkeley, CA
Contact:

Re: Music Archive

Post 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)?
User avatar
Lunkhead
You're No Good
Posts: 8106
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Pronouns: he/him
Location: Berkeley, CA
Contact:

Re: Music Archive

Post 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.
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: Music Archive

Post 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.
User avatar
Lunkhead
You're No Good
Posts: 8106
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Pronouns: he/him
Location: Berkeley, CA
Contact:

Re: Music Archive

Post 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!
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: Music Archive

Post 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.
User avatar
irwin
Mean Street
Posts: 617
Joined: Mon Jan 22, 2007 10:09 pm
Instruments: insecurity
Recording Method: scotch
Submitting as: suckweasel, kasper, nutwalls
Location: Woodland, CA

Re: Music Archive

Post 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.
"Ouch. I wonder if this guy sounds like this when he speaks." -- Puce
User avatar
Lunkhead
You're No Good
Posts: 8106
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Pronouns: he/him
Location: Berkeley, CA
Contact:

Re: Music Archive

Post 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.
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: Music Archive

Post 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.
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: Music Archive

Post 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.
User avatar
irwin
Mean Street
Posts: 617
Joined: Mon Jan 22, 2007 10:09 pm
Instruments: insecurity
Recording Method: scotch
Submitting as: suckweasel, kasper, nutwalls
Location: Woodland, CA

Re: Music Archive

Post 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.
"Ouch. I wonder if this guy sounds like this when he speaks." -- Puce
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: Music Archive

Post by fluffy »

Daily snapshots have saved my ass on more than one occasion. Never underestimate the security blanket afforded by cron.
Post Reply