Difference between revisions of "User: Bgrenon"
From Genesys Documentation
| Line 1: | Line 1: | ||
| − | {{ | + | {{#cargo_query: |
| − | + | tables=SMART_Benchmark_MasterList,SMART_Meta,SMART_Benefits | |
| − | | | + | |join on=SMART_Benchmark_MasterList.BenchmarkBenefitShort=SMART_Benefits.CanonicalBenefitID,SMART_Benefits._pageName=SMART_Meta._pageName |
| − | | | + | |fields=ID,Title,CanonicalBenefitImage,CanonicalBenefitImageURL |
}} | }} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 13:45, January 10, 2020
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `ID` AS `ID`,`Title` AS `Title`,`CanonicalBenefitImage` AS `CanonicalBenefitImage`,`CanonicalBenefitImageURL` AS `CanonicalBenefitImageURL` FROM `cargo__SMART_Benchmark_MasterList` LEFT OUTER JOIN `cargo__SMART_Meta` ON ((`cargo__SMART_Benefits`.`_pageName`=`cargo__SMART_Meta`.`_pageName`)) LEFT OUTER JOIN `cargo__SMART_Benefits` ON ((`cargo__SMART_Benchmark_MasterList`.`BenchmarkBenefitShort`=`cargo__SMART_Benefits`.`CanonicalBenefitID`)) ORDER BY `ID`,`Title`,`CanonicalBenefitImage`,`CanonicalBenefitImageURL` LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column 'cargo__SMART_Benchmark_MasterList.BenchmarkBenefitShort' in 'on clause' (127.0.0.1)