search

shipperhq / module-shipper

Base ShipperHQ Repo
Open Software License 3.0
21 stars 20 forks source link

Cannot drop index 'SHIPPERHQ_ORDER_DETAIL_GRID_ORDER_ID': needed in a foreign key constraint #108

Closed iindranil closed 2 years ago

iindranil commented 2 years ago

Hello,

I am getting this error [Cannot drop index 'SHIPPERHQ_ORDER_DETAIL_GRID_ORDER_ID': needed in a foreign key constraint] after upgraded Magento Version 2.3.4 to 2.4.2-p1

Details what I am using: Magento Version : 2.4.2-p1

"name": "shipperhq/module-shipper" "version": "20.45.6"

The above issue I am getting while run setup upgrade, If I disabled the module then our Magento running well.

Is there any solution available? Please let me know.

Thank you,

wsadasmit commented 2 years ago

Hi @iindranil ,

Thanks for the description of your issue. module-shipper's latest version is 20.45.6, can you tell me what version is currently installed? Please let me know your php and MySQL versions as well.

Can you please try uninstalling the module and then installing the latest version? You can use the command php bin/magento module:uninstall ShipperHQ_Shipper (excluding the -r flag) to cause the uninstallation process to ask you if you want to remove the product data, so that you can choose to preserve it. It would also be wise to back up your data to ensure nothing is lost while troubleshooting, just in case.

armmage commented 2 years ago

I am facing the same error with installing the latest version in Magento 2.3 version. Is there any solution without uninstalling? SQLSTATE[HY000]: General error: 1553 Cannot drop index 'SHIPPERHQ_ORDER_DETAIL_GRID_ORDER_ID': needed in a foreign key constraint

wsajosh commented 2 years ago

Thanks for raising this issue. We'll be creating a new release shortly which addresses it. Please update to that new version once its available