Magento 2 expert DB needed -- 2
Budget: $30 – $250 USD
Hello
We are changing server and we are facing an issue to import in phpmyadmin some tables of an extension "amasty gdpr"
There is lot of tables like this bottom one, those queries are giving error in phpmyadmin : Errcode: 150 "Foreign key constraint is incorrectly formed"
They are talking about same problem and extention "amasty" here : https://github.com/magento/magento2/issues/22353
We don't know how fix this
It works very well on old server but we cannot migrate to new server because of this problem
CREATE TABLE `amasty_gdpr_privacy_policy` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Date of creating',
`policy_version` varchar(10) NOT NULL DEFAULT '' COMMENT 'Policy Version',
`content` text NOT NULL COMMENT 'Policy Content',
`date_last_edited` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last editing',
`last_edited_by` int(10) unsigned DEFAULT NULL,
`comment` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
`status` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Status',
PRIMARY KEY (`id`),
KEY `FK_AMASTY_GDPR_PRIVACY_POLICY_LAST_EDITED_BY_ADMIN_USER_USER_ID` (`last_edited_by`),
CONSTRAINT `FK_AMASTY_GDPR_PRIVACY_POLICY_LAST_EDITED_BY_ADMIN_USER_USER_ID` FOREIGN KEY (`last_edited_by`) REFERENCES `admin_user` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='amasty_gdpr_privacy_policy';
We are changing server and we are facing an issue to import in phpmyadmin some tables of an extension "amasty gdpr"
There is lot of tables like this bottom one, those queries are giving error in phpmyadmin : Errcode: 150 "Foreign key constraint is incorrectly formed"
They are talking about same problem and extention "amasty" here : https://github.com/magento/magento2/issues/22353
We don't know how fix this
It works very well on old server but we cannot migrate to new server because of this problem
CREATE TABLE `amasty_gdpr_privacy_policy` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Date of creating',
`policy_version` varchar(10) NOT NULL DEFAULT '' COMMENT 'Policy Version',
`content` text NOT NULL COMMENT 'Policy Content',
`date_last_edited` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last editing',
`last_edited_by` int(10) unsigned DEFAULT NULL,
`comment` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
`status` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Status',
PRIMARY KEY (`id`),
KEY `FK_AMASTY_GDPR_PRIVACY_POLICY_LAST_EDITED_BY_ADMIN_USER_USER_ID` (`last_edited_by`),
CONSTRAINT `FK_AMASTY_GDPR_PRIVACY_POLICY_LAST_EDITED_BY_ADMIN_USER_USER_ID` FOREIGN KEY (`last_edited_by`) REFERENCES `admin_user` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='amasty_gdpr_privacy_policy';