CRP not displaying any posts

  • Resolved beggers

    (@beggers)


    5 years, 5 months ago

    Long time no talk, Ajay! I finally got around to building a new website. I’m using Using the same CRP settings as on VegasNews.com (with one exception) but I can’t get it to display anything on my new site at https://www.MovieDebuts.com .

    The only difference is that on the old site I inserted the PHP code into the template. I’m not familiar with the new template so I’d like to avoid changing it at this point. I just selected “POSTS” to have it display at the end of each post.

    Note that at this point it won’t even say “No related posts”. However, the meta box does appear at the end of the article entry screen.

    Now admittedly, this new site has only 38 posts but there is long text on each. Could it be that CRP really isn’t finding any matches? I tried telling it to consider the content but still no matches.

    As a final attempt I tried dragging your widget into the “After Entry” spot and it only displayed the title “Related Posts” but also no matches.

    I am using the StudioPress theme called “Magazine Pro”.

    Both of my sites are running on the same server.

    I installed Top Ten and it works fine.

    One note is that the database prefix is different on the new site.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ajay

    (@ajay)

    Bryan,

    Can you try using the meta box to enter a few post IDs under the manual posts option to see if that works?

    Also, are you able to check your database to see a) what version of mySQL are you running and b) if this is old – i.e. pre 5.7 if the table is myISAM and not innoDB.

    Thread Starter beggers

    (@beggers)

    I was able to manually add a couple posts to an article.

    I’m running mySQL 5.5. There is an option to upgrade to Mariah 10. but it’s beyond me. I’ll have to pay the host to do it for me if this is the issue.

    As a side note, I’m getting this error in the log which I suspect might be related to the problem:

    Got error 'PHP message: WordPress database error The used table type doesn't support FULLTEXT indexes for query SELECT DISTINCT 7k4MD6qU_posts.ID, 7k4MD6qU_posts.post_date FROM 7k4MD6qU_posts WHERE 1=1 AND MATCH (post_title,post_content) AGAINST

    Plugin Author Ajay

    (@ajay)

    I suggest upgrading to Maria 10 which is supposed to be faster. 5.5 is quite outdated and innoDB which would be the default engine doesn’t support FULLTEXT in that version.

    You could, for now, convert the wp_posts table to myISAM but please backup as always before running this.

    ALTER TABLE wp_posts ENGINE = MyISAM;

    Change the wp to the other prefix.

    Thread Starter beggers

    (@beggers)

    Thanks as always, Ajay.

    I upgraded to Mariah 10 and altered the table as you suggested. Everything works fine now!

    Bryan

    Plugin Author Ajay

    (@ajay)

    Bryan,

    That’s good to hear.

    If you’re on Maria 10, you can change it back to innoDB – it’s faster and more secure – but does give different set of related posts.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘CRP not displaying any posts’ is closed to new replies.

Tags