cancel
Showing results for 
Search instead for 
Did you mean: 

SQL error when run setup:upgrade after upgrade from 2.3.1 to 2.3.4

SQL error when run setup:upgrade after upgrade from 2.3.1 to 2.3.4

Hi everyone!

I have upgraded my source version from 2.3.1 to 2.3.4.

I have run these command:

 

php bin/magento maintenance:enable
composer require magento/product-community-edition 2.3.3 --no-update
composer update
php bin/magento cache:flush

 

Everything is fine.

But when I run

php bin/magento setup:upgrade

It got error:

 

Cache cleared successfully File system cleanup: C:/xampp/htdocs/Matthewsliquor/generated/code/Composer C:/xampp/htdocs/Matthewsliquor/generated/code/Dotdigitalgroup C:/xampp/htdocs/Matthewsliquor/generated/code/MSP C:/xampp/htdocs/Matthewsliquor/generated/code/Magento C:/xampp/htdocs/Matthewsliquor/generated/code/Symfony C:/xampp/htdocs/Matthewsliquor/generated/code/Yotpo The directory 'C:/xampp/htdocs/Matthewsliquor/generated/metadata/' doesn't exist - skipping cleanup C:/xampp/htdocs/Matthewsliquor/pub/static/adminhtml C:/xampp/htdocs/Matthewsliquor/pub/static/deployed_version.txt C:/xampp/htdocs/Matthewsliquor/pub/static/frontend C:/xampp/htdocs/Matthewsliquor/var/view_preprocessed/pub Updating modules: Schema creation/updates: SQLSTATE[HY000]: General error: 1005 Can't create table matthews.catalog_product_index_price_cfg_opt_agr_tmp (errno: 140 "Wrong create options"), query was: ALTER TABLE catalog_product_index_price_cfg_opt_agr_tmp MODIFY COLUMN price decimal(20, 6) NULL COMMENT "Price", MODIFY COLUMN tier_price decimal(20, 6) NULL COMMENT "Tier Price", ENGINE='innodb'

 

How I can fix this?

Thank you!

1 REPLY 1

Re: SQL error when run setup:upgrade after upgrade from 2.3.1 to 2.3.4

Hello @hao_nguyen4 

 

 
php bin/magento indexer:reindex

Please run the above command.
 
I hope it helps.
 
Problem solved? Click Kudos and "Accept as Solution".
200+ Magento 2 Extensions for Enhanced Shopping Experience.