WordPress.org

1. DSHEPHERD
   Member
   Posted 4 years ago #
   

   Hi

   Thanks firstly for putting together one of the best plugins. Since moving servers I've been getting database errors on the sites on my server:

   - http://www.connectedinternet.co.uk
   - http://www.windows7news.com
   - http://www.onetipaday.com
   - http://www.gospelmusicbites.com

   Do you have any ideas how I can fix? Or is there a way I can delete the old databases so that the plugin can rebuild the relevant tables and 'start again'?

   thanks

   http://wordpress.org/extend/plugins/yet-another-related-posts-plugin/

2. mitcho (Michael Yoshitaka Erlewine)
   Member
   Posted 4 years ago #
   

   @DSHEPHERD - I'm not seeing any errors...

   If you'd like to "start again", try dropping the yarpp_content and yarpp_title indexes on your wp_posts table and then going to the YARPP settings page in your WP settings, which will rebuild those indexes.

   Otherwise, the latest version of YARPP has a debug mode (add ?yarpp_debug=1 to your URL with any caching plugins off) which will print the SQL query that's being run in a HTML comment. You can try running that query directly in your database to see what error it gets (if any). If that's the problem, please print the SQL query here with the error message, or email me with it.

   Thanks for the report!

3. DSHEPHERD
   Member
   Posted 4 years ago #
   

   Hi

   Thanks for getting back to me. I tried deleting the indexes but the errors are still coming up:

   http://www.gospelmusicbites.com/2008/11/06/sean-simmonds-a-alumni-of-oakwood-college-new-project-its-over-in-stores-september-23rd/

   I tried doing http://www.gospelmusicbites.com/2008/11/06/sean-simmonds-a-alumni-of-oakwood-college-new-project-its-over-in-stores-september-23rd/?yarpp_debug=1 but I can't get the SQL query to show up.

   Thanks

4. mitcho (Michael Yoshitaka Erlewine)
   Member
   Posted 4 years ago #
   

   @DSHEPHERD - The SQL query is right there, about halfway down the source. The problem here is that the keywords aren't being constructed correctly... are you by chance running WP 2.7b2? I've received a report which told me that this was happening to them...

   I'll try to build a fix to this and post the link to the new debug version for you. If you email me I'll be able to send you the code directly.

5. mitcho (Michael Yoshitaka Erlewine)
   Member
   Posted 4 years ago #
   

   @DSHEPHERD - thank you so much for your cooperation!

   For others following this thread, please try this development version which has the fix. It will be rolled into the upcoming 2.1.4 release.

Topic Closed

This topic has been closed to new replies.