“模板:最新日志”的版本间的差异
| 第11行： | 第11行： | ||
order=descending | order=descending | ||
namespace= | namespace= | ||
| + | mode=ordered | ||
</DPL> | </DPL> | ||
2009年1月3日 (六) 12:47的版本
最新日志
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, `jinglepage`.page_counter AS page_counter, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `jinglerevision` AS rev, `jinglepage` INNER JOIN `jinglecategorylinks` AS cl0 ON `jinglepage`.page_id=cl0.cl_from AND (cl0.cl_to='日志') LEFT OUTER JOIN `jinglecategorylinks` AS cl1 ON `jinglepage`.page_id=cl1.cl_from AND cl1.cl_to='同义页面' WHERE 1=1 AND cl1.cl_to IS NULL AND `jinglepage`.page_namespace IN ('0') AND `jinglepage`.page_is_redirect=0 AND `jinglepage`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MIN(rev_aux.rev_timestamp) FROM `jinglerevision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp DESC LIMIT 20 OFFSET 0
Error message is:
Unknown column 'jinglepage.page_counter' in 'field list' (rm-m5ep3q0684h4hfogh.mysql.rds.aliyuncs.com)
