Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

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=Game="{{{1|}}}" AND Status = "available"
+
|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