After updating MainWP Dashboard to version 4.3, some users may face an issue where their Manage Sites table is empty, and no Child Sites are shown.

Don’t worry – your sites and their data are not deleted, and only the display of said information is affected.

The issue is caused by the low limits for the InnoDB engine. Switching to MyISAM allows for longer Database rows which in turn resolves the issue.

IMPORTANT NOTE: Before attempting this, we highly recommend making a backup of the Database of the MainWP Dashboard site. You can perform the backup/export of the Database using any method you prefer. Here’s one example of performing a quick Database backup.

To fix this issue, perform these steps on your MainWP Dashboard only. There is no need to alter any settings on the Child Sites themselves.

1. Login to your hosting provider’s backend
2. Locate the phpMyAdmin app
   
3. Open it and find the relevant Database
4. Click on the SQL tab
5. Enter the command:
   ALTER TABLE wp_mainwp_wp ENGINE = MyISAM ;
   Note: The table prefix wp_ may be different in your case, so please adjust the command accordingly.
6. Click the Go button
   
7. Navigate to the following URL https://your-mainwp-dashboard.com/wp-admin/options.php
8. Locate the mainwp_db_version field
   
9. Change the value to 8.96
10. Click the Save Changes button at the bottom of the page.
    
11. Navigate to the MainWP Dashboard > Sites > Manage Sites page and verify that the table now displays all your Child Sites
    
12. If you are still not seeing your Child Sites in the table, please open a private ticket so we can assist you.