Support » Plugins and Hacks » how to make related posts work?

  • 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.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Nevis1

    (@nevis1)

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

    Chris_K

    (@handysolo)

    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?

    Nevis1

    (@nevis1)

    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.

    Chris_K

    (@handysolo)

    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”

    Nevis1

    (@nevis1)

    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’

    Chris_K

    (@handysolo)

    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?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘how to make related posts work?’ is closed to new replies.