Difference between revisions of "BulletPointBootlegList"

From Sega Retro

Line 4: Line 4:
 
|where=distributor="{{FormatSQL|{{{1|{{PAGENAME}}}}}}}"
 
|where=distributor="{{FormatSQL|{{{1|{{PAGENAME}}}}}}}"
 
|limit=10000
 
|limit=10000
|order by=name
+
|order by=sortkey
 
|group by={{#if:{{#var:multicarts}}|code|pagename}}
 
|group by={{#if:{{#var:multicarts}}|code|pagename}}
 
|format=template
 
|format=template

Revision as of 15:56, 4 June 2023

{{BulletPointBootlegList|New Game}}
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `pagename` AS `pagename`,`name` AS `name`,`name2` AS `name2`,`code` AS `code` FROM `cargo__bootlegs` WHERE distributor="New Game" GROUP BY `pagename` ORDER BY `sortkey` LIMIT 5000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'sortkey' in 'order clause' (localhost)