I installed a new extension last night and in the morning my whole server crashed. I ran the SSH command mysqlcheck --all-databases -r and I noticed it said the table customer_grid_flat doesn't exist on one of my websites. How do I repair this?
2
-
Have you solved your problem? I have the same :-(– lemk0Commented Feb 13, 2017 at 20:15
-
I had to do a whole new installation to fix the issue– bondimedicalCommented Feb 14, 2017 at 21:09
Add a comment
|
1 Answer
You can rename your file app/etc/env.php so Magento 2 will show the installation screen again, no worries all data will keep saved, so run the install process again and run this commands below.
alias mage="php -d memory_limit=-1 -f bin/magento"
mage cache:clean
mage cache:flush
mage indexer:reindex
mage setup:upgrade
mage deploy:mode:set developer
mage setup:db-data:upgrade
mage setup:db-schema:upgrade
mage setup:db:status
answered Apr 5, 2017 at 22:29
