Installing Bugzilla 4.2.5 with Mysql 5.6.11

Question

So, now I get to the final steps to complete the installation of Bugzilla. I keep getting "disabledtext" cannot have a default value.

This is a complete mistake.

* Initialization of "Changing the dependency tree" email_setting ... Updating the disabledtext column in the table profiles ... Old: mediumtext DEFAULT '' NOT NULL New: mediumtext NOT NULL

DBD :: mysql :: db do failed: the BLOB / TEXT column 'disabledtext' cannot have a default value [for the “ALTER TABLE profiles ALTER COLUMN disabledtext DROP DEFAULT” profiles] on the Bugzilla / DB.pm 729 page.

Bugzilla :: DB :: bz_alter_column_raw ('Bugzilla :: DB :: Mysql = HASH (0x6e8f7f0)', 'profiles', 'disabledtext', 'HASH (0xa0a73d0)', 'HASH (0xa0be4a8)', undef) is called on the line Bugzilla / DB.pm 688

Bugzilla :: DB :: bz_alter_column ('Bugzilla :: DB :: Mysql = HASH (0x6e8f7f0)', 'profiles', 'disabledtext', 'HASH (0xa0a73d0)'), called in Bugzilla / Install / DB.pm line 505

Bugzilla :: Install :: DB :: update_table_definitions ('HASH (0x30d53d0)'), called at. /checksetup.pl line 199 *

Is the actual error in Bugzilla / Install / DB.pm?

Very new in this material, so anyone would be great.

Bugzilla = 4.2.5 Mysql = 5.6.11 OS = Suse 12

Answer 1

An active error was recorded for MySQL 5.6 and Bugzilla 4.2.5 and below, where mySQL 5.6 was not supported and caused a lot of problems. The bug report is associated with the release notes below.

But to solve your problem, you can either downgrade MySQL to version 5.5 or lower, or upgrade BugZilla. BugZilla 4.2.6 was released on May 22, which provides support for MySQL 5.6, see the release notes related to this page .

My advice is to upgrade BugZilla to 4.2.6.