Difference between revisions of "Template:Assignment/checkAvailable"
From PCGamingWiki, the wiki about fixing PC games
m (single quotes -> double quotes to prevent SQL errors when single quotes are used in the page name) |
m (changed WHERE to use {{PAGEID}} instead) |
||
Line 2: | Line 2: | ||
tables=Assignments | tables=Assignments | ||
|fields=Game | |fields=Game | ||
− | |where= | + | |where=PageID="{{PAGEID}}" AND Status = "available" |
|limit=1 | |limit=1 | ||
|format=template | |format=template |
Revision as of 13:41, 15 July 2020
Error 1054: Unknown column 'PageID' in 'where clause' (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)
Function: CargoSQLQuery::run Query: SELECT `cargo__Assignments`.`_pageID` AS `cargo_backlink_page_id_Assignments`,`Game` AS `Game` FROM `cargo__Assignments` WHERE PageID="152007" AND Status = "available" ORDER BY `cargo__Assignments`.`_pageID`,`Game` LIMIT 100