MantisBT - CDash | |||||
| View Issue Details | |||||
| ID | 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 | 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. | ||||
| Steps To Reproduce | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| Notes | |||||
|
|
|||||
|
|
||||