Fix the issue Column not found/ unknown column when installing the extension. Examples: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shipping_arrival_date'

Created by Rosa Truong, Modified on Tue, 24 Dec, 2019 at 4:36 PM by Rosa Truong

Issue:

When installing your extension, I got the error below:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shipping_arrival_date'

The root of the issue:

This issue is caused because the table of our extension is not created in the DB when installing the extension.

Solution:

Regarding your issue, we would suggest that you should try to reset up our extension on your site.

Please remove the extension version in the setup_module table on the database and rerun the upgrade.

Note: please run these commands:

php bin/magento setup:upgrade

php bin/magento setup:static-content:deploy -f

Please check and follow our guide.

If the issue still happens, please don't hesitate to contact us at sales@bsscommerce.com

We'll happy to support you.