500 Internal Server Error on activation of Contextual Related Posts

Hi Carlos,

Do you have a lot of posts on your site? If so, I suspect this is because of the plugins attempt to create a FULLTEXT index which is timing out.

You’ll need to do a bit of a workaround to fix this issue as below.

Step 1: Find /includes/plugin-activator.php and delete these lines:

crp_delete_index();
        crp_create_index();

Step 2: In phpMyAdmin run this query to create the index

Note that you’ll need to change wp_ below with the correct prefix you have.

ALTER TABLE wp_posts DROP INDEX crp_related;
ALTER TABLE wp_posts DROP INDEX crp_related_title;
ALTER TABLE wp_posts DROP INDEX crp_related_content;
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);

In future versions I’ll be adding a bit more options / notices to better handle this on activation which would require an extra step for very large blogs.

Hello Ajay,

thanks a lot.
That was the fix I needed.

Currently looking at the results.
Look nicely as far…

Thanks!
Carlos

Thank you for confirming. Do consider leaving a review of the plugin

I’ll do…just installing on productions server…

Thanks, this also helped me when the plugin took too long to activate.