Mysql was stacking up crashed site after activating

  • I installed and activated this plugin which caused an issue with mysql stacking up which ended up crashing the site. I tested on a staged site for this site and it worked seamlessly so I’m not sure what’s causing this issue.

    Here’s an example query. 

    SELECT tr.object_id, tr.term_taxonomy_id FROM wp_term_relationships AS tr INNER JOIN wp_posts ON object_id = wp_posts.ID  LEFT JOIN wp_term_relationships AS ppma_tr ON ppma_tr.object_id = wp_posts.ID LEFT JOIN wp_term_taxonomy AS ppma_tt ON ppma_tt.term_taxonomy_id = ppma_tr.term_taxonomy_id AND ppma_tt.taxonomy = 'author' LEFT JOIN wp_terms AS ppma_t ON ppma_t.term_id = ppma_tt.term_id AND ppma_t.slug = '' WHERE tr.term_taxonomy_id IN

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Kevin Behrens

    (@kevinb)

    @crystaltm That example query is actually coming from the PublishPress Authors plugin. Does this error still occur if you deactivate Authors?

    What if Authors is activated, but not Permissions?

    Thread Starter Crystal Torres-Martinez

    (@crystaltm)

    @kevinb So the error only occurs on the live site and it relies on PublishPress Authors for some functionality so I won’t be able to deactivate it. It doesn’t occur without the Permissions plugin. It only happens after activating Permissions, so we believe it is related to the Permissions plugin. I’m testing out the Capabilities plugin today on the live site to see if the same issue occurs.

    Also, I tested both Permissions and Capabilities on a staged version of this site, and it worked well without issues with the Authors plugin installed.

    Does the Permissions plugin work with the Authors plugin? They are both from PublishPress so I would assume they should work well together..

    Plugin Author Kevin Behrens

    (@kevinb)

    @crystaltm Were there also other types of queries showing up excessively in the log?

    Thread Starter Crystal Torres-Martinez

    (@crystaltm)

    I tried PublishPress Capabilities and didn’t get any issues. Not sure what the issue was with PP Permissions, but I’m calling this done.

    Thank you for the help!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Mysql was stacking up crashed site after activating’ is closed to new replies.