View Issue Details [ Jump to Notes ]

[ Print ]

Project

Category

View Status

Date Submitted

Last Update

0007806

CDash

public

2008-10-13 15:04

2008-10-29 14:46

Reporter

Todd Harrington

Assigned To

Julien Jomier

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

1.2

Target Version

Fixed in Version

1.3

Summary

0007806: MySQL error creating build groups

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 description, and thus they all fail. 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 ''

Another solution would be to change the code in manageBuildGroup.php from:

  $sql = "INSERT INTO buildgroup (name,projectid,starttime) VALUES ('$Name','$projectid','$starttime')";

to:

  $sql = "INSERT INTO buildgroup (name,projectid,starttime,description) VALUES ('$Name','$projectid','$starttime','')";

The best approach would probably be to do both. The first for new releases of cdash, and the second for backward compatibility with older database schemas.

Tags

No tags attached.

Attached Files

Relationships

Notes
(0013973) Julien Jomier (manager) 2008-10-29 14:46	Fixed in 1.3 Thanks for the report!

Issue History
Date Modified	Username	Field	Change
2008-10-13 15:04	Todd Harrington	New Issue
2008-10-29 14:41	Julien Jomier	Status	new => assigned
2008-10-29 14:41	Julien Jomier	Assigned To	=> Julien Jomier
2008-10-29 14:46	Julien Jomier	Note Added: 0013973
2008-10-29 14:46	Julien Jomier	Status	assigned => closed
2008-10-29 14:46	Julien Jomier	Resolution	open => fixed
2008-10-29 14:46	Julien Jomier	Fixed in Version	=> 1.3