Magento 2.3.* files upgraded using composer. After that used to upgrade module setup using following commands but facing error.

bin/magento setup:upgrade


Cache cleared successfully
File system cleanup:

The directory '/generated/metadata/' doesn't exist - skipping cleanup
Updating modules:
Schema creation/updates:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.temp' doesn't exist, query was: SHOW CREATE TABLE temp

Help is much appreciated..I have tried many times facing issues, is there any permission issue? Thanks.

1 Answer 1


Please check with your phpmyadmin database - magento.. temp table not exists in database.. if you can create than facing issue like table or view exists than go to /var/lib/mysql/ here find database folder name remove folder or remove temp.frm

I hope its work for you.


Your Answer

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

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