用户:Fmwang

来自Chahaoba

2009年3月新任管理员。

Fmwang的2009年03月01日编辑进度

The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `jinglepage`.page_namespace AS page_namespace,`jinglepage`.page_title AS page_title,`jinglepage`.page_id AS page_id, rev_user, rev_user_text, rev_comment, rev_timestamp, rev_id FROM `jinglerevision` AS rev, `jinglepage` WHERE 1=1 AND `jinglepage`.page_is_redirect=0 AND `jinglepage`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `jinglerevision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) AND 'Fmwang' = (SELECT rev_user_text FROM `jinglerevision` WHERE `jinglerevision`.rev_page=page_id ORDER BY `jinglerevision`.rev_timestamp DESC LIMIT 1) AND `jinglepage`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux_bef.rev_timestamp) FROM `jinglerevision` AS rev_aux_bef WHERE rev_aux_bef.rev_page=rev.rev_page AND rev_aux_bef.rev_timestamp < 20090302080000) AND `jinglepage`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MIN(rev_aux_snc.rev_timestamp) FROM `jinglerevision` AS rev_aux_snc WHERE rev_aux_snc.rev_page=rev.rev_page AND rev_aux_snc.rev_timestamp >= 20090301080000) ORDER BY rev_timestamp ASC LIMIT 200 OFFSET 0

Error message is:
Unknown column 'rev_user' in 'field list' (rm-m5ex67j9esr51k99f436.mysql.rds.aliyuncs.com)