The MU forums have moved to WordPress.org

w-a-s-a-b-i wasabi related posts plugin (17 posts)

  1. honewatson
    Member
    Posted 18 years ago #

    Hey has anyone managed to get the wasabi related posts plugin working?

    Or any related posts plugin for that matter?

    How about a related posts plugin that gets related posts from all the different blogs on your mu.wordpress?

  2. honewatson
    Member
    Posted 18 years ago #

    I got wasabi related posts plugin working by manually installing the related posts table.

    The plugin won't install the normal way because the table structure is different.

    Instead in phpmyadmin you after clicking on the sql tab you enter this command if you want related posts on the main blog:


    ALTER TABLE
    wp_1_posts ADD FULLTEXT post_related (
    post_name ,
    post_content
    )

  3. mrjcleaver
    Member
    Posted 18 years ago #

  4. quakebum2k
    Member
    Posted 17 years ago #

    anyone figured out how to do that.

    I have very little php programming experience, but I to get it to work...

    We need a piece of code that will grab the current user's table id and replace it in this sql string.

    ALTER TABLE

    wp_posts
    ADD FULLTEXT
    post_related
    (

    post_name
    ,

    post_content

    )

    I moved the menu item to the options tab, but that's all I can do ;(

  5. drmike
    Member
    Posted 17 years ago #

    Someoen got a link to this plugin please? I was just thinking about doing a releated posts plugin.

  6. kp2575
    Member
    Posted 17 years ago #

    Drmike I don't know if you still need this...

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

    I am just trying to figure out how to get this to work

  7. kp2575
    Member
    Posted 17 years ago #

    I did the SQL changes discussed here but I have two problems

    1) There is no menu in the options screen
    2) When I manually go to change the layout they disappear. If I just keep it

    php related_posts

    They show up but five in a row...

    Any ideas?

  8. honewatson
    Member
    Posted 17 years ago #

    Forgot to mention you also need to change the code for each blog if you want it in other blogs:

    ALTER TABLE wp_2_posts ADD FULLTEXT post_related (
    post_name ,
    post_content
    )
    ALTER TABLE wp_3_posts ADD FULLTEXT post_related (
    post_name ,
    post_content
    )

    And so on and so forth. The other way you could do it is hack one of the install new blog files I suppose then you wouldn't need to manually add for each blog.

    How about site wide related posts? That would be cool.

  9. kp2575
    Member
    Posted 17 years ago #

    I was able to add it to different blogs but I still can't edit how it shows up on the site.

    I did install it to the regular plug ins menu.

  10. honewatson
    Member
    Posted 17 years ago #

    Ok usually what I do is go to the plugins menu - where there is a new subtab called "Related Posts Options" next to the "Plugins" subtab below the main menu.

    Click on that then choose the appropriate options.

  11. kp2575
    Member
    Posted 17 years ago #

    I am an idiot, I kept looking under the options page for the plug in information... Thanks for your help.

  12. honewatson
    Member
    Posted 17 years ago #

    You can also set it up so that it automatically installs the related posts required fields in each blog when it set up a new one, here's how:

    1. Open up /wp-admin/upgrade-schema.php
    2. Go to around line 131
    3. Where it says:


    KEY type_status_date (post_type,post_status,post_date,ID)
    ) $charset_collate;

    Add a commer after ',post_date,ID)' then add in the extra line:


    KEY type_status_date (post_type,post_status,post_date,ID),
    KEY post_related fulltext (post_name, post_content)
    ) $charset_collate;

  13. honewatson
    Member
    Posted 17 years ago #

    Also on about line 318 of upgrade-schema.php you can add some more stuff and add some default options:

    add_option('show_on_front', 'posts');
    
    /* Add after the above line around 318 the following */
    
    	add_option('limit', 5);
    	add_option('len');
    	add_option('before_title', '<li>');
    	add_option('after_title', '</li>');
    	add_option('before_post');
    	add_option('after_post');
    	add_option('show_pass_post', 'false');
    	add_option('show_excerpt', 'false');
  14. ladynada
    Member
    Posted 17 years ago #

    thank you all for the help!
    nada

  15. StrategyGalore
    Member
    Posted 16 years ago #

    honewatson:

    How about site wide related posts? That would be cool.

    WP-MU Sitewide Related Posts Plugin is here!

    Good luck!

  16. Ovidiu
    Member
    Posted 16 years ago #

    *cough* Posted 1 year ago #
    I am sure honewatson was impatiently waiting for the solution ;-)

  17. wwsuccess
    Member
    Posted 16 years ago #

    I am getting the following error when I save a post:

    WordPress database error: [Can't find FULLTEXT index matching the column list]
    SELECT MATCH(post_content, post_title) against ('test5') as score FROM wp_posts where id=222;

    I already tried to recreate the FULLTEXT index as follows:

    ALTER TABLE wp_posts ADD FULLTEXT post_related (
    post_name , post_content )

    But when I run it I get the following SQL error:

    #1061 - Duplicate key name 'post_related'

    How do I fix this?

    Thanks,

About this Topic

  • Started 18 years ago by honewatson
  • Latest reply from wwsuccess