Skip to content

Failed to add the foreign key constraint ‘—/CUSTOMER_ENTITY_STORE_ID_STORE_STORE_ID’ to system tables

On running the setup:upgrade command I’m receiving this error on Schema generation. Schema creation/updates: SQLSTATE[HY000]: General error: 1823 Failed to add the foreign key constraint ‘/CUSTOMER_ENTITY_STORE_ID_STORE_STORE_ID’ to system tables, query was: ALTER TABLE customer_entity ADD CONSTRAINT CUSTOMER_ENTITY_STORE_ID_STORE_STORE_ID FOREIGN KEY (store_id)… Read More »Failed to add the foreign key constraint ‘—/CUSTOMER_ENTITY_STORE_ID_STORE_STORE_ID’ to system tables

Is there a pre-customized set of CRS(Core Rule Set) rules for Magento 2.4, or should I customize them myself?

I am currently using Magento 2.4.7 with the latest version of Oswap CRS (v4.11.0) in detection-only mode using Modsecurity2. Despite my efforts to exclude certain rules and whitelist specific URLs, I am still experiencing IP blockages by CRS for certain… Read More »Is there a pre-customized set of CRS(Core Rule Set) rules for Magento 2.4, or should I customize them myself?