#93 My SQL 5.1

open
nobody
None
5
2009-02-05
2009-02-05
rob_webset
No

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

Discussion

  • David Sitsky
    David Sitsky
    2009-02-05

    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.

     
  • 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