Difference between revisions of "User:Sancho/test/tema"
(Section -> SecTitle, +sortable) |
(Исправлена опечатка) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | <section begin=title /><section begin=rus />{{#vardefine:rustxt|Тема. яяя}}<section end=rus /> | ||
| + | <section begin=lat />{{#vardefine:lattxt|Tema. zzzz}}<section end=lat /> | ||
| + | <noinclude>{{DISPLAYTITLE:</noinclude>{{#var: rustxt}}{{Doc/doc/code/tbl/titleSeparator}}{{#var: lattxt}}<noinclude>}}</noinclude><section end=title /> | ||
| + | {{BreadCrumbL10n}} | ||
| + | __NOTOC__ | ||
| + | |||
| + | DPL1: | ||
| + | |||
| + | {{RuTableArt}} | ||
| + | |||
| + | |||
| + | DPL2: | ||
| + | |||
<DPL> | <DPL> | ||
| − | |||
category = RU/Sancho/test | category = RU/Sancho/test | ||
notcategory = Special_Page|RU/kb/Служебные_страницы|Candidates_for_speedy_deletion | notcategory = Special_Page|RU/kb/Служебные_страницы|Candidates_for_speedy_deletion | ||
nottitlematch = RU/kb/index|RU/kb/index/10 | nottitlematch = RU/kb/index|RU/kb/index/10 | ||
| + | |||
| + | titlematch = %Sancho/test/0% | ||
| + | linksto = User:Sancho/test/tema | ||
| + | |||
| + | count = 90 | ||
ordermethod = counter | ordermethod = counter | ||
order = descending | order = descending | ||
Latest revision as of 19:06, 13 December 2010
DPL1:
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, pl.pl_title AS sel_title, pl.pl_namespace AS sel_ns, `page`.page_title as sortkey, `page`.page_counter AS page_counter FROM `pagelinks` AS pl, `page` WHERE 1=1 AND (`page`.page_title REGEXP 'RU/kb/[0-9]') AND `page`.page_is_redirect=0 AND `page`.page_id=pl.pl_from AND ( (pl.pl_namespace=2 AND pl.pl_title LIKE 'Sancho/test/tema')) ORDER BY page_title ASC LIMIT 0, 500
Error message is:
Character set 'utf8mb3_bin' cannot be used in conjunction with 'binary' in call to regexp_like. (127.0.0.1)
DPL2:
| Позиция | Страница | Просмотров |
|---|---|---|
| 1 | Тест. 00000000 | 192 |
| 2 | Тест. 00000001 | 127 |
