Statistics of activity on the wiki

From Apache OpenOffice Wiki
< Wiki
Revision as of 14:27, 16 April 2011 by Sancho (talk | contribs) (New)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search




Top National Zones

Rating national zones

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 LIKE 'RU' OR `page`.page_title LIKE 'Bg' OR `page`.page_title LIKE 'DE' OR `page`.page_title LIKE 'ES' OR `page`.page_title LIKE 'Farsi' OR `page`.page_title LIKE 'FR' OR `page`.page_title LIKE 'IT' OR `page`.page_title LIKE 'JA' OR `page`.page_title LIKE 'JA/' OR `page`.page_title LIKE 'KO' OR `page`.page_title LIKE 'MN' OR `page`.page_title LIKE 'NL' OR `page`.page_title LIKE 'OC' OR `page`.page_title LIKE 'PL' OR `page`.page_title LIKE 'PT' OR `page`.page_title LIKE 'SV' OR `page`.page_title LIKE 'TH' OR `page`.page_title LIKE 'Zh') AND `page`.page_is_redirect=0 ORDER BY page_counter DESC LIMIT 30 OFFSET 0

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


Top Ten Views

Top 10 Pages

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_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)



Last Edited Pages

Last Edited Pages

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_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