hi @stararmy ,
sorry, took a while. couldn't mess with the wiki in the middle of a project.
gave updating another shot, since the official release is out. unfortunatelly, I still have issues with the update.
stararmy What does the lengthy error message say?
here you go... 🙂
no idea what DW is missing.
HY000 1 no such column: data_tri_bricks.rid:
SELECT data_tri_bricks.rid AS rid,
data_tri_bricks.pid AS PID,
data_tri_bricks.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_tri_bricks.pid AS C0,
data_tri_bricks.col40 AS C1,
data_tri_bricks.col3 AS C2,
data_tri_bricks.col42 AS C3,
data_tri_bricks.col4 AS C4,
data_tri_bricks.col6 AS C5,
data_tri_bricks.col8 AS C6,
data_tri_bricks.col10 AS C7,
data_tri_bricks.col12 AS C8,
data_tri_bricks.col13 AS C9,
data_tri_bricks.col14 AS C10,
data_tri_bricks.col16 AS C11,
data_tri_bricks.col18 AS C12,
data_tri_bricks.col20 AS C13,
data_tri_bricks.col21 AS C14,
data_tri_bricks.col23 AS C15,
data_tri_bricks.col24 AS C16,
data_tri_bricks.col25 AS C17,
data_tri_bricks.col27 AS C18,
data_tri_bricks.col28 AS C19,
data_tri_bricks.col31 AS C20,
data_tri_bricks.col32 AS C21,
data_tri_bricks.col33 AS C22,
data_tri_bricks.col34 AS C23,
data_tri_bricks.col36 AS C24,
data_tri_bricks.col37 AS C25,
data_tri_bricks.col38 AS C26,
data_tri_bricks.col39 AS C27
FROM
data_tri_bricks AS data_tri_bricks
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_tri_bricks.pid != ''
AND data_tri_bricks.pid = schema_assignments.pid
AND schema_assignments.tbl = 'tri_bricks'
WHERE ( ( data_tri_bricks.pid = '' OR ( GETACCESSLEVEL(data_tri_bricks.pid) > 0 AND PAGEEXISTS(data_tri_bricks.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_tri_bricks.latest = 1 )
GROUP BY data_tri_bricks.pid,
data_tri_bricks.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11,
C12,
C13,
C14,
C15,
C16,
C17,
C18,
C19,
C20,
C21,
C22,
C23,
C24,
C25,
C26,
C27
SQL execution failed for SELECT data_tri_bricks.rid AS rid, data_tri_bricks.pid AS PID, data_tri_bricks.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_tri_bricks.pid AS C0, data_tri_bricks.col40 AS C1, data_tri_bricks.col3 AS C2, data_tri_bricks.col42 AS C3, data_tri_bricks.col4 AS C4, data_tri_bricks.col6 AS C5, data_tri_bricks.col8 AS C6, data_tri_bricks.col10 AS C7, data_tri_bricks.col12 AS C8, data_tri_bricks.col13 AS C9, data_tri_bricks.col14 AS C10, data_tri_bricks.col16 AS C11, data_tri_bricks.col18 AS C12, data_tri_bricks.col20 AS C13, data_tri_bricks.col21 AS C14, data_tri_bricks.col23 AS C15, data_tri_bricks.col24 AS C16, data_tri_bricks.col25 AS C17, data_tri_bricks.col27 AS C18, data_tri_bricks.col28 AS C19, data_tri_bricks.col31 AS C20, data_tri_bricks.col32 AS C21, data_tri_bricks.col33 AS C22, data_tri_bricks.col34 AS C23, data_tri_bricks.col36 AS C24, data_tri_bricks.col37 AS C25, data_tri_bricks.col38 AS C26, data_tri_bricks.col39 AS C27 FROM data_tri_bricks AS data_tri_bricks LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_tri_bricks.pid != '' AND data_tri_bricks.pid = schema_assignments.pid AND schema_assignments.tbl = 'tri_bricks' WHERE ( ( data_tri_bricks.pid = '' OR ( GETACCESSLEVEL(data_tri_bricks.pid) > 0 AND PAGEEXISTS(data_tri_bricks.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_tri_bricks.latest = 1 ) GROUP BY data_tri_bricks.pid, data_tri_bricks.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22, C23, C24, C25, C26, C27 [Search.php:365]