I was running into a problem where uploading attachments to a ticket failed.  Instead of getting a warning after waiting for the upload, the page would just refresh and the attachment would not be there.<div><br></div><div>
I thought updating the WebMaxFileUpload setting in Config Options: Framework -&gt; Core::Web would solve the problem.  It did not.</div><div><br></div><div>I finally found this warning in the Apache error log file : </div>
<div><br></div><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div>ERROR: OTRS-CGI-99 Perl: 5.8.8 OS: linux Time: Tue Feb 23 13:46:31 2010</div></div><div><div><br>
</div></div><div><div> Message: Got a packet bigger than &#39;max_allowed_packet&#39; bytes, SQL: &#39;INSERT INTO web_upload_cache  (form_id, filename, content_type, content_size, content, create_time_unix, content_id) VALUES  (?, ?, ?, ?, ?, ?, ?)&#39;</div>
</div></blockquote><div><div><br></div><div>The final fix is that the max_allowed_packet in your MySQL my.cnf file must ALSO be set to whatever you want the max upload size to be.  Here is my sample : </div><div><br></div>
</div><blockquote class="webkit-indent-blockquote" style="margin: 0 0 0 40px; border: none; padding: 0px;"><div><div>max_allowed_packet = 16M</div></div></blockquote><div><div><br></div><div>Hopefully this tip will help someone else.  I found several people asking this question with responses like &quot;This has been answered many times before....&quot; .  Well, I never found an answer.</div>
<div><br></div><div>Justin Noel</div><div><a href="http://www.calendee.com">http://www.calendee.com</a></div></div>