[horde] wicked uploads not working for large files

André Lang sierra at webrausch.de
Tue Oct 23 09:53:28 UTC 2012


Am 23.10.2012 11:33, schrieb Uttiya Chowdhury:
> 2012-10-23T17:28:19+08:00 ERR: HORDE [wicked] QUERY FAILED: Got a packet bigger than 'max_allowed_packet' bytes
>
> INSERT INTO horde_vfs (vfs_type, vfs_path, vfs_name, vfs_modified, vfs_owner, vfs_data) VALUES (1, '.horde/wicked/attachments/66', 'Entegris_gas_purifiers.pdf;1', 1350984498, '', '%PDF-1.4

max_allowed_packet is a setting of MySQL. As each SQL query is sent in a 
single packet, max_allowed_packet size must be large enough to hold the 
whole SQL query, i.e. the query including the large binary object (or 
file) you are trying to insert / upload.

Add a line:
max_allowed_packet = 1G
for 1 GB maximum packet size to /etc/mysql/my.cnf and restart your SQL 
server.

Regards,
André


More information about the horde mailing list