I am having the very same issue: “Unfortunately your table seems to be using the 1 engine.” Engine is MyISAM. And as far as I know, there is no such thing as a “1” database engine.
On the table I executed, “ALTER TABLE wvgabj_posts ADD FULLTEXT post_content , post_title )”, but it did not fix it.
Thread Starter
Lock
(@locksoft)
Well, I guess this plugin is abandoned by now…
Hi
I have installed YARP but the posts are not showing up in pages. How to resolve this? please help
spiritualsadhana
I have the same problem, the table wp_post has been converted to MyISAM but i still cannot enable the feature, i guess plugin has been abandoned, it’s sad cause it’s by far the best related posts plugin!
found my issue, was a issue with my mysql user not having alter permissions in that db, doh!
Thank you for reporting that, Jeriksson. But unfortunately, my db user already had the alter privilege, so it is not a fix for me.
it’s sad cause it’s by far the best related posts plugin!
Not anymore, apparently. I’ve switched to a different ‘contextual related posts’ (hint) and it displays related posts much nicer than YARPP did. I’m glad YARPP failed and prompted me to switch.
Thread Starter
Lock
(@locksoft)
I’m trying Contextual Related Posts but it seems I’m having the same problem. Can’t create FULLINDEX.
Jeriksson, how did you solve your permissions problem?
Thread Starter
Lock
(@locksoft)
Oh, nevermind, solved.
I had to enable ALTER privilege in my user. 🙂
Hey,
I also had the same problem, but fixed with :
MariaDB [database]> drop index yarpp_title ON wp_posts;
Query OK, 6983 rows affected (0.31 sec)
Records: 6983 Duplicates: 0 Warnings: 0
MariaDB [database]> drop index yarpp_content ON wp_posts;
Query OK, 6983 rows affected (0.12 sec)
Records: 6983 Duplicates: 0 Warnings: 0
Then click the fullindex button from the plugin, and all looks good now! 🙂
@friendbg the drop index solution worked for me too, thanks!
after dropping indexes YARPP was able to create indexes again successfully – and we now again have related posts – yay!
Thanks!
