Do not use MySQL 5.1.31 or newer with Bugzilla 3.2 – 3.2.2 24 février 2009
Posted by Frédéric Buclin in Bugzilla.trackback
As described in bug 480001, MySQL 5.1.31 and newer no longer let you write ‘SET SESSION max_allowed_packet = xxxx’ (this variable is now read-only, unless set globally). As we are calling it from two different places in Bugzilla 3.2, 3.2.1 and 3.2.2, those versions won’t work together. I hope this problem will be fixed in Bugzilla 3.2.3.
Update: this bug has been fixed and will be available in Bugzilla 3.2.3, which should be released very soon now (probably next week).
A patch is available at the bugreport…
For all those having the same problem with Bugzilla 3.2.2, the patch is available here:
https://bug480001.bugzilla.mozilla.org/attachment.cgi?id=364818
Put this patch somewhere on your computer (the patch is named maxpacket-3.2.diff), and then go into your bugzilla/ root directory and type:
patch -p0 –dry-run < /path/to/the/patch/maxpacket-3.2.diff
If no error is thrown, run the same command again, but without –dry-run.
The final step is to run checksetup.pl again to restore file permissions which are altered when applying the patch.
Hi,
I have tried to install the patch on my Windows XP system.
The patch command isn’t available.
Is this a CVS command. I havn’t CVS on my machine.
How could I fix it on my system.
Many thanks,
Thomas
No, patch.exe isn’t a CVS command. For instance, you can install it from here:
http://unxutils.sourceforge.net/
I don’t remember if I tested this package, but it looks good, and patch.exe is there.
Hi again,
I’ve checked the .diff file and so I was able to patch the associated files manual, as only text files are modified.
Now checksetup.pl is running
Cheers,
Thomas
thanks lpsolit … now I’m ruuning Bugzilla 3.2.2 with MySQL 5.1.32
I’m still running into an issue on this… Hopefully you can shed some light on it?
I just checked out Bugzilla 3.2.2, on perl 5.10.0 (Build 1004).
I am trying to setup Bugzilla on MySQL 5.1.32, however, when I try to apply the patch, as you have instructed here, I get the following error message:
patching file ‘Bugzilla/Config/Attachment.pm’
Assertion failed: hunk, file patch.c, line 321
This application has requested the Runtime to terminate it in an unusual way. Please contact the application’s support team for more information.
Any insight into this issue would be much appreciated.
@monty: this looks like a bug in your “patch” application. I have no idea what’s going on.
It’s the GNU patch version for win32 that is producing this error.
http://gnuwin32.sourceforge.net/packages/patch.htm
patching file Bugzilla/Config/Attachment.pm
Assertion failed: hunk, file ../patch-2.5.9-src/patch.c, line 354
Of course it could be any number of really obscure broken MS things.
Install cygwin to get around this and use their patch tool.
[...] to a change in MySQL 5.1.31 and newer, “SET SESSION max_allowed_packet” is no longer allowed, making previous [...]