I can has TWOO divabats? August 15, 2007 5:42 PM   Subscribe

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


« Older Meetup in Victoria, BC?   |   The Best of "How to Date & Flirt the Mefite... Newer »

You are not logged in, either login or create an account to post comments