WordPress.org

Ready to get started?Download WordPress

Forums

how to make related posts work? (7 posts)

  1. canonpower
    Member
    Posted 7 years ago #

    i installed the related posts plugin

    http://wasabi.pbwiki.com/Related%20Entries

    i activated the plugin. it shows

    "If this is your first time installing this plugin you will have to run this script (opens a new window) in order to create the index table required by the plugin. If this fails, please refer to the readme on how to create it manually."

    since this is the first time i am installing this plugin and the automatic creation of a full text index fails. i donot know what to do now.

    in the readme file they have given that

    If automatic creation of a full text index fails. You will have to set it up manually. Don't worry it's not hard. Just open your database in phpMySQLadmin and run the following command (cut & paste):

    ALTER TABLE wp_posts ADD FULLTEXT post_related (
    post_name ,
    post_content
    )

    Note: You may have to change wp_posts to something else if you are using a different prefix, which is common when you have multiple WP installs running of the same database.

    Now I don't know what to do. Kindly help me.

  2. Nevis1
    Member
    Posted 7 years ago #

    I have the same problem. Nobdy seems to know what to do.

  3. Chris_K
    Member
    Posted 7 years ago #

    So the directions tell you both exactly what to do:

    Just open your database in phpMySQLadmin and run the following command (cut & paste):

    ALTER TABLE wp_posts ADD FULLTEXT post_related (
    post_name ,
    post_content
    )

    Note: You may have to change wp_posts to something else if you are using a different prefix, which is common when you have multiple WP installs running of the same database.

    Which part did you give up at?

  4. Nevis1
    Member
    Posted 7 years ago #

    The part about opening your database. Where do I cut and paste the text into? I have the database open in phpMySQLadmin but I don't see any place to "run" any command. Sorry but I don't really get this MySQL stuff. All of my other plugins just installed and then I configured them from dashboard. I wish ther was a more detailed explantion for us PHP and MySQL challenged people. Thanks for any help you can provide.

  5. Chris_K
    Member
    Posted 7 years ago #

    If you've logged into phpMyAdmin, select your database from the pulldown on the left side.

    After login, across the top right section are some tabs. Click the "SQL" tab.

    Paste in that query given above.

    Click "Go"

  6. Nevis1
    Member
    Posted 7 years ago #

    Thanks for getting back to me. Tried what you suggested and received this error

    SQL query:

    ALTER TABLE wp_posts ADD FULLTEXT post_related(

    post_name,
    post_content
    )

    MySQL said:

    #1061 - Duplicate key name 'post_related'

  7. Chris_K
    Member
    Posted 7 years ago #

    Well huh, that makes it sound like the first time run was able to do that already.

    Have you tried adding the plugin's tag to your theme to see if it works?

Topic Closed

This topic has been closed to new replies.

About this Topic