Encyclopaedia Metallum: The Metal Archives

Change in the band ids?

Moderator: Site moderators

Forum Index » Site Feedback » Suggestions and Complaints

Author

Message Previous topic | Next topic

oneyoudontknow
Cum insantientibus furere necesse est.

Joined: Sun May 21, 2006 6:25 pm
Posts: 5343
Location: Germany

Posted: Sun Jun 15, 2008 5:07 am

I am just curious, why the band ids have changed for new submitted bands.

an old one:
http://www.metal-archives.com/band.php?id=129332
a new one:
http://www.metal-archives.com/band.php?id=3540255455

_________________

My website which contains reviews as well as interviews:
https://adsol.oneyoudontknow.com
My podcast:
https://adsolmag.bandcamp.com/

Top

immortalshadow666
Transilvanian sandwich, mould! MOULD!

Joined: Thu Jun 09, 2005 9:58 pm
Posts: 1612
Location: Australia

Posted: Sun Jun 15, 2008 5:09 am

PLEASE BE REMOVE IT. IT HAS 10 DIGITS IN IT, ID'S WITH 10 DIGITS ARE INCOMPLETE AND I HATE IT!!!!!!!!:D

_________________

OlioTheSmall wrote:

AIDS... AIDS... AND MORE AIDS!!!!!!!!!

Top

Goatfangs
58.2% Metal

Joined: Tue Mar 18, 2008 5:02 pm
Posts: 2805
Location: United States

Posted: Sun Jun 15, 2008 5:26 am

immortalshadow666 wrote:

PLEASE BE REMOVE IT. IT HAS 10 DIGITS IN IT, ID'S WITH 10 DIGITS ARE INCOMPLETE AND I HATE IT!!!!!!!!:D

Why do I get the feeling that this is a reference to something?

_________________
LGBTQ+
Unashamedly colorful

And they'll tell you black is really white - The moon is just the sun at night - And when you walk in golden halls - You get to keep the gold that falls - It's Heaven and Hell

Top

immortalshadow666
Transilvanian sandwich, mould! MOULD!

Joined: Thu Jun 09, 2005 9:58 pm
Posts: 1612
Location: Australia

Posted: Sun Jun 15, 2008 5:29 am

Montmirail... A guy who whined incessantly and threatened the site. The reason was that his band ID is #100369 and he hated his band ending with the number 9 for some ridiculous reason.

The thread was hysterically funny... I'll see if I can find it

Edit: Here we are

http://www.metal-archives.com/board/vie ... highlight=

_________________

OlioTheSmall wrote:

AIDS... AIDS... AND MORE AIDS!!!!!!!!!

Top

Corimngul
Freddled Gruntbuggly

Joined: Tue Apr 20, 2004 12:18 pm
Posts: 872
Location: Sweden

Posted: Sun Jun 15, 2008 7:05 am

Shadow, you fail. It is nine that is incomplete, not ten.

Anyway, yes this change in IDs has been noted already. I don't know why it has happened.

_________________

Wra1th1s wrote:

When I meant EVERY black metal band of course I don't mean EVERY black metal band.

Montmirail wrote:

Because I hate ID 100369. Numbers 19, 29, 39, 49, 59 are incomplete and I hate it!

Top

failsafeman
Digital Dictator

Joined: Wed Sep 01, 2004 8:45 am
Posts: 11852
Location: In the Arena

Posted: Sun Jun 15, 2008 7:15 am

It's apparently related to the recent downtime + loss of various threads, though I'm not completely sure of why or what the connection is (if any).

_________________

MorbidBlood wrote:

So the winner is Destruction and Infernal Overkill is the motherfucking skullcrushing poserkilling satan-worshiping 666 FUCK YOU greatest german thrash record.

Top

Bonesnap
Metal newbie

Joined: Tue Aug 16, 2005 11:34 pm
Posts: 80
Location: Canada

Posted: Sun Jun 15, 2008 11:45 pm

The ID field is a auto-generated number and it auto-increments every time a band is accepted. Same with albums, songs, etc. It's a fundamental part of any good database.

_________________
When I die, I want to be reincarnated as a random number generator.

Top

Wra1th1s
Metal newbie

Joined: Mon Mar 24, 2008 9:04 am
Posts: 327
Location: Indonesia

Posted: Mon Jun 16, 2008 12:36 am

immortalshadow666 wrote:

Edit: Here we are

http://www.metal-archives.com/board/vie ... highlight=

That thread is the funniest thing on this site. I swear I peed a little reading Montmirail's posts.

_________________
Hear the call Atlanteans,
Proud we stand forever!
Mightiest of warriors,
we sail across the sea!

Top

Corimngul
Freddled Gruntbuggly

Joined: Tue Apr 20, 2004 12:18 pm
Posts: 872
Location: Sweden

Posted: Mon Jun 16, 2008 8:15 am

Bonesnap wrote:

The ID field is a auto-generated number and it auto-increments every time a band is accepted. Same with albums, songs, etc. It's a fundamental part of any good database.

Yes, it's the table key. The reason for the jump from a six-digit number to a ten-digit number is however not as obvious.

Wra1th1s wrote:

immortalshadow666 wrote:

Edit: Here we are

http://www.metal-archives.com/board/vie ... highlight=

That thread is the funniest thing on this site. I swear I peed a little reading Montmirail's posts.

It's pretty much the best thing ever - and a more than worthy sig.

_________________

Wra1th1s wrote:

When I meant EVERY black metal band of course I don't mean EVERY black metal band.

Montmirail wrote:

Because I hate ID 100369. Numbers 19, 29, 39, 49, 59 are incomplete and I hate it!

Top

Morrigan
Crone of War

Joined: Sat Aug 10, 2002 7:27 am
Posts: 10529
Location: Canada

Posted: Mon Jun 16, 2008 9:41 am

Yeah, the auto_increment value completely screwed up during the crash the other day. Several tables were corrupted and had to be repaired. If the worst impact we had to the band data is merely a bizarre ID change, I guess we can count ourselves lucky.

Top

Bonesnap
Metal newbie

Joined: Tue Aug 16, 2005 11:34 pm
Posts: 80
Location: Canada

Posted: Mon Jun 16, 2008 2:04 pm

Morrigan, how many tables are there in the database? My guess would be around 40 but it all depends on how much you've normalized it. I can only imagine how many V2 will have.

_________________
When I die, I want to be reincarnated as a random number generator.

Top

	Forum Index » Site Feedback » Suggestions and Complaints
Page 1 of 1 [ 11 posts ]

Who is online

Users browsing this forum: rsmplcll and 24 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Change in the band ids?

Who is online

Back to the Encyclopaedia Metallum