Difference between revisions of "User:Sancho/test/childs"
m (test) |
m (test) |
||
Line 1: | Line 1: | ||
<DPL> | <DPL> | ||
debug = 0 | debug = 0 | ||
− | linksto = | + | linksto = %%FULLPAGENAME%% |
titleregexp = RU/kb/[0-9] | titleregexp = RU/kb/[0-9] | ||
format={| class="wikitable sortable" style="width: 100%;"\n!Для сортировки по алфавиту нажать → ,\n|-\n|{{SecTitle|%PAGE%}},,\n|} | format={| class="wikitable sortable" style="width: 100%;"\n!Для сортировки по алфавиту нажать → ,\n|-\n|{{SecTitle|%PAGE%}},,\n|} | ||
</DPL> | </DPL> |
Revision as of 10:02, 9 December 2010
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 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=0 AND pl.pl_title LIKE '%\\%\\FULLPAGENAME%\\%')) 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)