460849 - SQL change for preview.AMO (bandwagon project)

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Fred Wenzel [:wenzel]]

Please execute the following two pieces of SQL:
- attachment 343635 [details]
- attachment 343844 [details]

(both from bug 456130) on preview.AMO so the "interactive collections" do something useful.

No downtime required.

Comment 1

[Mark Smith [:xb95]]

in before oremj

Comment 2

[Jeremy Orem [:oremj]]

You win this time!

Comment 3

[Mark Smith [:xb95]]

Mwa ha ha!

...

Two errors at the end of the second attachment, everything else executed ok:

mysql> INSERT INTO `addons_collections` VALUES (8384, 1, '0000-00-00 00:00:00', 2);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`addons_reskin/addons_collections`, CONSTRAINT `addons_collections_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`))

mysql> INSERT INTO `addons_collections` VALUES (8782, 1, '0000-00-00 00:00:00', 7);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`addons_reskin/addons_collections`, CONSTRAINT `addons_collections_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`))

Comment 4

[Fred Wenzel [:wenzel]]

(In reply to comment #3)
> Two errors at the end of the second attachment, everything else executed ok:

Thanks! That means the preview DB is out of date, as these add-ons don't exist there. That's fine for now, I'll make sure to file another bug if we need that updated.