No Related Post Found

  • Resolved Rajibul Islam

    (@rajibms)


    4 years, 5 months ago

    Hi,
    I have installed the plugin and set it properly but not showing any related posts. If I set post id in the meta box then it shows but otherwise no related post/empty related post.

    My Database Table Type is InnoDB and uses shared hosting.

    I found the following error from the log.

    “WordPress database error Can’t find FULLTEXT index matching the column list for query SELECT”

    Please help me solve this error.

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Rajibul Islam

    (@rajibms)

    4 years, 5 months ago

    Additional information: I check my server information and found this,
    MySQL Version 10.3.32-MariaDB

    Plugin Author Ajay

    (@ajay)

    4 years, 5 months ago

    @rajibms

    Is this a fresh install and can I check which host you’re on?

    You can regenerate the index via the Tools page. The link is on the settings page.

    If that doesn’t work, you would need to run the queries via phpMyAdmin. Note that some hosts might not allow FULLTEXT indices.

    If that is the case, an alternative solution that might work is to disable the FULLTEXT option under list tuning and turn on the various category/tags option

    Thread Starter Rajibul Islam

    (@rajibms)

    4 years, 5 months ago

    Thanks for your reply.

    Yes, it was a fresh install and the first time on this website. As far as I know, my server is Litespeed and also I am using Litespeed Cache Plugin.

    Server info:
    Apache Version 2.4.52
    PHP Version 7.2.34
    MySQL Version 10.3.32-MariaDB
    Architecture x86_64
    Operating System Linux

    Also, I have tried to disable, Uninstall and install again but did not work.

    I did not notice the tools page but after your mention, I check it and tried to create indices, and its show indices were created but not work in the related post and still error log shows “WordPress database error Can’t find FULLTEXT index….”

    In this case, how can I know that my host is allowing or not FULLTEXT indices?

    Also, I want to troubleshoot if you guide me please,

    How can I run queries via phpMyAdmin? (I can see Database tables in phpMyAdmin)

    I don’t use any tag on my website, How can I disable the FULLTEXT option and use Category options to display related posts?

    Another information: I am currently using Yet Another Related Post and it’s working fine, but I want to use CRP shortcode to display related posts. I have also disabled YARPP and tried CRP but did not work for me.

    Plugin Author Ajay

    (@ajay)

    4 years, 5 months ago

    For disabling contextual match > List tuning tab:
    Turn on Disable contextual matching
    Turn off ONLY on attachments.

    In terms of phpmyadmin: Tutorial here -> https://www.siteground.co.uk/tutorials/phpmyadmin/query/
    Same concept irrespective of your host.

    The query to run is in the Tools page below the recreate indices you’ll see the queries to run.
    https://ps.w.org/contextual-related-posts/assets/screenshot-10.png?rev=2452385

    Thread Starter Rajibul Islam

    (@rajibms)

    4 years, 4 months ago

    I disabled the plugin for a few days and enable then it started working fine.

    I think it will work fine continuously.

    Thanks for your effort.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘No Related Post Found’ is closed to new replies.