Difference between revisions of "Template:DE/TopTenViews"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (regex korrigiert)
m (Layout)
Line 1: Line 1:
<div style="border: 1px solid #999; padding: 5px; border-bottom: none; background: #EEE; font-size: 120%; font-weight: bold;">Top 10 DE-Seiten</div>
+
<div style="border:1px solid #aaaaaa; background-color:#f8f8f8; font-size: 95%;">
 +
<div style="padding: 0.7em">
 +
  <div style="text-align: center; background-color:#dce9fc; padding: 0.7em">'''''Top 10 DE-Seiten'''''</div>
 +
</div>
 +
</div>
 
<div style="font-size:85%; padding: 0;">
 
<div style="font-size:85%; padding: 0;">
  
Line 17: Line 21:
 
</div>
 
</div>
  
<div style="border: 1px solid #999; padding: 5px; background: #EEE; font-size: 120%; font-weight: bold;">Zuletzt bearbeitete DE-Seiten</div>
+
 
 +
<div style="border:1px solid #aaaaaa; background-color:#f8f8f8; font-size: 95%;">
 +
<div style="padding: 0.7em">
 +
  <div style="text-align: center; background-color:#dce9fc; padding: 0.7em">'''''Zuletzt bearbeitete DE-Seiten'''''</div>
 +
</div>
 +
</div>
 +
 
 
<div style="border:1px solid #999; border-top: none; padding: 8px 5px; font-size:85%; ">
 
<div style="border:1px solid #999; border-top: none; padding: 8px 5px; font-size:85%; ">
  
Line 33: Line 43:
 
</DPL>
 
</DPL>
  
 +
</div>
 
</div>
 
</div>
 
<noinclude>
 
<noinclude>
 
[[Category:DE/Wiki-Templates]]
 
[[Category:DE/Wiki-Templates]]
 
</noinclude>
 
</noinclude>

Revision as of 20:36, 5 May 2010

Top 10 DE-Seiten

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 FROM `page` WHERE 1=1 AND `page`.page_namespace IN (0) AND (`page`.page_title REGEXP '^DE.*$') AND `page`.page_is_redirect=0 ORDER BY page_counter DESC LIMIT 10 OFFSET 0

Error message is:
Unknown column 'page.page_counter' in 'field list' (127.0.0.1)



Zuletzt bearbeitete DE-Seiten

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, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `page` WHERE 1=1 AND `page`.page_namespace IN (0) AND (`page`.page_title REGEXP '^DE.*$') 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 20 OFFSET 0

Error message is:
Unknown column 'rev_user' in 'field list' (127.0.0.1)


Personal tools