| Summary | Uploading photos with size larger 1 MB fails |
| Queue | Ansel |
| Queue Version | 1.0 |
| Type | Bug |
| State | Not A Bug |
| Priority | 1. Low |
| Owners | mrubinsk (at) horde (dot) org |
| Requester | info (at) wanner-it (dot) de |
| Created | 03/27/2009 (6003 days ago) |
| Due | |
| Updated | 03/29/2009 (6001 days ago) |
| Assigned | |
| Resolved | 03/29/2009 (6001 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
thank you, that was the solution. The default in MySql is 1M for the
buffer-size and that also affects the maximum size for blob-fields.
Setting
max_allowed_packet = 10M
in my.cnf solves the problem. Perhaps this would be a good hint in the
installation notes.
Thank you again.
Assigned to Michael Rubinsky
State ⇒ Not A Bug
Priority ⇒ 1. Low
the limit of the size of data that can be strored in a BLOB field on
your DB server. There are a number of things that can affect this
limit. For example, see
http://dev.mysql.com/doc/refman/5.0/en/blob.html for how this works
with MySQL.
Priority ⇒ 2. Medium
Patch ⇒ No
Milestone ⇒
Queue ⇒ Ansel
Summary ⇒ Uploading photos with size larger 1 MB fails
Type ⇒ Bug
State ⇒ Unconfirmed
Uploading photos that exceed 1 MB fails. It doesn't depend on the
upload method (file or zip-file). e.g. when I upload photos that are
stored in a zip file there is an error message (in german: Beim
Speichern des Fotos ist ein Problem aufgetreten: Object id
#71) forevery picture that exceeds 1MB. All photos smaller than 1 MB are
uploaded and visible.
This is what I see in horde.log:
Mar 27 18:34:43 HORDE [error] [ansel] Unable to load SQL data. [pid
2248 on line 2245 of "/var/www/horde/ansel/lib/Ansel.php"]
Mar 27 18:34:43 HORDE [error] [ansel] Unable to load SQL data. [pid
2248 on line 2672 of "/var/www/horde/ansel/lib/Ansel.php"]
Mar 27 18:34:43 HORDE [emergency] [ansel] Unable to load SQL data.
[pid 2248 on line 44 of "/var/www/horde/ansel/img/mini.php"]