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?
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?
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
)
Thanks, have added to http://codex.wordpress.org/WPMU_Plugin_Compatibility
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 FULLTEXTpost_related
(
post_name
,
post_content
)
I moved the menu item to the options tab, but that's all I can do ;(
Someoen got a link to this plugin please? I was just thinking about doing a releated posts plugin.
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
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?
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.
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.
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.
I am an idiot, I kept looking under the options page for the plug in information... Thanks for your help.
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;
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');
thank you all for the help!
nada
honewatson:
How about site wide related posts? That would be cool.
WP-MU Sitewide Related Posts Plugin is here!
Good luck!
*cough* Posted 1 year ago #
I am sure honewatson was impatiently waiting for the solution ;-)
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,