User:Aramachus/Sandbox: Difference between revisions
imported>Aramachus cleared |
imported>Aramachus list of npcs |
||
| Line 1: | Line 1: | ||
{{#dpl: |
|||
|category=NPCs |
|||
|include={NPC}:type:occupation:location |
|||
|table=class="horizon-table sortable",Name,Type,Occupation,Location |
|||
|notnamespace=Category |
|||
|notnamespace=Template |
|||
}} |
|||
Revision as of 11:58, 6 August 2024
Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Sandbox: The DynamicPageList4 extension (version 4.0.0) produced a SQL statement which led to a Database error.<br/>The reason may be an internal error of DynamicPageList4 or an error that you made; especially when using parameters like 'categoryregexp' or 'titleregexp'. Usage of non-greedy <code>*?</code> matching patterns are not supported.<br/>The error message was:<br/><code>Error 1054: Unknown column 'cl1.cl_to' in 'ON' Function: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Sandbox Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT p.page_namespace AS `page_namespace`,p.page_id AS `page_id`,p.page_title AS `page_title` FROM `page` `p` JOIN `categorylinks` `cl1` ON (((p.page_id = cl1.cl_from) AND (cl1.cl_to = 'NPCs'))) WHERE p.page_is_redirect = 0 AND (p.page_namespace NOT IN (14,10)) LIMIT 500 </code>