FANDOM


Example 1

This is what happens with a valid parameter:


Example 2

This is what happens an invalid parameter:

Extension:DynamicPageList (DPL), version 2.3.0 : Warning: Wrong 'ordermethod' parameter: 'invalid'! Using default: 'titlewithoutnamespace'. Help: ordermethod= category | category,firstedit | category,lastedit | category,pagetouched | category,sortkey | categoryadd | counter | firstedit | lastedit | none | pagesel | pagetouched | size | sortkey | title | titlewithoutnamespace | user | user,firstedit | user,lastedit.

Note that the list of valid parameters explicitly mentions that "counter" is valid.

Example 3

This is what happens when someone decides they want to "retire" a parameter, but only removes the use in the SQL query, and doesn't bother to change the input validation and help text to reflect that the parameter is not longer valid.

AKA, a mistake a first-year student would do, and a mistake a first-year student would find during rudimentary bug-testing.

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 FROM `page` WHERE 1=1 AND `page`.page_namespace IN ('0') AND `page`.page_is_redirect=0 ORDER BY ASC LIMIT 1 OFFSET 0

Error message is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 1 OFFSET 0' at line 1 (geo-db-e-slave.query.consul)


Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.