Upgrade from 2.2.5 to 2.3.0 Base table or view not found

[joe_masciangelo]

I have my Magento Site hosted with SiteGround web hosting. When trying to upgrade from 2.2.5 to 2.3.0 I am receiving the following errors:

/magento setup:upgrade
Cache cleared successfully
File system cleanup:
/generated/code/Composer
/generated/code/MSP
/generated/code/Magento
/generated/code/Symfony
Updating modules:
Schema creation/updates:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DATABASENAME.mgo8_sm_products_filter' doesn't exist, query was: SHOW CREATE TABLE mgo8_sm_products_filter

[madhuresan_ramanan]

Hi @joe_masciangelo,

There is missing of the table in your 2.2.5 while you upgrading to 2.3.0. so do one thing. Just export the missing table from the 2.2.5 and upload it in your 2.3.0. but the table already found in your 2.2.5, the reason is table is missing while you upgrading.

If my answer is useful, give kudos & accept as solution

Best regards
Madhuresan
Bootsgrid

[Manthan Dave]

Hi @joe_masciangelo 

Are you upgrading your magento version using command line - by running commands ? or upgrading from bakcend wizard ?

The reason behind error is few tables are missing while upgrading the version and that's the reason you are facing error, so let us know how you are upgrading your version ?

its help us to troubleshoot the issue !

[joe_masciangelo]

I am updating using these commands:

php bin/magento maintenance:enable

composer require magento/product-community-edition 2.3.0 --no-update

composer update

rm -rf <Magento install dir>/var/cache/

rm -rf <Magento install dir>/var/page_cache/

rm -rf <Magento install dir>/var/generation/

bin/magento setup:upgrade php

bin/magento maintenance:disable

service varnish restart

[joe_masciangelo]

I never did receive a reply to this post.

 am updating using these commands:

php bin/magento maintenance:enable

composer require magento/product-community-edition 2.3.0 --no-update

composer update

rm -rf <Magento install dir>/var/cache/

rm -rf <Magento install dir>/var/page_cache/

rm -rf <Magento install dir>/var/generation/

bin/magento setup:upgrade php

bin/magento maintenance:disable

service varnish restart

Can you instruct me on how to resolve my problem?

Thanks.

[madhuresan_ramanan]

Hi @joe_masciangelo,

The problem still exist? let me know. Same issue table view not found? is it?



If my information is useful, give kudos

Best regards
Madhuresan
Bootsgrid

[joe_masciangelo]

Yes. I am having the same problem still

[madhuresan_ramanan]

Hi @joe_masciangelo,

As I already in this post Table was missing in your 2.2.5 version while upgrading to latest version. you need to export the table from the older one and add this table in the latest 2.3 version database. There is no error in your commands. Once your add the table in the latest version database and then run with your commands.

If my answer is useful, give kudos & accept as solution

Best regards
Madhuresan
Bootsgrid