I can has TWOO divabats?

August 15, 2007 5:42 PM

The divabats are multiplying in my favorites!
posted by orthogonality to Bugs at 5:42 PM (26 comments total)

divabat really, really likes you.

And I think this might have happened before, lemme see if I can track down the thread.
posted by cortex (staff) at 5:45 PM on August 15, 2007

maybe divabat is an amoeba. or an amoebat. or an amoebadiva. or something.
posted by jonmc at 5:53 PM on August 15, 2007

I haven't even got one divabat favorite :(
posted by Poolio at 5:53 PM on August 15, 2007 [2 favorites]

When I had a divabat infestation, I got rid of my extra booze, coke, and pills, and then checked all around the exterior of the dressing room for holes--divabats can squeeze into really small spaces. They use sonar, so it also helps if you refrain from rehearsing your stridently mediocre ballads and hackjob romantic comedy scripts at night for a while.
posted by Kwine at 5:54 PM on August 15, 2007

After removing the duplicates (if Metafilter uses MySQL?)

create table foo; 
insert into foo select distinct * from favorite; 
SET FOREIGN_KEY_CHECKS=0; 
truncate table favorite; 
insert into favorite select * from foo;
SET FOREIGN_KEY_CHECKS=1 

A unique constraint on the favorite table will solve this:

alter table favorite add constraint ufavorite unique constraint (user_id, comment_id, subdomain);

posted by orthogonality at 5:56 PM on August 15, 2007

Metafilter uses (I think) Microsoft SQL Server.
posted by Aloysius Bear at 6:11 PM on August 15, 2007

Then turning off foreign keys is a bit more difficult, bit we don't need to explicitly create table foo; the alter table remains the same.
posted by orthogonality at 6:29 PM on August 15, 2007

I'll totally take your spare divabat, man.
posted by dirtynumbangelboy at 6:30 PM on August 15, 2007

But you'll need those foreign keys to get into your new home abroad!
posted by Abiezer at 6:33 PM on August 15, 2007

Why are there cobwebs on the contact form?
posted by George_Spiggott at 6:42 PM on August 15, 2007

Foo fighter.
posted by Kraftmatic Adjustable Cheese at 7:04 PM on August 15, 2007

I'm happy to report that our long, divabat multiplying-favorites nightmare is over.
posted by pb (staff) at 7:14 PM on August 15, 2007

thanks for the constraints pointer, orthogonality.
posted by pb (staff) at 7:17 PM on August 15, 2007

My apartment just got flooded with divabats! What did you do??

THEY'RE IN MY HAIR!
posted by Astro Zombie at 7:42 PM on August 15, 2007

THEY'RE IN MY HAIR!

Don't worry, Astro Zombie, they're only trying to make a nest.
posted by amyms at 7:51 PM on August 15, 2007

I heard that when you cut a divabat in half, two new divabats form from the tail and head ends.
posted by goodnewsfortheinsane at 7:54 PM on August 15, 2007

The only thing Chuck Norris is afraid of is a divabat.
posted by DMan at 8:41 PM on August 15, 2007

That's what you get when you feed divabats after midnight.
posted by typewriter at 8:43 PM on August 15, 2007

pb writes "thanks for the constraints pointer, orthogonality."

No prob. SQL is fun.
posted by orthogonality at 9:02 PM on August 15, 2007

And I do like me some divabat.
posted by orthogonality at 9:03 PM on August 15, 2007

Nerds.
posted by sveskemus at 3:22 AM on August 16, 2007

My apartment is infested with divabats. It's the cutest infestation ever. Way better than cockroaches.
posted by macadamiaranch at 4:26 AM on August 16, 2007

Abiezer : But you'll need those foreign keys to get into your new home abroad!

But what if I'm more concerned with getting a broad into my new home? Will these keys help? Will they stop the spreading divabats?

TELL ME!
posted by quin at 9:35 AM on August 16, 2007

"We can't stop here, this is divabat country!"
posted by stavrosthewonderchicken at 6:34 PM on August 16, 2007

You rang?
posted by divabat at 10:15 PM on August 17, 2007

We rang so far
away-ee-ayy
posted by cortex (staff) at 8:12 AM on August 18, 2007