사용자 도구

사이트 도구


사이드바

메뉴:

블로그:

기타:


연락처:


안내:

HY000 1 no such column: data_brevet_event.rid:
SELECT data_brevet_event.rid AS rid,
data_brevet_event.pid AS PID,
data_brevet_event.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_brevet_event.col1 AS C0,
data_brevet_event.col2 AS C1,
data_brevet_event.col3 AS C2,
data_brevet_event.col4 AS C3,
data_brevet_event.col5 AS C4,
data_brevet_event.col6 AS C5,
data_brevet_event.col7 AS C6,
data_brevet_event.col8 AS C7,
data_brevet_event.col9 AS C8,
data_brevet_event.col10 AS C9,
data_brevet_event.col11 AS C10,
data_brevet_event.col12 AS C11,
data_brevet_event.col13 AS C12,
data_brevet_event.col14 AS C13,
data_brevet_event.col15 AS C14,
data_brevet_event.col16 AS C15,
data_brevet_event.col25 AS C16,
data_brevet_event.col17 AS C17,
data_brevet_event.col18 AS C18,
data_brevet_event.col19 AS C19,
data_brevet_event.col24 AS C20,
data_brevet_event.col20 AS C21,
data_brevet_event.col26 AS C22
   FROM 
data_brevet_event AS data_brevet_event
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_brevet_event.pid != ''
                    AND data_brevet_event.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'brevet_event'
  WHERE  ( ( data_brevet_event.pid = '' OR ( GETACCESSLEVEL(data_brevet_event.pid) > 0 AND PAGEEXISTS(data_brevet_event.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_brevet_event.latest = 1 )
GROUP BY data_brevet_event.pid,
data_brevet_event.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11,
C12,
C13,
C14,
C15,
C16,
C17,
C18,
C19,
C20,
C21,
C22
SQL execution failed for SELECT data_brevet_event.rid AS rid, data_brevet_event.pid AS PID, data_brevet_event.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_brevet_event.col1 AS C0, data_brevet_event.col2 AS C1, data_brevet_event.col3 AS C2, data_brevet_event.col4 AS C3, data_brevet_event.col5 AS C4, data_brevet_event.col6 AS C5, data_brevet_event.col7 AS C6, data_brevet_event.col8 AS C7, data_brevet_event.col9 AS C8, data_brevet_event.col10 AS C9, data_brevet_event.col11 AS C10, data_brevet_event.col12 AS C11, data_brevet_event.col13 AS C12, data_brevet_event.col14 AS C13, data_brevet_event.col15 AS C14, data_brevet_event.col16 AS C15, data_brevet_event.col25 AS C16, data_brevet_event.col17 AS C17, data_brevet_event.col18 AS C18, data_brevet_event.col19 AS C19, data_brevet_event.col24 AS C20, data_brevet_event.col20 AS C21, data_brevet_event.col26 AS C22 FROM data_brevet_event AS data_brevet_event LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_brevet_event.pid != '' AND data_brevet_event.pid = schema_assignments.pid AND schema_assignments.tbl = 'brevet_event' WHERE ( ( data_brevet_event.pid = '' OR ( GETACCESSLEVEL(data_brevet_event.pid) > 0 AND PAGEEXISTS(data_brevet_event.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_brevet_event.latest = 1 ) GROUP BY data_brevet_event.pid, data_brevet_event.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22 [Search.php:365]
b:db:event
HY000 1 no such column: data_brevet_event.rid:
SELECT data_brevet_event.rid AS rid,
data_brevet_event.pid AS PID,
data_brevet_event.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_brevet_event.col1 AS C0,
data_brevet_event.col2 AS C1,
data_brevet_event.col3 AS C2,
data_brevet_event.col4 AS C3,
data_brevet_event.col5 AS C4,
data_brevet_event.col6 AS C5,
data_brevet_event.col7 AS C6,
data_brevet_event.col8 AS C7,
data_brevet_event.col9 AS C8,
data_brevet_event.col10 AS C9,
data_brevet_event.col11 AS C10,
data_brevet_event.col12 AS C11,
data_brevet_event.col13 AS C12,
data_brevet_event.col14 AS C13,
data_brevet_event.col15 AS C14,
data_brevet_event.col16 AS C15,
data_brevet_event.col25 AS C16,
data_brevet_event.col17 AS C17,
data_brevet_event.col18 AS C18,
data_brevet_event.col19 AS C19,
data_brevet_event.col24 AS C20,
data_brevet_event.col20 AS C21,
data_brevet_event.col26 AS C22
   FROM 
data_brevet_event AS data_brevet_event
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_brevet_event.pid != ''
                    AND data_brevet_event.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'brevet_event'
  WHERE  ( ( data_brevet_event.pid = '' OR ( GETACCESSLEVEL(data_brevet_event.pid) > 0 AND PAGEEXISTS(data_brevet_event.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_brevet_event.latest = 1 )
GROUP BY data_brevet_event.pid,
data_brevet_event.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11,
C12,
C13,
C14,
C15,
C16,
C17,
C18,
C19,
C20,
C21,
C22
SQL execution failed for SELECT data_brevet_event.rid AS rid, data_brevet_event.pid AS PID, data_brevet_event.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_brevet_event.col1 AS C0, data_brevet_event.col2 AS C1, data_brevet_event.col3 AS C2, data_brevet_event.col4 AS C3, data_brevet_event.col5 AS C4, data_brevet_event.col6 AS C5, data_brevet_event.col7 AS C6, data_brevet_event.col8 AS C7, data_brevet_event.col9 AS C8, data_brevet_event.col10 AS C9, data_brevet_event.col11 AS C10, data_brevet_event.col12 AS C11, data_brevet_event.col13 AS C12, data_brevet_event.col14 AS C13, data_brevet_event.col15 AS C14, data_brevet_event.col16 AS C15, data_brevet_event.col25 AS C16, data_brevet_event.col17 AS C17, data_brevet_event.col18 AS C18, data_brevet_event.col19 AS C19, data_brevet_event.col24 AS C20, data_brevet_event.col20 AS C21, data_brevet_event.col26 AS C22 FROM data_brevet_event AS data_brevet_event LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_brevet_event.pid != '' AND data_brevet_event.pid = schema_assignments.pid AND schema_assignments.tbl = 'brevet_event' WHERE ( ( data_brevet_event.pid = '' OR ( GETACCESSLEVEL(data_brevet_event.pid) > 0 AND PAGEEXISTS(data_brevet_event.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_brevet_event.latest = 1 ) GROUP BY data_brevet_event.pid, data_brevet_event.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22 [Search.php:365]

event

b/db/event.txt · 마지막으로 수정됨: 2020-01-14 13:20 저자 neoocean