Issue – Optimize database tables

@neotechnomad Can you please try to repair the tables from phpMyAdmin and then try to re-run the optimization and check if it helps to fix the issue?

Else Can you please enable debugging mode, Please add following lines to wp-config.php just before where it says: /* That’s all, stop editing! Happy publishing. */

define( ‘WP_DEBUG’, true );
define( ‘WP_DEBUG_DISPLAY’, false );
define( ‘WP_DEBUG_LOG’, true );

Then try to reload the page again

A debug.log file should be created inside wp-content folder,which should contain error information in it, Please share the file with us.

Thanks,
Harshad

Repair of tables – no change.
No debug log in wp-content directory, only an error log in pulic_html as below:

[14-Aug-2020 11:38:27 UTC] PHP Warning:  Use of undefined constant ‘WP_DEBUG’ - assumed '‘WP_DEBUG’' (this will throw an Error in a future version of PHP) in /home2/mysticsi/public_html/wp-config.php on line 82
[14-Aug-2020 11:38:27 UTC] PHP Warning:  Use of undefined constant ‘WP_DEBUG_DISPLAY’ - assumed '‘WP_DEBUG_DISPLAY’' (this will throw an Error in a future version of PHP) in /home2/mysticsi/public_html/wp-config.php on line 83
[14-Aug-2020 11:38:27 UTC] PHP Warning:  Use of undefined constant ‘WP_DEBUG_LOG’ - assumed '‘WP_DEBUG_LOG’' (this will throw an Error in a future version of PHP) in /home2/mysticsi/public_html/wp-config.php on line 84

Uninstalled plugin and reinstalled – no change.
Replaced WordPress core files – admin, includes, and single file- no change.

First, I uninstalled plugins, themes and WordPress.
Then dropped the entire database.
Did a fresh install of WordPress from scratch.
Installed only WP-Optimize and ran it.
Same result – stalled.

This could be the issue…
I went into phpadmin, selected all 25 tables and ran “optimize”.
In many of the tables the message is: “Table does not support optimize, doing recreate + …”
This is a newly installed server by my hosting service which runs php ea-7.4 (native).

On another site I run, I went to phpadmin and did the same – all the tables were optimized.
This site runs php alt-7.4 but its native is 5.6.

If I changed the site with the issue to alt-74, then I cannot access the site or login and I get the message that WordPress requires ea-74.
When I change this site back to ea-74, I can access the site and login.

This is now beyond my current knowledge base.

…your thoughts?

@neotechnomad Do you have storage engine set to InnoDB? In that can optimize won’t work from phpMyAdmin, you should set the storage engine to MyISAM.

Harshad @bornforphp

Storage engine set to MyISAM.
The plugin? gets stuck on ?’?postmeta?’?.
?I? optimized through cPanel phpAdmin and every table optimized.
Also ran analyze, check, checksum, and repair. Every table fine.
I uninstalled the plugin, optimized tables through cPanel, and reinstalled it.
Still stalls on ‘postmeta’.

Any other suggestions?

The plugin? gets stuck on ?’?postmeta?’?.