DaanHoogland commented on code in PR #6838:
URL: https://github.com/apache/cloudstack/pull/6838#discussion_r1000562460
##########
engine/schema/src/main/resources/META-INF/db/schema-41710to41800.sql:
##########
@@ -586,3 +586,14 @@ UPDATE cloud.configuration
SET description = "Use SSL method used to encrypt copy traffic between
zones. Also ensures that the certificate assigned to the zone is used when
generating links for external access."
WHERE name = 'secstorage.encrypt.copy';
+
+-- allow isolated networks without services to be used as is.
+UPDATE networks ntwk
+ SET ntwk.state = 'Implemented'
+ WHERE ntwk.network_offering_id in
+ (SELECT id FROM network_offerings ntwkoff
+ WHERE (SELECT count(*) FROM ntwk_offering_service_map ntwksrvcmp WHERE
ntwksrvcmp.network_offering_id = ntwkoff.id) = 0
Review Comment:
and
```suggestion
WHERE (SELECT count(*) FROM `cloud`.`ntwk_offering_service_map`
ntwksrvcmp WHERE ntwksrvcmp.network_offering_id = ntwkoff.id) = 0
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
