search

shipperhq / module-shipper

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

SQL error updating from 20.47.1 => 20.47.2 #112

Closed pioneerathletics closed 2 years ago

pioneerathletics commented 2 years ago

Magento version: 2.4.3-p1 MySQL version: 5.7

Hello,

I received this error after upgrading from 20.47.1 => 20.47.2 and running setup:upgrade:

Updating modules: Cache cleared successfully Schema creation/updates: SQLSTATE[HY000]: General error: 1553 Cannot drop index 'SHIPPERHQ_ORDER_DETAIL_GRID_ORDER_ID': needed in a foreign key constraint, query was: ALTER TABLE shipperhq_order_detail_grid DROP KEY SHIPPERHQ_ORDER_DETAIL_GRID_ORDER_ID

Note: When I updated to 20.47.1 the other day I had no database issue. It was only updating from 20.47.1 to 20.47.2 where I encountered this.

Thanks

ibraheemnabeelfauzi commented 2 years ago

Hello @pioneerathletics ,

Many thanks for the details. We see the cause of the issue and we'll release a fix for it.

Can you please provide us with your company name?

pioneerathletics commented 2 years ago

Hi @ibraheemnabeelfauzi,

I work for Pioneer Athletics and we use the ShipperHQ module on 3 of our websites. Looking forward to the fix for this. Thanks!

wsajosh commented 2 years ago

Hi @pioneerathletics Thanks for raising this! I've just released a new version which will address the issue. Please update and let us know if you hit any further issues.