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

[iindranil]

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]

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]

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]

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