fixup the has_problems table column for rack rows
authorDenis Ovsienko <denis@ovsienko.info>
Tue, 16 May 2017 12:22:40 +0000 (13:22 +0100)
committerDenis Ovsienko <denis@ovsienko.info>
Tue, 16 May 2017 12:22:40 +0000 (13:22 +0100)
Commits 873c6a5 and 725d2f6 took care of the subsequent updates, this
change addresses any old rows that may have been written by the old
version.

wwwroot/inc/upgrade.php

index 312e45afa49a5182bf9293c0ef33f0e5f7bd8fd3..1ca45ea479fda5c2ab6476309527f8f7374255cb 100644 (file)
@@ -1224,6 +1224,8 @@ ENDOFTRIGGER;
                        $query[] = "UPDATE Config SET varvalue = '0.20.13' WHERE varname = 'DB_VERSION'";
                        break;
                case '0.20.14':
+                       $query[] = "UPDATE Object SET has_problems = 'no' WHERE objtype_id = 1561 AND has_problems = ''";
+                       $query[] = "UPDATE ObjectHistory SET ctime = ctime, has_problems = 'no' WHERE objtype_id = 1561 AND has_problems = ''";
                        $query[] = "UPDATE Config SET varvalue = '0.20.14' WHERE varname = 'DB_VERSION'";
                        break;
                case 'dictionary':