Problem updating by command line

[josemartin0d0b]

Hi! I recently migrated from Magento 2.3.2 to Magento 2.3.6.

The migration process was successful, but I got an error when I execute 

bin/magento setup:upgrade

And it is:

Module 'Dotdigitalgroup_Email':
Upgrading data.. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported' in 'where clause', query was: UPDATE `email_catalog` SET `processed` = ? WHERE (imported) AND (modified IS NULL OR modified = 0)

I run a select all in that table and effectively, the column "imported" is missed. 

What can I do? I executed composer install, setup:clean, setup:flush, indexer:reindex and setup:db-schema:upgrade.

I want to know if there is a way to rebuild the schema, creating tables with their structure according to Magento 2.3.6

How can I solve this?

I really appreciate your help!

Thanks!

.

.

[meher jeet_sachan]

Hello @josemartin0d0b

You can rebuild the schema but for that, you need to remove the extension entry from the setup_module table and remove the table email_catalog.

but it is the last option to do. please fetch the updated package of Dotdigitalgroup_Email from the composer and then try to execute the setup upgrade command.

Thanks