Difference between revisions of "Template: LatestContainers"
From Genesys Documentation
| Line 8: | Line 8: | ||
|delimiter= | |delimiter= | ||
|where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0"}}</td> | |where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0"}}</td> | ||
| − | <td>{{#cargo_query:tables=RNElements,Component | + | <td> |
| + | {{#cargo_query:tables=RNElements,Component | ||
|join on=RNElements.IpName=Component.IpName | |join on=RNElements.IpName=Component.IpName | ||
|fields=CONCAT(RNElements.Filename,'{{#switch:{{NAMESPACENUMBER}}|620={{SuperscriptCheck}}|#default=}}') | |fields=CONCAT(RNElements.Filename,'{{#switch:{{NAMESPACENUMBER}}|620={{SuperscriptCheck}}|#default=}}') | ||
Revision as of 15:30, April 7, 2022
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT MAX(ReleaseNumber) FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__ComponentRN__DeploymentTypeId` ON ((`cargo__ComponentRN`.`_ID`=`cargo__ComponentRN__DeploymentTypeId`.`_rowID`)) RIGHT OUTER JOIN `cargo__DeploymentType` ON ((`cargo__ComponentRN__DeploymentTypeId`.`_value`=`cargo__DeploymentType`.`Id`)) WHERE ComponentId HOLDS "" AND ReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="0" ORDER BY MAX(ReleaseNumber) 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 "" AND ReleaseDate="" AND `cargo__ComponentRN`.`_pageNamespace`="0" ORDER' at line 1 (127.0.0.1)