From be6d336e3774a82c11dba2b80a7bb98ca70cc891 Mon Sep 17 00:00:00 2001 From: "olav%bkor.dhs.org" <> Date: Fri, 17 Nov 2006 08:18:26 +0000 Subject: Bug 321645: [MySQL 5] MySql Error on insert... "DBD::mysql::st execute failed: Field 'status_whiteboard' ".... Patch by Olav Vitters r=gavins a=justdave --- Bugzilla/DB/Mysql.pm | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'Bugzilla/DB/Mysql.pm') diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm index d9e6a2510..3bcd74389 100644 --- a/Bugzilla/DB/Mysql.pm +++ b/Bugzilla/DB/Mysql.pm @@ -66,9 +66,11 @@ sub new { bless ($self, $class); # Bug 321645 - disable MySQL strict mode, if set - my $sql_mode = $self->selectrow_array('SELECT @@sql_mode'); + my ($var, $sql_mode) = $self->selectrow_array( + "SHOW VARIABLES LIKE 'sql\\_mode'"); + if ($sql_mode) { - # STRICT_TRANS_TABLE or STICT_ALL_TABLES enable MySQL strict mode, + # STRICT_TRANS_TABLE or STRICT_ALL_TABLES enable MySQL strict mode, # causing bug 321645. TRADITIONAL sets these modes (among others) as # well, so it has to be stipped as well my $new_sql_mode = -- cgit v1.2.3-24-g4f1b