@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’.
