Projekte Neu: Unterschied zwischen den Versionen
| Zeile 5: | Zeile 5: | ||
addeditdate=true | addeditdate=true | ||
addpagecounter=true | addpagecounter=true | ||
| − | include=%1[ | + | include=%1[50] |
| − | + | includetrim=true | |
| − | |||
userdateformat=Y-m-d | userdateformat=Y-m-d | ||
| + | mode = userformat | ||
| + | format= {|class="wikitable sortable"¶!projects¶!excerpt¶!last edit¶!page count,¶|-¶|[[%PAGE%]] ¶,¶,¶|} | ||
| + | secseparators = \n|, \n|align="right"|%DATE% \n|align="right"|%COUNT% | ||
</DPL> | </DPL> | ||
Version vom 5. Mai 2012, 01:26 Uhr
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 `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_counter AS page_counter, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Projekte') WHERE 1=1 AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp DESC LIMIT 500 OFFSET 0
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
