status

HY000 1 no such column: data_status.rid:
SELECT data_status.rid AS rid,
data_status.pid AS PID,
data_status.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_status.col1 AS C0,
data_status.col2 AS C1,
data_status.col3 AS C2
   FROM 
data_status AS data_status
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_status.pid != ''
                    AND data_status.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'status'
  WHERE  ( ( data_status.pid = '' OR ( GETACCESSLEVEL(data_status.pid) > 0 AND PAGEEXISTS(data_status.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_status.latest = 1 AND ( ( data_status.rid != '' AND CAST(data_status.rid AS DECIMAL) != CAST('0' AS DECIMAL) ) AND data_status.pid REGEXP '^(?![\s\S])' AND ( data_status.rid != '' AND CAST(data_status.rid AS DECIMAL) != CAST('0' AS DECIMAL) ) AND data_status.pid REGEXP '^(?![\s\S])' ) )
GROUP BY data_status.pid,
data_status.rid,
C0,
C1,
C2
SQL execution failed for SELECT data_status.rid AS rid, data_status.pid AS PID, data_status.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_status.col1 AS C0, data_status.col2 AS C1, data_status.col3 AS C2 FROM data_status AS data_status LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_status.pid != '' AND data_status.pid = schema_assignments.pid AND schema_assignments.tbl = 'status' WHERE ( ( data_status.pid = '' OR ( GETACCESSLEVEL(data_status.pid) > 0 AND PAGEEXISTS(data_status.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_status.latest = 1 AND ( ( data_status.rid != '' AND CAST(data_status.rid AS DECIMAL) != CAST(? AS DECIMAL) ) AND data_status.pid REGEXP ? AND ( data_status.rid != '' AND CAST(data_status.rid AS DECIMAL) != CAST(? AS DECIMAL) ) AND data_status.pid REGEXP ? ) ) GROUP BY data_status.pid, data_status.rid, C0, C1, C2 [Search.php:365]
  • status.txt
  • Last modified: 2017/07/08 03:01
  • by wikiadmin