Posted 3 years 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 http://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 3 years ago #
Hi,
is your table wp_posts has the engine MyISAM (you can check this in phpmyadmin)?
Posted 3 years 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 3 years 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 3 years ago #
I tried just upgrading the plugin, but deactivating and reactivating did the trick. Thanks!
Posted 3 years 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 3 years ago #
@hugin, execute this request on phpMyAdmin:
ALTER TABLE wp_posts ADD FULLTEXT post_related (post_title, post_content);
Posted 3 years ago #
Got hit with an error:
#1061 - Duplicate key name 'post_related'
Posted 2 years 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.
