Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug with 3 letter words #118

Closed
ajaydsouza opened this issue Dec 19, 2024 · 0 comments
Closed

Bug with 3 letter words #118

ajaydsouza opened this issue Dec 19, 2024 · 0 comments
Assignees
Labels
Milestone

Comments

@ajaydsouza
Copy link
Contributor

When the search term uses 3 letter terms, the plugin throws an error: Unknown column 'score' in 'order clause'

Example query:

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*,wp_posts.ID as ID
FROM wp_posts
WHERE 1=1
AND ( wp_posts.post_date <= '2024-12-19 21:13:23' )
AND (((wp_posts.post_title LIKE '%igg%')
OR (wp_posts.post_content LIKE '%igg%'))
AND ((wp_posts.post_title LIKE '%iga%')
OR (wp_posts.post_content LIKE '%iga%')))
AND (wp_posts.post_password = '')
AND wp_posts.post_type IN ('page', 'post', 'wz_knowledgebase')
AND ((wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'inherit'))
ORDER BY score DESC
LIMIT 0, 10
@ajaydsouza ajaydsouza added the bug label Dec 19, 2024
@ajaydsouza ajaydsouza added this to the 4.0.4 milestone Dec 19, 2024
@ajaydsouza ajaydsouza self-assigned this Dec 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant