Benutzer-Werkzeuge

Webseiten-Werkzeuge


HY000 1 no such column: data_fokus.published:
SELECT data_fokus.rid AS rid,
data_fokus.pid AS PID,
data_fokus.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_fokus.col1 AS C0,
data_fokus.col2 AS C1,
data_fokus.col24 AS C2,
data_fokus.col3 AS C3,
GROUP_CONCAT(M1.value, '
!_-_-_-_-_!
') AS C4,
GROUP_CONCAT(M2.value, '
!_-_-_-_-_!
') AS C5,
data_fokus.col6 AS C6,
data_fokus.col7 AS C7,
data_fokus.col8 AS C8,
data_fokus.col9 AS C9,
data_fokus.col10 AS C10,
data_fokus.col11 AS C11,
data_fokus.col12 AS C12,
data_fokus.col13 AS C13,
data_fokus.col14 AS C14,
data_fokus.col15 AS C15,
data_fokus.col16 AS C16,
data_fokus.col17 AS C17,
data_fokus.col18 AS C18,
data_fokus.col19 AS C19,
data_fokus.col20 AS C20,
data_fokus.col21 AS C21,
data_fokus.col22 AS C22,
data_fokus.col23 AS C23
   FROM 
data_fokus AS data_fokus
LEFT OUTER JOIN multi_fokus AS M2 ON data_fokus.pid = M2.pid AND data_fokus.rid = M2.rid AND
                     data_fokus.rev = M2.rev AND
                     M2.colref = 5
LEFT OUTER JOIN multi_fokus AS M1 ON data_fokus.pid = M1.pid AND data_fokus.rid = M1.rid AND
                     data_fokus.rev = M1.rev AND
                     M1.colref = 4
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_fokus.pid != ''
                    AND data_fokus.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'fokus'
  WHERE  ( ( data_fokus.pid = '' OR ( GETACCESSLEVEL(data_fokus.pid) > 0 AND PAGEEXISTS(data_fokus.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_fokus.pid) AND data_fokus.latest = 1) OR (IS_PUBLISHER(data_fokus.pid) !=1 AND data_fokus.published = 1) ) AND ( ( data_fokus.rid != '' AND CAST(data_fokus.rid AS DECIMAL) != CAST('0' AS DECIMAL) ) AND data_fokus.pid REGEXP '^(?![\s\S])' ) )
GROUP BY data_fokus.pid,
data_fokus.rid,
C0,
C1,
C2,
C3,
C6,
C7,
C8,
C9,
C10,
C11,
C12,
C13,
C14,
C15,
C16,
C17,
C18,
C19,
C20,
C21,
C22,
C23
SQL execution failed for SELECT data_fokus.rid AS rid, data_fokus.pid AS PID, data_fokus.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_fokus.col1 AS C0, data_fokus.col2 AS C1, data_fokus.col24 AS C2, data_fokus.col3 AS C3, GROUP_CONCAT(M1.value, ' !_-_-_-_-_! ') AS C4, GROUP_CONCAT(M2.value, ' !_-_-_-_-_! ') AS C5, data_fokus.col6 AS C6, data_fokus.col7 AS C7, data_fokus.col8 AS C8, data_fokus.col9 AS C9, data_fokus.col10 AS C10, data_fokus.col11 AS C11, data_fokus.col12 AS C12, data_fokus.col13 AS C13, data_fokus.col14 AS C14, data_fokus.col15 AS C15, data_fokus.col16 AS C16, data_fokus.col17 AS C17, data_fokus.col18 AS C18, data_fokus.col19 AS C19, data_fokus.col20 AS C20, data_fokus.col21 AS C21, data_fokus.col22 AS C22, data_fokus.col23 AS C23 FROM data_fokus AS data_fokus LEFT OUTER JOIN multi_fokus AS M2 ON data_fokus.pid = M2.pid AND data_fokus.rid = M2.rid AND data_fokus.rev = M2.rev AND M2.colref = 5 LEFT OUTER JOIN multi_fokus AS M1 ON data_fokus.pid = M1.pid AND data_fokus.rid = M1.rid AND data_fokus.rev = M1.rev AND M1.colref = 4 LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_fokus.pid != '' AND data_fokus.pid = schema_assignments.pid AND schema_assignments.tbl = 'fokus' WHERE ( ( data_fokus.pid = '' OR ( GETACCESSLEVEL(data_fokus.pid) > 0 AND PAGEEXISTS(data_fokus.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_fokus.pid) AND data_fokus.latest = 1) OR (IS_PUBLISHER(data_fokus.pid) !=1 AND data_fokus.published = 1) ) AND ( ( data_fokus.rid != '' AND CAST(data_fokus.rid AS DECIMAL) != CAST(? AS DECIMAL) ) AND data_fokus.pid REGEXP ? ) ) GROUP BY data_fokus.pid, data_fokus.rid, C0, C1, C2, C3, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22, C23 [Search.php:385]
admin:fokus_edit

Zugang verweigert

Du hast nicht die erforderliche Berechtigung, um diese Aktion durchzuführen.

Anmelden

Gib deinen Benutzernamen und dein Passwort in das Formular unten ein, um dich anzumelden. Bitte beachte, dass dafür „Cookies“ in den Sicherheitseinstellungen deines Browsers erlaubt sein müssen.

Anmelden

Passwort vergessen? Fordere ein neues an: Neues Passwort festlegen