WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Popular Posts
Popular Posts crashing mysql (5 posts)

  1. ThecounT
    Member
    Posted 5 months ago #

    HI. I love this plugin. Unfortunately it started crashing mysql. Sorry if this topic has been covered but I don't know where to look to find it.

    Here is what my guy at managed hosting told me:

    "it seems that there is a specific MySQL query that is causing the issue:

    DELETE FROM wp_popularpostsdatacache WHERE id IN (SELECT c.id FROM (SELECT id FROM wp_popularpostsdatacache GROUP BY id) c LEFT JOIN wp_posts p ON c.id = p.ID
    WHERE p.ID IS NULL OR p.post_status = 'trash')

    This query seems to be generated by the "WordPress Popular Posts" plugin. Disabling the plugin should fix the issue. Alternatively, you should be able to fix the issue by converting the affected tables to innodb:

    http://dev.mysql.com/doc/refman/5.0/en/table-locking.html
    http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html

    ADDING IN A FOLLOW UP: I don't suggest you switch to InnoDB as it can cause major database corruption and therefor downtime at any moment for any reason."

    --END---

    These guys won't help past this point. If someone can point me in right direction that would be great. I don't do much database stuff, but I have in the past. I hope this is something I can fix! I don't want to delete this! Thanks.

    https://wordpress.org/plugins/wordpress-popular-posts/

  2. ThecounT
    Member
    Posted 5 months ago #

    Hello? Please help.

  3. simonlindner
    Member
    Posted 4 months ago #

    what exactly do you mean by "crashing"? is there an error message or so?

  4. ThecounT
    Member
    Posted 4 months ago #

    I posted the error messages above?

  5. Héctor Cabrera
    Member
    Plugin Author

    Posted 3 months ago #

    Hi ThecountT,

    Sorry for the late reply. Another user also reported this issue, click here to see my response.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.