search

FriendsOfShopware / FroshPlatformShareBasket

This plugin allows your customers to save the current basket and share it via link.
MIT License
13 stars 7 forks source link

6.4 > 6.5.0.0 update error MYSQL 8.0.34 #25

Closed yunits closed 1 year ago

yunits commented 1 year ago

PHP Version

8.2

Shopware Version

6.5.0.0

Actual behaviour

Update plugin and get the following error message

An exception occurred while executing a query: SQLSTATE[0A000]: Feature not supported: 1846 ALGORITHM=COPY is not supported. Reason: Columns participating in a foreign key are renamed. Try ALGORITHM=INPLACE.

Edit migration. Drop foreign key before renaming cart_id to share_basket_id then add foreign key again.

Expected behaviour

see above

Steps to Reproduce?

see above

yunits commented 1 year ago

not tested but Migration1558180775 should be something like this:

ALTER TABLE 'frosh_share_basket_line_item' 
DROP FOREIGN KEY 'cart_id'
CHANGE 'cart_id' 'share_basket_id' BINARY(16) NOT NULL
ADD CONSTRAINT 'fk.frosh_share_basket_line_item.share_basket_id' FOREIGN KEY ('share_basket_id')
REFERENCES 'frosh_share_basket' ('id') ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE 'frosh_share_basket_line_item' ADD COLUMN 'payload' JSON NULL;