사용자 도구

사이트 도구


사이드바

메뉴:

블로그:

기타:


연락처:


안내:

HY000 1 no such column: data_brevet_course.rid:
SELECT data_brevet_course.rid AS rid,
data_brevet_course.pid AS PID,
data_brevet_course.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_brevet_course.col1 AS C0,
data_brevet_course.col2 AS C1,
data_brevet_course.col3 AS C2,
data_brevet_course.col4 AS C3,
data_brevet_course.col5 AS C4,
data_brevet_course.col6 AS C5
   FROM 
data_brevet_course AS data_brevet_course
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_brevet_course.pid != ''
                    AND data_brevet_course.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'brevet_course'
  WHERE  ( ( data_brevet_course.pid = '' OR ( GETACCESSLEVEL(data_brevet_course.pid) > 0 AND PAGEEXISTS(data_brevet_course.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_brevet_course.latest = 1 )
GROUP BY data_brevet_course.pid,
data_brevet_course.rid,
C0,
C1,
C2,
C3,
C4,
C5
SQL execution failed for SELECT data_brevet_course.rid AS rid, data_brevet_course.pid AS PID, data_brevet_course.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_brevet_course.col1 AS C0, data_brevet_course.col2 AS C1, data_brevet_course.col3 AS C2, data_brevet_course.col4 AS C3, data_brevet_course.col5 AS C4, data_brevet_course.col6 AS C5 FROM data_brevet_course AS data_brevet_course LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_brevet_course.pid != '' AND data_brevet_course.pid = schema_assignments.pid AND schema_assignments.tbl = 'brevet_course' WHERE ( ( data_brevet_course.pid = '' OR ( GETACCESSLEVEL(data_brevet_course.pid) > 0 AND PAGEEXISTS(data_brevet_course.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_brevet_course.latest = 1 ) GROUP BY data_brevet_course.pid, data_brevet_course.rid, C0, C1, C2, C3, C4, C5 [Search.php:365]
b:db:course

course

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