HY000 1 no such column: data_item.rid:

SELECT data_item.rid AS rid,
data_item.pid AS PID,
data_item.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_item.col16 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, T1.title) AS C10,
data_item.col4 AS C11
   FROM 
data_item AS data_item
LEFT OUTER JOIN titles AS T1 ON data_item.col12 = T1.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 data_item.latest = 1 AND ( ( data_item.col16 != '' AND CAST(data_item.col16 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.col16 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.col16 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, T1.title) AS C10, data_item.col4 AS C11 FROM data_item AS data_item LEFT OUTER JOIN titles AS T1 ON data_item.col12 = T1.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 data_item.latest = 1 AND ( ( data_item.col16 != '' AND CAST(data_item.col16 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.col16 COLLATE NOCASE AS DECIMAL) ASC [Search.php:365]

You are here: TRWiki » Catalogues » TR3

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

catalogues:tr3 [2017/02/04 17:29] stohrendorf ↷ Page moved from catalogues:tr3 to trs:savegame:catalogues:tr3		catalogues:tr3 [2017/02/04 17:32] (current) stohrendorf ↷ Page moved from trs:savegame:catalogues:tr3 to catalogues:tr3
Both sides previous revision Previous revision Next revision		Previous revision

catalogues/tr3.txt · Last modified: 2017/02/04 17:32 (external edit)