Help with php bin/magento setup:upgrade command

[diltech]

I opened this topic in English hoping to have an answer in the shortest since I was stuck with updates

With the "php bin/magento setup:upgrade command"
Hi everyone, I'm looking for your help, when I give the command "php bin / magento setup: upgrade" obviously without the "it gives me this error:

SQLSTATE [42S02]: Base table or view not found: 1146 Table 'xxx_mg1.mg_shipment_carriers' doesn't exist, query was: SHOW CREATE TABLE `mg_shipment_carriers`

I tried to install in a subdomain the same version of magento 2.3.5 p2 same modules and theme, no problem with the command.

How can I solve? I got stuck

Thank you all

[shraddhash9dd4]

Hello,

Please run setup:install command given below and if you already ran it try to re:run it.

bin/magento setup:install \
--base-url=http://localhost/magento2ee \
--db-host=localhost \
--db-name=magento \
--db-user=magento \
--db-password=magento \
--admin-firstname=admin \
--admin-lastname=admin \
--admin-email=admin@admin.com \
--admin-user=admin \
--admin-password=admin123 \
--language=en_US \
--currency=USD \
--timezone=America/Chicago \
--use-rewrites=1

If you still face the same issue then delete your database and also delete app/etc/env.php file and then create a new database and run above command.
For more details check below link 

https://devdocs.magento.com/guides/v2.4/install-gde/composer.html

Hope this will help you

[meher jeet_sachan]

Hello @diltech,

I think the mg_shipment_carriers table does not exist in your DB, on the other hand, your subdomain DB had it. please cross-check it. 

Thanks & Regards