#93 My SQL 5.1

[rob_webset]

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

[David Sitsky]

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.

[Nobody/Anonymous]

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