Projekte Neu: Unterschied zwischen den Versionen

aus Metalab, dem offenen Zentrum für meta-disziplinäre Magier und technisch-kreative Enthusiasten.
Wechseln zu: Navigation, Suche
K (verschob „Sandbox“ nach „Projekte Neu“)
(2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
 
<DPL>
 
<DPL>
 
   category=Projekte
 
   category=Projekte
 +
  notcategory = Archiv
 +
  notnamespace = Archiv
 
   ordermethod=lastedit
 
   ordermethod=lastedit
 
   order=descending
 
   order=descending
 
   addeditdate=true
 
   addeditdate=true
 
   addpagecounter=true
 
   addpagecounter=true
   include=%1[100]
+
   include=%1[50]
   table= class=wikitable sortable, , excerpt, last edit, popularity
+
   includetrim=true
  tablerow= ,,%DATE%, %COUNT%
 
 
   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 12. Mai 2012, 20:46 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') LEFT OUTER JOIN `categorylinks` AS cl1 ON `page`.page_id=cl1.cl_from AND cl1.cl_to='Archiv' WHERE 1=1 AND cl1.cl_to IS NULL AND `page`.page_namespace NOT IN ('100') 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)