Posted 1 year ago #
I'm having trouble getting the Landing Sites plugin to display matching posts. I've inserted the suggested PHP in my theme and it displays text when navigating to my site from Google, but it doesn't match any posts. Any ideas on what I can do to track this down?
For an example, go to www.google.com, search for dvdspot, then find a match that takes you to dpotter.net (should be the 8th match).
http://www.google.com/search?hl=en&q=dvdspot
Thanks,
David
Posted 1 year ago #
Hi,
is your table wp_posts has the engine MyISAM (you can check this in phpmyadmin)?
Posted 1 year ago #
No, it's InnoDB. Also, in case it makes a difference, it's not called wp_posts, it's called david_technical_posts.
Posted 1 year ago #
Download the new version 1.4.1 then re-activate it, this will automatically convert your table to MyISAM, and it will work ;)
The table name is ok, don't change it.
Posted 1 year ago #
I tried just upgrading the plugin, but deactivating and reactivating did the trick. Thanks!
Posted 11 months ago #
I cant get 1.4.1 to work. The old 1.3 works just fine, but 1.4.1 gives me the fulltext error.
My wp_posts is MyISAM, and reactivating the plugin doesn't help either. Any ideas?
I could just carry on with 1.3, but it's quite annoying when WP flags the plugin for available update.
Posted 11 months ago #
@hugin, execute this request on phpMyAdmin:
ALTER TABLE wp_posts ADD FULLTEXT post_related (post_title, post_content);
Posted 11 months ago #
Got hit with an error:
#1061 - Duplicate key name 'post_related'
Posted 4 months ago #
@hugin if you still have the problem, I have found the solution:
check out in phpMyAdmin the wp_posts table and scroll down to "Indices".
Find the line "post_related".
In my case "post_title" was named "post_name". I changed it manually to post_title and tada - it worked.
This topic has been closed to new replies.
