Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: Mercury
-
Component/s: Database/Schema
-
Labels:None
-
Environment:
AML-Core - feature/mysql-5-5-46-upgrade
-
Sprint:Sprint 13
Description
On running create-all-aml.sh to create content_editor_google structure, the following error is seen
Creating database content_editor_google ...
create database IF NOT EXISTS `content_editor_google` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
tables/gce_adGroupError.sql
tables/gce_adGroupPendingChange.sql
tables/gce_adGroupPendingUpdate.sql
tables/gce_adGroup.sql
tables/gce_adLocation.sql
tables/gce_campaign1.sql
tables/gce_campaignAdExtension.1.Map.sql
tables/gce_campaignAdExtensionMap.2.PendingChange.sql
tables/gce_campaignAdExtensionMap.3.Error.sql
tables/gce_campaignAdExtensionMap.4.PendingUpdate.sql
tables/gce_campaignBudgetOptimizerSetting.sql
tables/gce_campaignError.sql
tables/gce_campaignPendingChange.sql
tables/gce_campaignPendingUpdate.sql
tables/gce_campaignProximityTargetMapPendingUpdate.sql
tables/gce_campaignProximityTargetMap.sql
tables/gce_campaignTargetMapError.sql
tables/gce_campaignTargetMapPendingChange.sql
tables/gce_campaignTargetMapPendingUpdate.sql
tables/gce_campaignTargetMap.sql
tables/gce_cb_adSiteLink.sql
tables/gce_currentAdGroup.sql
tables/gce_currentAds.sql
tables/gce_currentCampaigns.sql
tables/gce_currentCriterion.sql
tables/gce_feed1_feed1.sql
ERROR 1217 (23000) at line 1 in file: 'tables/gce_feed1_feed1.sql': Cannot delete or update a parent row: a foreign key constraint fails
Error running sql script - content_editor_google - tables/gce_feed1_feed1.sql
