[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