While installing new modules I got this error:
An error occurred. /nl/batch?id=6&op=do { "status": true, "percentage": 0, "message": "Downloading and importing files.\x3cbr/\x3e\x26nbsp;\x3cbr/\x3e\x26nbsp;" }
Warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:1578654:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE batch SET batch = 'a:10:{s:4:\\"sets\\";a:4:{i:0;a:12:{s:7:\\"sandbox\\";a:0:{}s:7:\\"results\\";a:6:{i:0;s:55:\\"sites/all/modules/xmlsitemap/translations/general.de.po\\";i:1;s:58:\\"sites/all/modules/xmlsitemap/translations/xmlsitemap.nl.po\\";i:2;s:58:\\"sites/all/modules/xmlsitemap/translations/xmlsitemap.de.po\\";i:3;s:55:\\"sites/all/modules/xmlsitemap/translations/general.nl.po\\";i:4;s:79:\\"sites/all/mo in /var/www/html/includes/database.mysqli.inc on line 134

Can I alter the "max_allowed_packet" size?

Comments

blogers’s picture

blogers CreditAttribution: blogers commented

I have this erro intalling module html mail

Denes.Szabo’s picture

Denes.Szabo CreditAttribution: Denes.Szabo commented

The max_allowed_packet is a mysql server variable: http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html

You should try to alter it in your home in a my.ini file.

PROMES’s picture

PROMES
Primary language Dutch
CreditAttribution: PROMES commented

The documentation tells me to increase this variable both in the client and the server.
It's a pity. I cannot alter this variable. I don't have shell access in a hosted environment, like many (most?) other Drupallers.
I think this module should create only db-inserts whith a reasonable size, usable for everyone not for experts / big companies whith a own server.
Thanks for informing me.

Niek_Kloots’s picture

Niek_Kloots CreditAttribution: Niek_Kloots commented

You can try and add
php_value memory_limit 80M
in you .htaccess file.

asrob’s picture

asrob
he/him
Primary language Hungarian
Location Hungary 🇭🇺 🇪🇺
CreditAttribution: asrob commented
Issue summary: View changes
Status: Active » Closed (works as designed)

It seems to me this issue has been fixed by Denes.Szabo and Niek_Kloots, that's why I close this.

PROMES’s picture

PROMES
Primary language Dutch
CreditAttribution: PROMES commented

I can confirm the problem doesn't exists anymore. I changed to own servers in 2012 (coming from hosted services) and be able to change all settings.