Tracker: Bugs

5 My SQL 5.1 - ID: 2569030
Last Update: Comment added ( nobody )

Hi,

I tried upgrading our machine that runs Codestriker (1.9.6) and MySQL to MySQL 5.1 (Was previously on 5.0) and I get the following error when I run the install.pl (Windows Environment)

DBD::mysql::db do failed: SESSION variable 'max_allowed_packet' is read-only. Us
e SET GLOBAL to assign the value at C:\Apps\codestriker\lib/Codestriker/DB/MySQL
.pm line 59.
DBD::mysql::db do failed: SESSION variable 'max_allowed_packet' is read-only. Us
e SET GLOBAL to assign the value at C:\Apps\codestriker\lib/Codestriker/DB/MySQL
.pm line 59.


I'm wondering if they have now restricted something they used to allow to be changed?

Thanks

Rob

rob_webset ( rob_webset ) - 2009-02-05 09:16:21 PST

5

Open

None

Nobody/Anonymous

None

None

Public


Comments ( 2 )

Date: 2009-03-09 20:29:23 PDT
Sender: nobody

I find it is a bug of mysql.please refer to the
url:http://bugs.mysql.com/bug.php?id=32223 and
http://bugs.mysql.com/bug.php?id=22891.and then I annotated some code
segments in lib/Codestriker/DB/MySQL
.pm line 59. running install.pl is done well

Date: 2009-02-05 14:19:32 PST
Sender: sitsProject Admin

It does sound like it. Try commenting out the line 59 which has the code:

$dbh->do("SET max_allowed_packet=128000000");

in lib/Codestriker/DB/MySQL.pm

I believe you can set this in my.ini instead.

Thanks for the heads up - I'll have to try the upgrade myself and update
the documentation.

Attached File

No Files Currently Attached

Change

No changes have been made to this artifact.