[wp-trac] [WordPress Trac] #10798: _transient_rewrite_rules can get too long causing MySQL error
WordPress Trac
wp-trac at lists.automattic.com
Wed Sep 16 16:17:16 UTC 2009
#10798: _transient_rewrite_rules can get too long causing MySQL error
--------------------------+-------------------------------------------------
Reporter: mark8barnes | Owner:
Type: defect (bug) | Status: new
Priority: normal | Milestone: Future Release
Component: General | Version: 2.8.4
Severity: minor | Keywords:
--------------------------+-------------------------------------------------
On large sites, particularly with the permalink set to /%postname%/
_transient_rewrite_rules can get too long, causing the "MySQL server has
gone away" error message.
`WordPress database error: [MySQL server has gone away]
INSERT INTO wp_options (option_name,option_value,autoload) VALUES
('_transient_rewrite_rules','a:7526:{s:12:\"robots\\.txt$\";s:18:\"index.php?robots=1\
etc.`
Once this occurs, functionality is severely disrupted until the permalink
settings are changed.
I guess the easiest fix might me be to split the data in two, and store it
in two rows.
--
Ticket URL: <http://core.trac.wordpress.org/ticket/10798>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software
More information about the wp-trac
mailing list