i am missing a table setup_module in magent 2.3.2 database,

the site is working, however i cannot install any extensions as the new tables are not being created due to missing setup_module.

i could figure out the table columns as, not confirmed on data fields


data_version - TEXT NOT NULL,

schema_version - TEXT NOT NULL,

if someone can send a screen shot of setup_module it can help.

found a post saying rename env.php and install magento 2.3.2 again

  • Just login to your database server and create the table?
    – Black
    Dec 20, 2019 at 19:50
  • @Black is there any where to find columns, datatype to create in setup_module table Dec 20, 2019 at 20:18
  • Just download and setup a fresh magento and copy the table from it
    – Black
    Dec 21, 2019 at 9:04

1 Answer 1


Login to your database then run this:

CREATE TABLE `setup_module` (
 `module` varchar(50) NOT NULL COMMENT 'Module',
 `schema_version` varchar(50) DEFAULT NULL COMMENT 'Schema Version',
 `data_version` varchar(50) DEFAULT NULL COMMENT 'Data Version',
 PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Module versions registry'

Pulled directly from a fresh Magento 2.3 install. You might also do a clean Magento 2 install then compare schemas to see if you're missing anything else.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.