Closed
Bug 460849
Opened 16 years ago
Closed 16 years ago
SQL change for preview.AMO (bandwagon project)
Categories
(mozilla.org Graveyard :: Server Operations, task)
Tracking
(Not tracked)
VERIFIED
FIXED
People
(Reporter: wenzel, Assigned: xb95)
References
()
Details
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 2•16 years ago
|
||
You win this time!
Assignee | ||
Comment 3•16 years ago
|
||
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`))
Status: ASSIGNED → RESOLVED
Closed: 16 years ago
Resolution: --- → FIXED
Reporter | ||
Comment 4•16 years ago
|
||
(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.
Status: RESOLVED → VERIFIED
Updated•9 years ago
|
Product: mozilla.org → mozilla.org Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•