Not working

Hi @rogeriodec,

That’s strange, specially the fact that the tables are empty.

Would you mind answering those questions to help see where the problem could be:

• Which version of WPO are you using?
• What’s your server config?
• When you say “No error nor log is created.”, does that include php error logs?
• You say: ‘Clicking on button “Run all selected optimizations” it stuck on “Optimize database tables”.’, could you check if there is an error in the javascript console? (open the console before pressing the button). If the spinner is stuck, there’s probably an error somewhere.

Thank you,

Marc

• This reply was modified 5 years, 9 months ago by Marc Lacroix.

Better, I created a Sandbox site you can access (https://sandbox.rogeriodec.com.br/) and you test it. It’s a sandbox, so you can change what you want.

• This reply was modified 5 years, 9 months ago by rogeriodec.

Please note that the forum guidelines forbid to post login access: https://www.ads-software.com/support/guidelines/#the-bad-stuff

You should edit it to remove those informations.

In any case, I can’t access php error logs from the admin.

So could you confirm this:

– When you say “No error nor log is created.”, does that include php error logs?

@rogeriodec This issue happened bacause you have not define $table_prefix = ''; value in wp-config.php. Please, try to set it to the correct value and check again.

To clarify – using an empty table prefix is not supported by WordPress (https://core.trac.www.ads-software.com/ticket/16229), and will cause various bugs.

Just adding one in wp-config.php won’t be sufficient, though – you’ll also need to use phpMyAdmin to edit your table names to add the prefix to them.

I use WordPress for several years and I NEVER used prefixes for tables, since I have an individual database for each site in this way, table prefix becomes unnecessary.

Wordpress works perfectly without table prefixes.
All plugins work perfectly without table prefixes.
Except for WP Optimize.

In fact, by creating a new WordPress installation on https://sandbox.rogeriodec.com.br, using a table prefix, the plugin worked.

This way I see two problems in the plugin:
1) If it really requires prefixes in the tables, it MUST ALERT USER that the plugin will not work without table prefixes.
2) The plugin SHOULD NOT REQUIRE TABLES PREFIXES!

@rogeriodec Thank you, we appreciate your feedback.

I’ve looked into it, and the reason for excluding the tables without prefix to only process tables that belong to the WordPress installation.

To force the optimisation of all your database tables, you can add this filter somewhere, for example in a mu-plugin:

add_filter('wp_optimize_get_tables_include_table', '__return_true');

Now with this code, the plugin is working, as it should.
I leave here the suggestion to remove this limitation in future versions of the plugin.
Thanks for the answer.

I’m reopening this issue because the same problem is occurring with another site.
The environment is the same, ie, I’m not using a table prefix, however, I inserted the suggested code above inside my current child’s theme functions.php.
But for this new site, it’s not working, ie, it gets stuck on “optimize database tables” and also doesn’t show any tables:
Image 1
Image 2

Nevermind, it was my mistake, you can close this post.

• This reply was modified 5 years, 5 months ago by rogeriodec.
• This reply was modified 5 years, 5 months ago by rogeriodec.
• This reply was modified 5 years, 5 months ago by rogeriodec.
• This reply was modified 5 years, 5 months ago by rogeriodec.