How can we help?

Table of Contents

How to fix the empty Manage Sites table after update to version 4.3

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.
How to fix the empty Manage Sites table after update to version 4.3 1

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
    How to fix the empty Manage Sites table after update to version 4.3 2
  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
    How to fix the empty Manage Sites table after update to version 4.3 3
  7. Navigate to the following URL https://your-mainwp-dashboard.com/wp-admin/options.php
  8. Locate the mainwp_db_version field
    How to fix the empty Manage Sites table after update to version 4.3 4
  9. Change the value to 8.96
  10. Click the Save Changes button at the bottom of the page.
    How to fix the empty Manage Sites table after update to version 4.3 5
  11. Navigate to the MainWP Dashboard > Sites > Manage Sites page and verify that the table now displays all your Child Sites
    How to fix the empty Manage Sites table after update to version 4.3 6
  12. If you are still not seeing your Child Sites in the table, please open a private ticket so we can assist you.
Still Have a Questions?
Search for additional solutions in the MainWP Community or start your own discussion