Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

column reference "page_title" is ambiguous #282

Open
OatmealDome opened this issue Jul 15, 2024 · 0 comments
Open

column reference "page_title" is ambiguous #282

OatmealDome opened this issue Jul 15, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@OatmealDome
Copy link

DynamicPageList3 version: 3.5.1
MediaWiki version: 1.39.8
PHP version: 7.4.33

List of steps to reproduce (step by step, including full links if applicable):

Attempt to use the following transclusion (used on https://wiki.dolphin-emu.org/index.php?title=Template:Navigation/Super_Mario):

{{#dpl:linksfrom=Template:Navigation/Super Mario/doc|notuses=Template:Navigation/Super Mario|notcategory=Navigation|notcategory=Platforms|notcategory=Series|reset=all}} 

What happens?:

The following database error occurs:

Error 42702: ERROR: column reference "page_title" is ambiguous
LINE 1: ...l2.cl_to IS NULL AND ecl3.cl_to IS NULL GROUP BY page_title...
^

Function: MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - Template:Navigation-Super_Mario
Query: SELECT DISTINCT pagesrc.page_title AS "sel_title",pagesrc.page_namespace AS "sel_ns","page".page_namespace AS "page_namespace","page".page_id AS "page_id","page".page_title AS "page_title" FROM "pagelinks" "plf","page" "pagesrc","page" LEFT OUTER JOIN "categorylinks" "ecl1" ON (("page".page_id = ecl1.cl_from AND ecl1.cl_to ='Navigation')) LEFT OUTER JOIN "categorylinks" "ecl2" ON (("page".page_id = ecl2.cl_from AND ecl2.cl_to ='Platforms')) LEFT OUTER JOIN "categorylinks" "ecl3" ON (("page".page_id = ecl3.cl_from AND ecl3.cl_to ='Series')) WHERE "page".page_is_redirect = 0 AND ("page".page_namespace = plf.pl_namespace) AND ("page".page_title = plf.pl_title) AND (pagesrc.page_id = plf.pl_from) AND ((plf.pl_from = 28269)) AND ("page".page_id NOT IN (SELECT "templatelinks".tl_from FROM "templatelinks" INNER JOIN "linktarget" ON "linktarget".lt_id = "templatelinks".tl_target_id WHERE (("linktarget".lt_namespace=10 AND "linktarget".lt_title = 'Navigation/Super_Mario')))) AND ecl1.cl_to IS NULL AND ecl2.cl_to IS NULL AND ecl3.cl_to IS NULL GROUP BY page_title LIMIT 500 OFFSET 0

What should have happened instead?:

An error does not occur.

Browser information, screenshots and other applicable information:

Updating to 3.5.2 results in a similar, but separate error that breaks all of our pages. I'll file a bug report for that later.

@OatmealDome OatmealDome added the bug Something isn't working label Jul 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant