Percussion shows this message:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
and this is the error message displayed beneath it:
An error occurred processing the update submitted by session id 847812f6fc10e348e68cd15a159cd5d83fffb0de.An exception occurred while processing the internal request handler call: An error occurred processing the update submitted by session id 847812f6fc10e348e68cd15a159cd5d83fffb0de.  S1000: Packet for query is too large (15588718 > 4194304). You can change this value on the server by setting the max_allowed_packet’ variable. INSERT INTO bordner.CT_PERCFILEASSET (CONTENTID, REVISIONID, DISPLAYTITLE, ITEM_FILE_ATTACHMENTX, ITEM_FILE_ATTACHMENT_FILENAME, ITEM_FILE_ATTACHMENT_TYPE, FILEUSAGE, FILENAME, ITEM_FILE_ATTACHMENT_EXT, ITEM_FILE_ATTACHMENT_SIZE) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )modify
I have upped the max allowed filesize on the MySQL server (as I read from another user on your forum), then reset both MySQL and Percussion. I am still getting this message. Any ideas? Do I need to up the max allowed filesize in a Percussion file as well?
It sounds like you’re on the right track. What may have gone wrong is, if you set the max_allowed_packet variable through the MySQL command line, restarting MySQL would actually revert that setting back to what’s contained within your my.ini config file.
To permanently fix this issue, find and open your my.ini file in notepad, which is usually located in a directory similar to “C:\ProgramData\MySQL\MySQL Server 5.6” (note that ProgramData is a hidden folder, so you’ll need to either manually key it in, or set your Windows folder options to show hidden folders), and find this line:
Change this to something greater, such as:
And then restart the MySQL service. Once you’ve done so you should be all set. Let me know if you have further trouble with this.