WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Yet Another Related Posts Plugin] Database Failure & Cache emty (20 posts)

  1. kiljan
    Member
    Posted 5 years ago #

    After I upgrade the YARPP Plugin today, the plugin doesn´t work anymore. In the Admin Panel i have this 2 messsages:

    Your related posts cache is empty. Please build your cache from the related posts status pane

    Die YARPP-Datenbank hat einen Fehler, der nicht behoben werden kann. (The YARPP Database got an Error, which can not be fixed)

    If I want to build the cache, this message apperars:
    Related posts cache status: 0%
    There was an error while constructing the related posts for

    so, what shall I do, to get this plugin working like befor the upgrade?

  2. MoiMM
    Member
    Posted 5 years ago #

    I have the same problem ! :(

    How desinstall completly YARPP ?

  3. @klijan - Can you check your SQL db to see if there are two tables named wp_yarpp_related_cache and wp_yarpp_keyword_cache? If those two tables are not there, then it looks like your WP db account doesn't have access to create those tables like it needs to. Were you using YARPP 2.1.6 before?

    @MoiMM - to uninstall, just deactive the plugin from the plugin settings page and then remove the folder from the server.

  4. MoiMM
    Member
    Posted 5 years ago #

    Thx for your quick answer (and sorry for my bad english ! ;)

    I have see my SQL db ... and i don't see the two tables !

    For info > I have used YARPP 2.1.6 before !

    :)

  5. kiljan
    Member
    Posted 5 years ago #

    @mitchoyoshitaka: thanks for you reply. Yesterday i have try about two hours to get this plugin working like before. with no result.

    Then i have decided to delete it. i have deactivate the plugin und remove the folder. After that i have search via mysql for yarpp and it show me some tables with yarpp. i have deleted this tables an i hope this was right.

  6. @kiljan - sorry it didn't work out with your setup. The 2.1.6 is still available for download.

    @MoiMM - if you look at the HTML source of the YARPP options screen, do you see a couple lines of HTML comments like <!--YARPP error: ... -->? This is some debug information which may help figure out what went wrong. Do you know if the db user WP is using has access to create new tables or not?

  7. MoiMM
    Member
    Posted 5 years ago #

    @mitchoyoshitaka

    Sorry, i don't know if the db user Wp use a access to create new table ?
    How i can to know it ?

    Maybe i can create the table manually, if you say me what i must to do (i'm noob in db manipulation !! :D ;) )

    I go to read your html comment in the HTML source ! :)

  8. MoiMM
    Member
    Posted 5 years ago #

    mitchoyoshitaka ... i don't find your <!--YARPP error: ... -->? html comments ?

    Where i can find it ? In the code source of a file (i have open many php files and find nothing :( )

  9. Laws
    Member
    Posted 5 years ago #

    I have the same problem as MoiMM.
    The tables are missing in the db. Other plugins have created tables so the db user should have sufficient access.
    The HTML source of the options pages does not include any YARPP errors but there are 4 MySQL errors:

    <!--MySQL-Fehler beim Hinzufügen von "yarpp_title": --><!--MySQL-Fehler beim Hinzufügen von "yarpp_content": --><!--MySQL error on creating yarpp_keyword_cache table: --><!--MySQL error on creating yarpp_related_cache table: -->

    Firebug also throws this:
    Access to restricted URI denied" code: "1012
    [Break on this error] eval(function(p,a,c,k,e,r){e=function(c)...

    I don't even know if this is related ;)
    I'd really appreciate a fix for this problem.

  10. nobo
    Member
    Posted 5 years ago #

    I am having the same problem.

    I installed the latest version of the Yarpp plugin (3.0.4)on my WordPress Blog(latest version 2.7.1).

    Unfortunately on the Yarpp Options page I get an error message indicating that the Yarpp database cannot be fixed. When I attempt to set the yarpp cache the process stops almost immediately and I also get an error message. When I look at the WordPress
    database I do not see the Yarpp tables that should have been installed.

    I am wondering whether anyone has a possible fix for this problem. I have seen this plugin working on other blogs and I think it is great. I am very keen to get it running on my own blog.

    Many thanks.

  11. karoshi2
    Member
    Posted 5 years ago #

    I have the same problem. I assume that this error is due to an older version of MySQL. I don't think the create statements are compatible with MySQL 4.0 (I have that in use). Creating the tables by hand (after removing certain utf8-settings and current_timestamp) worked for creating the cache, but not for using it. I stopped there and took the latest version.

  12. MoiMM
    Member
    Posted 5 years ago #

    I have try the last version (3.0.4) ... but it's again the same problem !

    I have re-install the 2.1.6 version and now that work normaly !?!

    I don't know why ... but i have find only this solution for that work ... :?

    :)

  13. Hi all— I've decided I'm going to make a page on my YARPP site which lists the SQL queries to be run in case the automatic queries don't run (for example, if your WP database user doesn't have the right permissions). I'll post a link when it's up.

  14. Hi all— here's the list of the SQL queries required for YARPP installation:

    http://mitcho.com/code/yarpp/sql.php

  15. funkster
    Member
    Posted 5 years ago #

    Mitch.
    Thanks for your last post but for those of us who have absolutely no idea what those instructions mean or how to implement them, can you offer some alternative advice?

    I have both the wp_yarpp_keyword_cache and wp_yarpp_related_cache tables visible but get the cache build gets interrupted at 48.4% everytime I try to build the cache. I get the following message; "Constructing the related posts timed out."

    The plugin is still visible on my pages, see an example .. http://www.gadget-blog.co.uk/gaming-consoles/sony-playstation-ps3-slim/

    .. but I don't know how effective it is.

    Appreciate any help.

  16. @funkster - are you actually getting the "there was a database error that could not be fixed" message from YARPP?? That's what those instructions are for. If you are able to build the cache (even partially) then you most likely have no need for the manual SQL setup.

    If you're having trouble completing the cache, I recommend you simply keep the "on the fly" caching option on. Over time it will naturally build up your cache and there should be no need for you to manually build it.

  17. kiljan
    Member
    Posted 5 years ago #

    i have executed the 4 queries from your website, but i get errors to all of the 4 queries. it is something like this:
    #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_unicode_ci NOT NULL,
    title text collate utf8_

    what do i have to do?

  18. @kiljan what version of MySQL are you running? YARPP requires MySQL 4.1.

  19. Flector
    Member
    Posted 4 years ago #

    I have mysql 4.0.27 ((

  20. @Flector - YARPP requires MySQL 4.1. You will need to upgrade if you want to use YARPP.

Topic Closed

This topic has been closed to new replies.

About this Topic