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

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `Game` AS `Game` FROM `cargo__Assignments` WHERE PageID="152007" AND Status = "available" ORDER BY `Game` LIMIT 1 Function: CargoSQLQuery::run Error: 1054 Unknown column 'PageID' in 'where clause' (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)