W&T-Schlagworte: Unterschied zwischen den Versionen

Version vom 28. Februar 2020, 15:06 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","ARCHIUM_PROPERTY_INDEX_subject" AS "Name" FROM "cargo__ARCHIUM_TABLE_signature" "s" LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_locationList" "il" ON (("s"."_pageName"="il"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_nameList" "in" ON (("s"."_pageName"="in"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_subjectList" "is" ON (("s"."_pageName"="is"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_access_restriction" "r" ON (("s"."_pageName"="r"."_pageName")) ORDER BY mgp."ARCHIUM_PROPERTY_maingroup_priority",s."ARCHIUM_PROPERTY_ID" LIMIT 500 Function: CargoSQLQuery::run Error: 42P01 ERROR: missing FROM-clause entry for table "mgp" LINE 1: ...N (("s"."_pageName"="r"."_pageName")) ORDER BY mgp."ARCHI...

@@ Zeile 8: / Zeile 8: @@
 |join on=s._pageName=r._pageName, s._pageName=il._pageName, s._pageName=in._pageName, s._pageName=is._pageName
 |fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur,
-ARCHIUM_PROPERTY_INDEX_subject=Name,
+ARCHIUM_PROPERTY_INDEX_subject=Name
-CONCAT("ARCHIUM_PROPERTY_maingroup_assignment")=Hauptgruppe
-|parent field=Hauptgruppe
 <!--|where=s."_pageName" LIKE 'W&T-%' {{#ifexpr:{{#expr:{{#UserAccessCheck:{{PAGENAME}}|{{#var:ARCHIUM_VAR_user_whitelist_{{#username:AnonymousNoname}}}}|{{#var:ARCHIUM_VAR_user_blacklist_{{#username:AnonymousNoname}}}}}}+{{#ifsysop:1|0}}+{{#ifeq: {{#cargo_query:tables=ARCHIUM_TABLE_access_restriction|fields=ARCHIUM_PROPERTY_access_restriction|no html|default=|where="_pageName"='W&T'}}|frei|1|0}}}}<1|AND r."ARCHIUM_PROPERTY_access_restriction" = 'frei'|}}-->
-|format=tree
+|format=table
 |searchable columns=Titel, Laufzeiten
 |rows per page=500