View Issue Details [ Jump to Notes ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0010426CDashpublic2010-03-17 02:202010-04-16 13:38
ReporterStanislaw Szymczyk 
Assigned ToJulien Jomier 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version1.6.4 
Summary0010426: ClientJobSchedule::Save fails because of missing client_jobschedule table columns
DescriptionWhile trying to get the new integrated build management feature working in CDash 1.6.2 I noticed that scheduling a build always ends whith the following error message:

[2010-03-17T07:01:05][ERROR](ClientJobSchedule::Save): SQL error: Unknown column 'repository' in 'field list'

After inspecting models/clientjobschedule.php and cdash database I noticed that several columns used in ClientJobSchedule::Save method are missing in client_jobschedule database table: repository, module, buildnamesuffix, tag.

The missing columns are only added by backwardCompatibilityTools.php when upgrading a database schema to 1.6, they are not present in sql/mysql/cdash.sql nor sql/pgsql/cdash.sql, so freshly created database doesn't contain them.
TagsNo tags attached.
Attached Files

 Relationships

  Notes
(0019974)
Julien Jomier (manager)
2010-03-21 10:46

 Good catch. Here's the complete table. I'm going to add an upgrade for CDash 1.8. Regretfully CDash 1.6 would have to be reinstalled from scratch for this to work.

CREATE TABLE IF NOT EXISTS client_jobschedule (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `userid` int(11) default NULL,
  `projectid` int(11) default NULL,
  `cmakecache` mediumtext NOT NULL,
  `startdate` timestamp NOT NULL default '1980-01-01 00:00:00',
  `enddate` timestamp NOT NULL default '1980-01-01 00:00:00',
  `type` tinyint(4) NOT NULL,
  `starttime` time NOT NULL default '00:00:00',
  `repeattime` decimal(3,2) NOT NULL default '0.00',
  `enable` tinyint(4) NOT NULL,
  `lastrun` timestamp NOT NULL default '1980-01-01 00:00:00',
  `repository` varchar(512) default '',
  `module` varchar(255) default '',
  `buildnamesuffix` varchar(255) default '',
  `tag` varchar(255) default '',
  UNIQUE KEY `id` (`id`),
  KEY `userid` (`userid`),
  KEY `projectid` (`projectid`),
  KEY `enable` (`enable`),
  KEY `starttime` (`starttime`),
  KEY `repeattime` (`repeattime`)
);

 Issue History
Date Modified Username Field Change
2010-03-17 02:20 Stanislaw Szymczyk New Issue
2010-03-21 10:23 Julien Jomier Status new => assigned
2010-03-21 10:23 Julien Jomier Assigned To => Julien Jomier
2010-03-21 10:46 Julien Jomier Note Added: 0019974
2010-03-21 10:46 Julien Jomier Status assigned => resolved
2010-03-21 10:46 Julien Jomier Fixed in Version => 1.8
2010-03-21 10:46 Julien Jomier Resolution open => fixed
2010-04-16 13:38 Julien Jomier Status resolved => closed
2010-04-16 13:38 Julien Jomier Fixed in Version 1.8 => 1.6.4

Copyright © 2000 - 2018 MantisBT Team