Ttt: Unterschied zwischen den Versionen

← Zum vorherigen Versionsunterschied Zum nächsten Versionsunterschied →

Version vom 18. Februar 2026, 17:14 Uhr

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 'FROM `cargo__bookings` `bookings` GROUP BY `year` ORDER BY trim(year),`datum' at line 1

Function: CargoSQLQuery::run Query: SELECT trim(year) AS `Jahr`,`datum` AS `Datum`,CONCAT(' ',(count(*))=B AS `CONCAT( ,(count(*))=B`,`datum__precision` AS `Datum__precision` FROM `cargo__bookings` `bookings` GROUP BY `year` ORDER BY trim(year),`datum`,CONCAT(' ',(count(*))=B LIMIT 100

@@ Zeile 2: / Zeile 2: @@
 {{#cargo_query:
 tables=bookings
-|fields=trim(year)=Jahr, datum=Datum, CAST(count(*) AS CHAR)=B
+|fields=trim(year)=Jahr, datum=Datum, CONCAT('    ',(count(*))=B
 |group by=year
 }}