upload filesize limit VS mysql max_allowed_packet limit
-
Recent mobile phones are capable to produce ~10MB size images with default settings, without limiting the filesize in the form-code, the currently used mysql server may reject the sql insert depending on the
max_allowed_packet
value.
If we have no power to change the mysql config, there is currently no known workaround, because limiting the size of the upload would simply prevent the average user from adding a photo, and in my case the photo would be a required part of the submission.A solution could be, to get the actual value from max_allowed_packet, and the file to be stored could be split into smaller blobs that are indexed, to ensure re-assembly.
Other solution would be to store a hash-named file into /wp-content/somesubdir/ and store the hash-to-filename info, along with outher meta data, to enable access control, and avoid direct access to those files
I forgot to note, i used CF7 5.1.4
- The topic ‘upload filesize limit VS mysql max_allowed_packet limit’ is closed to new replies.