View Issue Details [ Jump to Notes ]

[ Print ]

Project

Category

View Status

Date Submitted

Last Update

0007639

CDash

public

2008-09-09 11:19

2008-09-09 11:23

Reporter

Todd Harrington

Assigned To

Julien Jomier

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

1.0.2

Target Version

Fixed in Version

1.2

Summary

0007639: Build group description required by MySQL but not set by PHP build group commands

Description

The MySQl buildgroup table requires that the description field be "NOT NULL" but no default (empty string) is given.

CREATE TABLE `buildgroup` (
  <snip>
  `description` text NOT NULL,
  <snip>
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

None of the PHP commands that create entries in the buildgroup table supply a descriptions, and thus they all fail. The manageBuildGroup.php page does not provide an input widget for description so there is no way to create one. Also, when creating a new project the creation of the default build groups (Continuous, Nightly, Experimantal) fails as well.

I resolved these issues locally by adding a default empty string description to the MySQL schema:

  `description` text NOT NULL default ''

Additional Information

This issue exists in the 1.0 and 1.0.2 releases, and although I have not tested it, it appears to exist in the development version as well.

Tags

No tags attached.

Attached Files

Relationships

Notes
(0013379) Julien Jomier (manager) 2008-09-09 11:23	This has been fixed in 1.2. Thanks for the report.

Issue History
Date Modified	Username	Field	Change
2008-09-09 11:19	Todd Harrington	New Issue
2008-09-09 11:20	Julien Jomier	Status	new => assigned
2008-09-09 11:20	Julien Jomier	Assigned To	=> Julien Jomier
2008-09-09 11:23	Julien Jomier	Status	assigned => closed
2008-09-09 11:23	Julien Jomier	Note Added: 0013379
2008-09-09 11:23	Julien Jomier	Resolution	open => fixed
2008-09-09 11:23	Julien Jomier	Fixed in Version	=> 1.2