View Issue Details [ Jump to Notes ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007804CDashpublic2008-10-13 14:332008-10-13 17:16
ReporterTodd Harrington 
Assigned ToJulien Jomier 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.2 
Target VersionFixed in Version1.2.2 
Summary0007804: Can not create build groups after upgrading from 1.0 to 1.2
DescriptionCreating a build group after migrating from CDASH 1.0 to 1.2 appears to have not effect. Actually the build groups are created in the DB tables, but they are not displayed either on the index page, or on the manage build groups page.

The problem is that the schema changed to assign the special value "1980-01-01 00:00:00" to buildgroup.starttime, buildgroup.endtime, buildgroupposition.starttime, and buildgroupposition.endtime. However, the upgrade process does not alter the DB tables to reflect this. Then in the code, only build groups that have the special value "1980-01-01 00:00:00" ever get selected.

Although the code relies on the DB to set this special value for endtime it sets it for starttime in the code. To resolve this issue I just had the code also set the endtime to this special value when creating build groups and build group positions.
TagsNo tags attached.
Attached Files

 Relationships

  Notes
(0013864)
Julien Jomier (manager)
2008-10-13 16:39

 These lines are present in the upgrade process:

  pdo_query("UPDATE buildgroup SET starttime='1980-01-01 00:00:00' WHERE starttime='0000-00-00 00:00:00'");
  pdo_query("UPDATE buildgroup SET endtime='1980-01-01 00:00:00' WHERE endtime='0000-00-00 00:00:00'");
  pdo_query("UPDATE build2grouprule SET starttime='1980-01-01 00:00:00' WHERE starttime='0000-00-00 00:00:00'");
  pdo_query("UPDATE build2grouprule SET endtime='1980-01-01 00:00:00' WHERE endtime='0000-00-00 00:00:00'");
  pdo_query("UPDATE buildgroupposition SET starttime='1980-01-01 00:00:00' WHERE starttime='0000-00-00 00:00:00'");
  pdo_query("UPDATE buildgroupposition SET endtime='1980-01-01 00:00:00' WHERE endtime='0000-00-00 00:00:00'");

That should take care of it. Is there something else going on?
(0013865)
Todd Harrington (reporter)
2008-10-13 16:53

 Yes. The schema is not updated when upgrading so attempts to create new build groups still produces the old time stamps "0000-00-00 00:00:00".

To update the live schema you would need something like:

  pdo_query("alter table buildgroup modify starttime timestamp NOT NULL default '1980-01-01 00:00:00'");
  pdo_query("alter table buildgroup modify endtime timestamp NOT NULL default '1980-01-01 00:00:00'");

and so on.
(0013866)
Julien Jomier (manager)
2008-10-13 17:16

 I see now. I thought we had fixed that by adding the starttime and endtime explicitly in the SQL queries but apparently not. This is now fixed in the upgrade script. Thanks again for the report.

 Issue History
Date Modified Username Field Change
2008-10-13 14:33 Todd Harrington New Issue
2008-10-13 16:37 Julien Jomier Status new => assigned
2008-10-13 16:37 Julien Jomier Assigned To => Julien Jomier
2008-10-13 16:39 Julien Jomier Note Added: 0013864
2008-10-13 16:53 Todd Harrington Note Added: 0013865
2008-10-13 17:16 Julien Jomier Status assigned => closed
2008-10-13 17:16 Julien Jomier Note Added: 0013866
2008-10-13 17:16 Julien Jomier Resolution open => fixed
2008-10-13 17:16 Julien Jomier Fixed in Version => 1.2.2

Copyright © 2000 - 2018 MantisBT Team