• Resolved splaquet

    (@splaquet)


    just an fyi, but had this error pop up on me:
    PHP Parse error: syntax error, unexpected '}' in /public_html/wp-content/plugins/index-wp-mysql-for-speed/code/admin.php on line 237

    Also wanted to note, I’ve received timeouts on the first few sites that I tried this plugin on. Finally able to test this bad boy out now! ??

    • This topic was modified 2 years, 11 months ago by splaquet.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author OllieJones

    (@olliejones)

    The timeouts are truly a problem, especially on budget hosting services. Try using wp-cli, or try adding the keys to one table at a time.

    There’s a new version of the plugin coming soon that should help with this timeout problem: it handles the rekeying more efficiently.

    As far as the syntax error goes, it’s baffling. Do you always get it? If not, could you please upload your metadata from the About tab on the Tools > Index MySQL page?

    And maybe send me a copy of the offending admin.php file on oj (at) plumislandmedia (dot) net?

    Thanks for your patience.

    • This reply was modified 2 years, 11 months ago by OllieJones.
    Thread Starter splaquet

    (@splaquet)

    I’m actually using my own server, so it’s essentially uncapped resources. The main problem I faced was that I’m using CloudFlare, which was where the GUI timeout came from.

    Also, I did first see this issue while using CLI. I was running wp plugin update –all when it first presented itself.

    Oddly, it seems inconsistent. If I use a combination of the GUI & CLI, I’ve been able to reach the confirmation “performance keys in place”.

    Also, the package that I installed was the latest from WP plugin repo. On both sites, I ran: wp plugin install index-wp-mysql-for-speed –activate

    These two experiences were on a LiteSpeed Ent server. Shouldn’t really matter, but worth noting.

    Another try was on an a high performance Kinsta Nginx VPS server… and that pretty much locked up the VPS and gui. I couldn’t move forward on that one and removed the plugin.

    I’ll shoot you over the file via email now.

    thank you for your prompt response!

    • This reply was modified 2 years, 11 months ago by splaquet.
    Plugin Author OllieJones

    (@olliejones)

    Aha, Cloudflare… Something to add to my ever-growing test matrix. Thanks for your ongoing patience.

    Plugin Author OllieJones

    (@olliejones)

    There’s a new version of the plugin 1.4.1. It should be quite a bit faster at rekeying big tables.

    At any rate, please use wp-cli to do your big tables if you possibly can.

    wp index-mysql enable wp_postmeta

    for example. wp-cli isn’t quite so eager to time out.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘syntax error, unexpected ‘)’ in admin.php, line 237’ is closed to new replies.