Hi,
Could you please let me know how many posts do you have on your site? I have a feeling the Alter table on activation is timing out.
You could try one thing temporarily and run this on my mySQL database:
Edit “includes/plugin-activator.php” and comment out/ delete these lines:
crp_delete_index();
crp_create_index();
And, then run this in phpMyAdmin
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);
Hello,
I have over 7000 articles. This could be a reason ?
Thank you
Unfortunately, I think this is the case. I’ve been doing quite a bit of research with respect to this. Generating the initial fulltext index with a lot of posts is a mySQL intensive action and consequently a PHP intensive action which has the potential of breaking down on large sites because the PHP times out.
I’ve simulated this on 4000+ posts and it takes a good while to run the queries. My ultimate aim to test on 25k+ posts.
You usually don’t have this issue if you’re running the queries via phpMyAdmin directly from your control panel.
A potential solution for this is to be able to edit your PHP configuration and increase the amount of memory PHP can use as well as the timeout of PHP scripts, but this needs ability to edit the server config files.
However, I think an easier solution is in my previous post i.e. of running the queries via phpMyAdmin of your control panel.
