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

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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.