Music Archive

Let us know when something isn't working correctly, or if you find a typo. Do not post complaints or suggestions here.

Moderator: Mods

User avatar
Ross
Gerudo
Posts: 2730
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

Postby Ross » Sat Dec 04, 2010 3:52 pm

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
Ganon
Posts: 9307
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: Music Archive

Postby fluffy » Sat Dec 04, 2010 3:56 pm

Holy cats you have a lot of songs in the archive. I'm surprised you don't have MORE mislabeled songs.
User avatar
Niveous
Princess Zelda
Posts: 6569
Joined: Mon Sep 27, 2004 6:45 am
Instruments: vocals, songwriting, acoustic guitar
Submitting as: Lucky Witch and the Righteous Ghost
Location: Sunnyside, NY
Contact:

Re: Music Archive

Postby Niveous » Fri Dec 10, 2010 8:13 am

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
Notable Hylian
Posts: 4738
Joined: Fri Sep 24, 2004 10:25 am
Instruments: Bass, Keyboards, eHorn
Submitting as: Octothorpe
Location: Seattle
Contact:

Re: Music Archive

Postby Spud » Mon Dec 13, 2010 11:02 pm

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
Ganon
Posts: 9307
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: Music Archive

Postby fluffy » Fri Dec 17, 2010 9:24 am

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
Skull Kid
Posts: 662
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

Postby BBABM » Fri Feb 11, 2011 7:20 am

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
Princess Zelda
Posts: 6569
Joined: Mon Sep 27, 2004 6:45 am
Instruments: vocals, songwriting, acoustic guitar
Submitting as: Lucky Witch and the Righteous Ghost
Location: Sunnyside, NY
Contact:

Re: Music Archive

Postby Niveous » Fri Feb 11, 2011 9:41 am

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
Lunkhead
Notable Hylian
Posts: 4993
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/reason/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Location: Berkeley, CA
Contact:

Re: Music Archive

Postby Lunkhead » Fri Feb 11, 2011 11:02 am

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
Princess Zelda
Posts: 6569
Joined: Mon Sep 27, 2004 6:45 am
Instruments: vocals, songwriting, acoustic guitar
Submitting as: Lucky Witch and the Righteous Ghost
Location: Sunnyside, NY
Contact:

Re: Music Archive

Postby Niveous » Fri Feb 11, 2011 11:21 am

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
Skull Kid
Posts: 662
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

Postby BBABM » Fri Feb 11, 2011 1:58 pm

Lunkhead
Notable Hylian
Posts: 4993
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/reason/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Location: Berkeley, CA
Contact:

Re: Music Archive

Postby Lunkhead » Fri Feb 11, 2011 3:04 pm

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.
Lunkhead
Notable Hylian
Posts: 4993
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/reason/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Location: Berkeley, CA
Contact:

Re: Music Archive

Postby Lunkhead » Sun Feb 13, 2011 10:28 pm

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)?
Lunkhead
Notable Hylian
Posts: 4993
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/reason/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Location: Berkeley, CA
Contact:

Re: Music Archive

Postby Lunkhead » Sun Feb 13, 2011 10:51 pm

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
Ganon
Posts: 9307
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: Music Archive

Postby fluffy » Sun Feb 13, 2011 11:32 pm

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.
Lunkhead
Notable Hylian
Posts: 4993
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/reason/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Location: Berkeley, CA
Contact:

Re: Music Archive

Postby Lunkhead » Mon Feb 14, 2011 8:50 am

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
Ganon
Posts: 9307
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: Music Archive

Postby fluffy » Mon Feb 14, 2011 8:53 am

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
Fortune Teller
Posts: 476
Joined: Mon Jan 22, 2007 10:09 pm
Instruments: guitar, keys, mandolin, banjo
Recording Method: scotch
Submitting as: suckweasel, kasper, nutwalls
Location: Woodland, CA

Re: Music Archive

Postby irwin » Mon Feb 14, 2011 11:04 am

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
Lunkhead
Notable Hylian
Posts: 4993
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/reason/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Location: Berkeley, CA
Contact:

Re: Music Archive

Postby Lunkhead » Mon Feb 14, 2011 11:06 pm

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
Ganon
Posts: 9307
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: Music Archive

Postby fluffy » Mon Feb 14, 2011 11:15 pm

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
Ganon
Posts: 9307
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: Music Archive

Postby fluffy » Mon Feb 14, 2011 11:17 pm

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
Fortune Teller
Posts: 476
Joined: Mon Jan 22, 2007 10:09 pm
Instruments: guitar, keys, mandolin, banjo
Recording Method: scotch
Submitting as: suckweasel, kasper, nutwalls
Location: Woodland, CA

Re: Music Archive

Postby irwin » Tue Feb 15, 2011 11:48 pm

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
Ganon
Posts: 9307
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: Music Archive

Postby fluffy » Wed Feb 16, 2011 12:38 am

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

Return to “Quality Control”

Who is online

Users browsing this forum: No registered users and 1 guest