Hi David,

Yes finally using CodeStriker again after all this time :)

Thanks that works. I have to watch out for this maximum allowed packet
in MySQL then.

Cheers,
Victor

-----Original Message-----
From: David Sitsky [mailto:david.sit...@gmail.com] 
Sent: 26 May 2009 00:17
To: Hadianto, Victor
Cc: codestriker-user@lists.sourceforge.net
Subject: Re: [Codestriker-user] Installation question: DBD::mysql::db do
failed: SESSION variable 'max_allowed_packet'

Hi Victor,

Nice to hear from you. :)

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

This is the "culprit" line in lib/Codestriker/DB/MySQL.pm:

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

Just comment it out or delete the line.  It seems the latest versions of
MySQL doesn't permit this setting anymore.  It is there to allow large
topic sizes to be stored in the database, but I believe it has now been
super-seeded by a global setting in the MySQL config file.

Cheers,
David

=============================================================================== 
 Please access the attached hyperlink for an important electronic 
communications disclaimer: 
 http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html 
 
=============================================================================== 
 

------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com 
_______________________________________________
Codestriker-user mailing list
Codestriker-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/codestriker-user

Reply via email to