Listing tables merely requires the SELECT privilege in MySQL / MariaDB. This is the same privilege that's required to read content from these tables, an operation that's necessary for Joomla to run at all. Therefore, we can conclude the problem is not database user privileges.
If there was a PHP error happening, such as running out of memory due to a large number of tables and an insufficient memory_limit
, we'd be seeing either a server error page or a completely blank page. You see the rest of Joomla's interface, therefore it's not a PHP error either.
These two deductions are very important because they eliminate two of three possible problems which could lead to something like what you describe. Which leaves us with the third option: a JavaScript issue. Open your browser's dev tools (usually hitting F12 on Windows, or CMD-SHIFT-I on macOS) before clicking on Exclude Database Tables. Go to the Console tab. Clear it. Then click on the Exclude Database Tables. Do you see any error messages there?
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!