Support » Plugin: WP-Optimize - Clean, Compress, Cache. » Issue – Optimize database tables

  • Resolved neotechnomad

    (@neotechnomad)


    The plugin gets stuck on “Optimize database tables” at various places, usually “Optimizing Table: XXXXXXX_options”.
    It just sits and spins and does not stop.
    Refreshing browser and running again still sticks on this or some other function.
    PHP is 7.4.
    Investigate please.

    • This topic was modified 8 months, 1 week ago by neotechnomad.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Harshad

    (@bornforphp)

    @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

    Thread Starter neotechnomad

    (@neotechnomad)

    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.

    Thread Starter neotechnomad

    (@neotechnomad)

    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?

    Plugin Support Harshad

    (@bornforphp)

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

    Thread Starter neotechnomad

    (@neotechnomad)

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Issue – Optimize database tables’ is closed to new replies.