summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorolav%bkor.dhs.org <>2006-11-15 02:17:36 +0100
committerolav%bkor.dhs.org <>2006-11-15 02:17:36 +0100
commitb2df778fe5ea692b0175f67c9129f0283b6eeadc (patch)
tree7e5bacbe97b50958daabdc2bc07003f4a7f58419
parent350158b2dea58146f8428561ddcb61fa34c8a47c (diff)
downloadbugzilla-b2df778fe5ea692b0175f67c9129f0283b6eeadc.tar.gz
bugzilla-b2df778fe5ea692b0175f67c9129f0283b6eeadc.tar.xz
Bug 321645: [MySQL 5] MySql Error on insert... "DBD::mysql::st execute failed: Field 'status_whiteboard' "....
Patch by Olav Vitters <olav@bkor.dhs.org> r=mkanat a=justdave
-rw-r--r--Bugzilla/DB/Mysql.pm12
1 files changed, 12 insertions, 0 deletions
diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm
index 2f23e8345..b3b1cba10 100644
--- a/Bugzilla/DB/Mysql.pm
+++ b/Bugzilla/DB/Mysql.pm
@@ -65,6 +65,18 @@ sub new {
bless ($self, $class);
+ # Bug 321645 - disable MySQL strict mode, if set
+ my $sql_mode = $self->selectrow_array('SELECT @@sql_mode');
+ if ($sql_mode) {
+ my $new_sql_mode =
+ join(",", grep {$_ !~ /^STRICT_(?:TRANS|ALL)_TABLES|TRADITIONAL$/}
+ split(/,/, $sql_mode));
+
+ if ($sql_mode ne $new_sql_mode) {
+ $self->do("SET SESSION sql_mode = ?", undef, $new_sql_mode);
+ }
+ }
+
return $self;
}