Yoast SEO
Too many rewrites causing mysql to crash (3 posts)

  1. ecx
    Posted 3 years ago #

    Your plugin seems to faithfully create 2 (or more) rewrite rules per category which results into a large number of rewrite rules. I have created over 600 categories, and have selected 'remove the "category" slug.' Also, I'm not using any tags.

    With DEBUG turned on I get this error, which seems to be a massive list of rewrite rules that exceeds a mysql limit???

    WordPress database error: [Cannot put record into object 19 because
    its size 194481 is greater than 131036.]

    With debug turned off, your plugin/rewrites seem to work OK until I moved server into production. With a large number of rewrite hits I got this in my error.log. which brings down WordPress (or slows everything down to a crawl).

    [Wed Nov 14 18:48:58 2012] [error] [client] PHP Catchable fatal error: Object of class WP_Error could not be converted to string in .../wp-content/plugins/wordpress-seo/frontend/class-frontend.php on line 705


  2. ecx
    Posted 3 years ago #

    My question is basically can the rewrite logic be rewritten to account for large category hierarchies?

  3. ecx
    Posted 3 years ago #

    Still hoping for a resolution. I now get this error occasionally and can't figure out why?

    Fatal error: Call to a member function add_query_var() on a non-object in .../wp-content/plugins/wordpress-seo/inc/wpseo-functions.php on line 314

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Yoast SEO
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic