WordPress database error Got a packet bigger than ‘max_allowed_packet’

  • Gloria

    (@erfo)


    16 years ago

    Hi.
    In Error log of my site, I see lots of these errors “WordPress database error Got a packet bigger than ‘max_allowed_packet’“.
    Now, in the .htaccess file, I add this code:

    php_value memory_limit 64M
php_value upload_max_filesize 32M
php_value post_max_size 32M

    But the errors there are yet…

    The following code is a bit error:
    WordPress database error Got a packet bigger than 'max_allowed_packet' bytes for query INSERT INTOwp_options(option_name,option_value,autoload) VALUES ('rewrite_rules', 'a:7212:{s:12:\\"robots\\\\.txt$\\";s:18:\\"index.php?robots=1\\";s:14:\\".*wp-atom.php$\\";s:19:\\"index.php?feed=atom\\";s:13:\\".*wp-rdf.php$\\";s:18:\\"index.php?feed=rdf\\";s:13:\\".*wp-rss.php$\\
    [continues…]

    When I see the database, I don’t find “rewrite rules” in “option_name”…

    How to resolve?

Viewing 6 replies - 1 through 6 (of 6 total)
  • Shane G.

    (@shane-g-1)

    16 years ago

    Hi,

    You can do it either from shell access or contact your hosting service provider to increase the MySQL packet limit.

    Refer this article for that:

    http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

    Thanks,

    Shane G.

    byronrode

    (@byronrode)

    16 years ago

    Erfo,

    Check that there are no duplicate rules in the .htaccess file. There should be the standard rules, and then add you rules within the <IfModule> wrapper below the standard WP rewrite rules.

    Cheers,
    Byron

    Thread Starter Gloria

    (@erfo)

    16 years ago

    @shane G.
    I set these rules in .htaccess file, is it ok?

    @byronrode

    In my .htaccess file I have this:

    # BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]

# Options +FollowSymlinks
RewriteCond %{HTTP_REFERER} cnzz\.cn [NC,OR]
RewriteCond %{HTTP_REFERER} qq829\.com [NC]
RewriteRule .* - [F]

php_value memory_limit 64M
php_value upload_max_filesize 32M
php_value post_max_size 32M

redirect 301 "/example" http://site.it/page/example
redirect 301 "http://site.it/example1" http://site.it/page/example1
# I have another redirect 301

</IfModule>

# END WordPress

    What’s wrong?

    Thanks to both

    Thread Starter Gloria

    (@erfo)

    15 years, 12 months ago

    Have you any solution?

    byronrode

    (@byronrode)

    15 years, 11 months ago

    Hi Erfo,

    Apologies for the delay. Been a bit hectic.

    As far as I know, the problem I came across was using the redirect method

    redirect 301 "/example" http://site.it/page/example
redirect 301 "http://site.it/example1" http://site.it/page/example1
# I have another redirect 301

    you should rather change those to a RewriteRule

    Thanks,
    Byron

    sammyb

    (@sammyb)

    15 years, 11 months ago

    Hi Erfo

    ‘max_allowed_packet’ is a mySQL setting and has nothing to do with .htaccess. it defines the maximum size of any data packet that can be written to a single field in your mysql databse.

    the rewrite_rules refered to in the error are a row in the wp_options table of the wordpress database. WordPress uses these rules to generate the ‘pretty permalinks’ when using a custom permalink structure such as /%category%/%postname%.

    When you create a new page in wordpress extra rules are added to the array of rewrite rules in your database. More pages = more rewrite_rules

    what is happening here is that the number of rewrite rules created by your site is larger than the max_allowed_packet size as set in the mysql configuration on your server.

    Here’s some info on how to increase the max_allowed_packet:
    http://www.liferay.com/web/guest/community/forums/-/message_boards/message/124969

    The only other solution is to reduce the number of pages on your site… not a great option really

    Sam

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘WordPress database error Got a packet bigger than ‘max_allowed_packet’’ is closed to new replies.

Tags