MySQL Bugs: #45991: Installation of Eventum-2.2 fails during setup phase

Bug #45991	Installation of Eventum-2.2 fails during setup phase
Submitted:	7 Jul 2009 7:59	Modified:	27 Aug 2010 19:58
Reporter:	Christian Heim	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	Eventum	Severity:	S3 (Non-critical)
Version:	2.2	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
If I create a initial installation of Eventum on our MySQL-Master-Master Cluster, the installation of the schema fails. After tracing the error, it boils down to the table history_type and the field 'replier_added'. This is due to htt_id being limited to TINYINT, which is by design a max of 255.

How to repeat:
Setup a Master-Master replication cluster, with the following options:

/etc/my.cnf:
auto_increment_increment = 10
auto_increment_offset    = 1

and then import the schema.sql.

Suggested fix:
Change tinyint(2) to int(3) of htt_id in schema.sql:

CREATE TABLE `%TABLE_PREFIX%history_type` (
  htt_id int(3) unsigned NOT NULL auto_increment,
  htt_name varchar(25) NOT NULL,
  htt_role tinyint(1) DEFAULT 0,
  PRIMARY KEY(htt_id),
  UNIQUE (htt_name)
) ENGINE = MYISAM DEFAULT CHARSET=utf8;

Thank you for the report.

Eventum bugs are now tracked at https://bugs.launchpad.net/eventum Please re-post this bug there.