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

Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

PCGamingWiki:GOG.com Enhancement Project/Completion

From PCGamingWiki, the wiki about fixing PC games
< PCGamingWiki:GOG.com Enhancement Project
Revision as of 19:11, 15 June 2023 by Aemony (talk | contribs) (|group by=Infobox_game._pageNamespace)

Total number of games: 4,625

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pcgamingwiki_cargo.cargo__Infobox_game._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)

Function: CargoSQLQuery::run Query: SELECT `cargo__Infobox_game`.`_pageName` AS `_pageName`,`cargo__Infobox_game`.`Cover` AS `Cover`,`cargo__Tags`.`Stub` AS `Stub`,`cargo__Tags`.`Tickcross_unknown` AS `Tickcross unknown`,`cargo__Tags`.`Config_data` AS `Config data`,`cargo__Tags`.`Save_data` AS `Save data`,`cargo__Tags`.`Settings_screenshots` AS `Settings screenshots`,`cargo__Tags`.`Video_screenshots` AS `Video screenshots`,`cargo__Tags`.`Input_screenshots` AS `Input screenshots`,`cargo__Tags`.`Audio_screenshots` AS `Audio screenshots`,`cargo__Tags`.`Network_screenshots` AS `Network screenshots`,`cargo__Tags`.`VR_screenshots` AS `VR screenshots` FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Tags`.`_pageName`)) WHERE `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__GOGcom_ID` WHERE `_value`LIKE '%') AND `cargo__Tags`.`Tickcross_unknown` > 0 GROUP BY `cargo__Infobox_game`.`_pageNamespace` ORDER BY `cargo__Infobox_game`.`_pageName`,`cargo__Infobox_game`.`Cover`,`cargo__Tags`.`Stub`,`cargo__Tags`.`Tickcross_unknown`,`cargo__Tags`.`Config_data` LIMIT 500