464837 - SQL to deploy on both AMO and preview.AMO DBs

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Fred Wenzel [:wenzel]]

Attachment: new add-on list for Fashion your Firefox

Please execute the attached SQL on production AMO as well as preview (note: if you do this before you fix bug 464829, you can skip executing it on preview, as you'll overwrite it anyway).

It changes the list of add-ons in the "fashion your firefox" collection.

End user impact: none.


CCing morgamic for approval.

Comment 1

[Fred Wenzel [:wenzel]]

Comment on attachment 348131 [details]
new add-on list for Fashion your Firefox

(bugzilla not recognizing SQL files is annoying :( )

Comment 2

[Fred Wenzel [:wenzel]]

Marketing asked for this to happen during the course of Friday, please.

Comment 3

[Michael Morgan [:morgamic]]

Hey, this would help us test something for next Tuesday -- would be a big help.

Comment 4

[Jeremy Orem [:oremj]]

ERROR 1452 (23000) at line 10: 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`))
ERROR 1452 (23000) at line 35: 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`))
ERROR 1452 (23000) at line 40: 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`) REFERE

Comment 5

[Jeremy Orem [:oremj]]

Hmm, I'll do bug 464829 first.  It will probably work after.

Comment 6

[Jeremy Orem [:oremj]]

Attachment 348131 [details] has been run on preview and production.