Difference between revisions of "User: Bgrenon"
From Genesys Documentation
| Line 3: | Line 3: | ||
|join on=SMART_UseCase__RequiresAll._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresAll._value=SMART_Meta.ID | |join on=SMART_UseCase__RequiresAll._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresAll._value=SMART_Meta.ID | ||
|fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresAll._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List | |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresAll._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List | ||
| − | |where=SMART_Meta.ID=" | + | |where=SMART_Meta.ID="BO02" |
|default=None | |default=None | ||
| − | |group by= | + | |group by=SMART_Metat.ID |
}} | }} | ||
Revision as of 20:10, February 3, 2020
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `Solution` AS `Solution`,CONCAT ('',`cargo__SMART_Meta`.`Title`,' (',`cargo__SMART_Meta`.`ID`,')') AS `List` FROM `cargo__SMART_UseCase__RequiresAll` LEFT OUTER JOIN `cargo__SMART_UseCase` ON ((`cargo__SMART_UseCase__RequiresAll`.`_rowID`=`cargo__SMART_UseCase`.`_ID`)) LEFT OUTER JOIN `cargo__SMART_Meta` ON ((`cargo__SMART_UseCase__RequiresAll`.`_value`=`cargo__SMART_Meta`.`ID`)) WHERE `cargo__SMART_Meta`.`ID`="BO02" GROUP BY SMART_Metat.ID ORDER BY `Solution`,CONCAT ('',`cargo__SMART_Meta`.`Title`,' (',`cargo__SMART_Meta`.`ID`,')') LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column 'SMART_Metat.ID' in 'group statement' (127.0.0.1)