Testseite2: Unterschied zwischen den Versionen

Version vom 25. November 2019, 20:07 Uhr

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

Query: SELECT CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ) AS "Signatur",STRING_AGG("ARCHIUM_PROPERTY_dateString",';') AS "Laufzeiten","ARCHIUM_PROPERTY_title" AS "Titel","ARCHIUM_PROPERTY_content_general" AS "Enthält","ARCHIUM_PROPERTY_content_special" AS "Darin","ARCHIUM_PROPERTY_sizeMedium" AS "Umfang" FROM "cargo__ARCHIUM_TABLE_date_of_creation1" "a" LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_title" "b" ON (("a"."_pageName"="b"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_signature" "c" ON (("a"."_pageName"="c"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_content_general" "d" ON (("a"."_pageName"="d"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_content_special" "e" ON (("a"."_pageName"="e"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_extentmedium" "f" ON (("a"."_pageName"="f"."_pageName")) WHERE a."_pageName" LIKE 'DFA-%' GROUP BY "ARCHIUM_PROPERTY_title","ARCHIUM_PROPERTY_signature","ARCHIUM_PROPERTY_ID" ORDER BY "ARCHIUM_PROPERTY_ID" LIMIT 500 Function: CargoSQLQuery::run Error: 42803 FEHLER: Spalte »d.ARCHIUM_PROPERTY_content_general« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden LINE 1: ... "Laufzeiten","ARCHIUM_PROPERTY_title" AS "Titel","ARCHIUM_P...

@@ Zeile 1: / Zeile 1: @@
 {{#cargo_query: tables=ARCHIUM_TABLE_date_of_creation1=a, ARCHIUM_TABLE_title=b, ARCHIUM_TABLE_signature=c, ARCHIUM_TABLE_content_general=d, ARCHIUM_TABLE_content_special=e, ARCHIUM_TABLE_extentmedium=f
 |join on=a._pageName = b._pageName, a._pageName = c._pageName, a._pageName = d._pageName, a._pageName = e._pageName, a._pageName = f._pageName
-|fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur,STRING_AGG("ARCHIUM_PROPERTY_dateString",';')=timespan,ARCHIUM_PROPERTY_title=title
+|fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur,STRING_AGG("ARCHIUM_PROPERTY_dateString",';')=Laufzeiten,ARCHIUM_PROPERTY_title=Titel,ARCHIUM_PROPERTY_content_general=Enthält,ARCHIUM_PROPERTY_content_special=Darin,ARCHIUM_PROPERTY_sizeMedium=Umfang
 |where=a."_pageName" LIKE 'DFA-%'
 |format=dynamic table
@@ Zeile 10: / Zeile 10: @@
 |group by="ARCHIUM_PROPERTY_title","ARCHIUM_PROPERTY_signature","ARCHIUM_PROPERTY_ID"
 }}
+|?ARCHIUM_PROPERTY_title=Titel
+|?ARCHIUM_PROPERTY_content_general=Enthält
+|?ARCHIUM_PROPERTY_content_special=Darin
+|?ARCHIUM_PROPERTY_signature=Signatur
+|?ARCHIUM_PROPERTY_sizeMedium=Umfang
+|?ARCHIUM_PROPERTY_dateString=Laufzeit