Update : I found you can avoid making this change to your database by changing where uploaded attachments are cached.<div><br></div><div>Just changed WebUploadCacheModule in Core::Web to FS instead of DB.</div><div><br></div>
<div>Justin<br><br><div class="gmail_quote">On Thu, Feb 25, 2010 at 9:13 AM, Justin Noel <span dir="ltr">&lt;<a href="mailto:otrs@jandgnoel.com">otrs@jandgnoel.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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 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 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><font color="#888888"><div>Justin Noel</div><div><a href="http://www.calendee.com" target="_blank">http://www.calendee.com</a></div></font></div>
</blockquote></div><br></div>