Difference between revisions of "User: Bgrenon/3"

Revision as of 18:07, April 11, 2022

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE PrivateEditionReleaseDate IS NOT NULL GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__ComponentRN`.`ComponentId` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE PrivateEditionReleaseDate IS NOT NULL G' at line 1 (127.0.0.1)

@@ Line 1: / Line 1: @@
 <!-- finding all containers-->
 {{#cargo_query:
@@ Line 12: / Line 13: @@
 |named args=yes
 }}
-<!--
-{{#cargo_query:
-tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN,DeploymentType
-|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID,ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
-|fields=Component.Name=ServiceName,ReleaseNumber,ComponentId,Component.IpName=IpName,Containers
-|where=ComponentRN._pageNamespace="0" AND ArticleCloudRN._pageNamespace="0" AND ArticleCloudRN._pageName LIKE "%GenesysEngage-cloud%" AND PrivateEditionReleaseDate IS NOT NULL AND Component.IpName IS NOT NULL
-|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Released on</th><th>Release Number</th><th>Helm updates</th><th>Container updates</th></tr>
-|outro=</table>
-|format=table
-|template=LatestContainers
-|named args=yes
-|group by=Component.Name,ComponentId,ReleaseNumber,Component.IpName,Containers
-|limit=20
-}}
-{{#cargo_query:
-tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN,DeploymentType
-|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID,ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
-|fields=Component.Name,ArticleCloudRN._pageName,MAX(ReleaseDate),MAX(PrivateEditionReleaseDate),ReleaseNumber,Image,Highlight,ComponentId,ReleaseDate,ReleaseNumber,Component.IpName,Containers
-|where=ComponentRN._pageNamespace="0" AND ArticleCloudRN._pageNamespace="0" AND ArticleCloudRN._pageName LIKE "%GenesysEngage-cloud%" AND PrivateEditionReleaseDate IS NOT NULL AND Component.IpName IS NOT NULL
-|format=table
-|group by=Component.Name,ArticleCloudRN._pageName,ReleaseNumber,Image,Highlight,ComponentId,ReleaseNumber,Component.IpName,Containers
-|order by=Component.Name
-|limit=10
-}}
--->