This version (2017/04/15 17:38) was approved by stohrendorf.The Previously approved version (2017/01/24 20:31) is available.Diff
HY000 1 no such column: data_item.published:
SELECT data_item.rid AS rid,
data_item.pid AS PID,
data_item.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_item.col17 AS C0,
data_item.col1 AS C1,
data_item.col2 AS C2,
data_item.col5 AS C3,
data_item.col6 AS C4,
data_item.col7 AS C5,
data_item.col8 AS C6,
data_item.col9 AS C7,
data_item.col10 AS C8,
data_item.col11 AS C9,
STRUCT_JSON(data_item.col12, T2.title) AS C10,
data_item.col4 AS C11
   FROM 
data_item AS data_item
LEFT OUTER JOIN titles AS T2 ON data_item.col12 = T2.pid
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != ''
                    AND data_item.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'item'
  WHERE  ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_item.pid) AND data_item.latest = 1) OR (IS_PUBLISHER(data_item.pid) !=1 AND data_item.published = 1) ) AND ( ( data_item.col17 != '' AND CAST(data_item.col17 AS DECIMAL) >= CAST('0' AS DECIMAL) ) ) )
GROUP BY data_item.pid,
data_item.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11
ORDER BY CAST(data_item.col17 COLLATE NOCASE AS DECIMAL) ASC
SQL execution failed for SELECT data_item.rid AS rid, data_item.pid AS PID, data_item.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_item.col17 AS C0, data_item.col1 AS C1, data_item.col2 AS C2, data_item.col5 AS C3, data_item.col6 AS C4, data_item.col7 AS C5, data_item.col8 AS C6, data_item.col9 AS C7, data_item.col10 AS C8, data_item.col11 AS C9, STRUCT_JSON(data_item.col12, T2.title) AS C10, data_item.col4 AS C11 FROM data_item AS data_item LEFT OUTER JOIN titles AS T2 ON data_item.col12 = T2.pid LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != '' AND data_item.pid = schema_assignments.pid AND schema_assignments.tbl = 'item' WHERE ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND ( (IS_PUBLISHER(data_item.pid) AND data_item.latest = 1) OR (IS_PUBLISHER(data_item.pid) !=1 AND data_item.published = 1) ) AND ( ( data_item.col17 != '' AND CAST(data_item.col17 AS DECIMAL) >= CAST(? AS DECIMAL) ) ) ) GROUP BY data_item.pid, data_item.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11 ORDER BY CAST(data_item.col17 COLLATE NOCASE AS DECIMAL) ASC [Search.php:385]

TR4

catalogues/tr4.txt · Last modified: 2017/02/04 17:32 (external edit)
Back to top
CC Attribution-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0