MantisBT - CDash
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007639CDashpublic2008-09-09 11:192008-09-09 11:23
ReporterTodd Harrington 
Assigned ToJulien Jomier 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.0.2 
Target VersionFixed in Version1.2 
Summary0007639: Build group description required by MySQL but not set by PHP build group commands
DescriptionThe 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 ''



Steps To Reproduce
Additional InformationThis 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.
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-09 11:19Todd HarringtonNew Issue
2008-09-09 11:20Julien JomierStatusnew => assigned
2008-09-09 11:20Julien JomierAssigned To => Julien Jomier
2008-09-09 11:23Julien JomierStatusassigned => closed
2008-09-09 11:23Julien JomierNote Added: 0013379
2008-09-09 11:23Julien JomierResolutionopen => fixed
2008-09-09 11:23Julien JomierFixed in Version => 1.2

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