503 Error when Creating Index

  • Resolved indyparker

    (@indyparker)


    8 years, 9 months ago

    Hi,

    I am trying to re-create my index and when I try to do this it results in a 503 error on my server.

    My server is using Varnish Caching and my host says your plugin is not compatible with Varnish so you need to help me with the solution.

    I am desperate to create the index, and wonder is there a manual way – even SQL to re-create the index? I can run it in PHPMyAdmin easily.

    Thanks
    Indi

    https://wordpress.org/plugins/contextual-related-posts/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WebberZone

    (@webberzone)

    8 years, 9 months ago

    Hi Indi,

    It is not correct that my plugin isn’t compatible with Varnish, because I use my plugin on several of my sites on my own VPS which I have configured with Varnish.

    It might a more underlying issue with the db and config etc.

    If you can run mySQL via PHPMyAdmin, then you might want to run these three to manually create the index:

    https://github.com/ajaydsouza/contextual-related-posts/blob/master/contextual-related-posts.php#L1124

    ALTER TABLE wp_posts ADD FULLTEXT crp_related (post_title, post_content);
ALTER TABLE wp_posts ADD FULLTEXT crp_related_title (post_title);
ALTER TABLE wp_posts ADD FULLTEXT crp_related_content (post_content);
    Thread Starter indyparker

    (@indyparker)

    8 years, 8 months ago

    Thanks that worked 🙂

    But first you must delete the existing indexes.

    Plugin Author WebberZone

    (@webberzone)

    8 years, 8 months ago

    Thanks for confirming. Seems like they were actually created the first time around!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘503 Error when Creating Index’ is closed to new replies.