Comments (7)
Hi,
Is this available yet? Or what should I do when it fails to build the index? Having a lot of posts and I get 504 timeout
Thank you
from contextual-related-posts.
This isn't available yet. I'll have it in the next version.
You need to run these queries in phpMyAdmin
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);
from contextual-related-posts.
Thank you. I found out that it builds the index after all. It happens this way, I activate the plugin once it times out, I activate the plugin second time it times out again (this all depends on how many posts there are), I activate the plugin 3rd time and it's getting activated then I get the indexes notice and I hit rebuild the index, the index rebuild is done and I don't get the file indexes notice anymore so I assume the index has been built. I open some posts and see the related posts working perfectly so that makes me believe the index is built. I will just run the db queries just to be sure.
By the way how you've been able to make it work with so many posts? Because as you know all the other plugins are glogging when there's many posts involved. The relevancy is absolutely great and the way it works with so many posts it's crazy, so good that I can't believe to be honest.
Many thanks for this plugin
from contextual-related-posts.
It uses mySQL's inbuilt index to do the trick. That's the big part.
The issue I have with this is like you said above regarding time out on activation which is the irritating part, to be honest, in this plugin. My plan is to create a new table in a future version which will be blank on initialisation and then run some cron jobs in the background to pull in the posts in phases. That's the theory. I'm still unsure how to do it in practice!
from contextual-related-posts.
Do you have any idea how can I run those queries without getting 2013 Mysql error connection lost? Tried all suggestions but still getting that error when manually trying to build the index.
Thank you
from contextual-related-posts.
Are you running this in phpMyAdmin? Found this suggestion in the mySQL docs: https://dev.mysql.com/doc/refman/5.6/en/error-lost-connection.html
from contextual-related-posts.
Queries added in: df128c8
from contextual-related-posts.
Related Issues (20)
- Block needs placeholder text HOT 2
- Manual posts selected first
- Validate integers to ensure false is not returned
- Bulk update screen to edit Manual Posts HOT 1
- Posts that match a custom field
- Add new filter crp_query_date_query
- Move link under Tools menu
- Wrap in Disabled blocks
- wp-graphql support HOT 1
- custom placement HOT 1
- Cannot override postid when using echo_crp
- Missing posts when using shortcode with ordering=date HOT 1
- Creating bi-directional manual post connection HOT 2
- Random only widget
- Investigate reusable blocks used outside of the post editing HOT 1
- "Related posts" structure displayed more than once per shown page/post HOT 5
- wp_img_tag_add_loading_attr deprecated
- Use image alt text (with fallback to post title)
- Use get_sites()
- Pick related posts based on ACF field
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from contextual-related-posts.