1. I’ve been having this problem with OpenPhoto which resulted in having over 90,000 records in my tags table.

    To fix this problem, simply run this sql:

    ALTER IGNORE TABLE  `database name`.`prefix_tag` ADD UNIQUE  `unique` (  `id` )
    
  2. @soundcloud @ustream please stop making me fake my UA string in order to view non flash content.

    If you’re going to provide html5 representations of a resource, offer them as standard and fall back to flash, don’t UA sniff.