User talk:SBEyes
- Archives
Database error[edit source]
A problem has occured on Triggered effect page. Whenever I try to open this page it says: "A database query error has occured. This may indicate a bug in the software." Beneath it writes the error code: "[7be62ebdc0295c37ca3bbd2e] 2018-08-27 11:19:46: Fatal exception of type "Wikimedia\Rdbms\DBQueryError". River235 (talk) 11:25, 27 August 2018 (UTC)
- Should be working now. — oOeyes 02:59, 28 August 2018 (UTC)
Table conversions[edit source]
Just noting here that the converted table templates are {{Custom spell card table}}, {{Custom weapon card table}}, and {{Custom minion card table}}. Some uses of {{List cards}} may be affected as well. — oOeyes 04:24, 22 May 2018 (UTC)
- {{Custom card table}} is now converted to use Cargo. This is the most widely used table template, I believe, so any problems are most likely to show up now. — oOeyes 08:04, 31 May 2018 (UTC)
Art page problems[edit source]
Everything on this page is broken. Yeti art Whatisacore (talk) 01:12, 16 June 2018 (UTC)
- So are these pages: Virmen art, Uncategorized art, Tuskarr, Trogg, Pandaren art, Quilboar art, Saurok art, Tol'vir art, Tortollan, Naga art, Ogre, Old God, Jinyu art, Kobold art, Kvaldir, Mogu art, Dwarf, Ethereal art, Gnome, Goblin, Harpy art, Hozen art, Arakkoa art, Draenei. Many other pages don't show query errors but instead are missing the tables altogether and are pretty much empty where there should be content. Whatisacore (talk) 01:20, 16 June 2018 (UTC)
- {{List card art}} needed a workaround set up. I had known one of these templates was going to need it, but I had forgotten which one. Should be good when the pages catch up to the changes. — oOeyes 19:45, 16 June 2018 (UTC)
- So are these pages: Virmen art, Uncategorized art, Tuskarr, Trogg, Pandaren art, Quilboar art, Saurok art, Tol'vir art, Tortollan, Naga art, Ogre, Old God, Jinyu art, Kobold art, Kvaldir, Mogu art, Dwarf, Ethereal art, Gnome, Goblin, Harpy art, Hozen art, Arakkoa art, Draenei. Many other pages don't show query errors but instead are missing the tables altogether and are pretty much empty where there should be content. Whatisacore (talk) 01:20, 16 June 2018 (UTC)
Card pages[edit source]
Issue with the possible cards toki, time tinker can target. The card tables of the Naxxramas card list are incorrect. Adventure bosses, boss cards, and boss hero powers all appear in the list of collectible cards. I do not know if other card list pages are affected as well. -- BigHugger (talk) 08:36, 17 June 2018 (UTC)
- There were two different mistakes to correct. The first was that I neglected to make Category:Card data default in the queries like it was before, which is now done. The second is that I didn't make a corresponding column to Property:Is of regular card type. Fixing that would require me to regenerate the Cards table and break everything for a while, so I instead changed the logic for setting the collectible flag in a way I think will return the same results as before, but I'm not 100% sure it will in every case. — oOeyes 20:39, 17 June 2018 (UTC)
Tables on Matthew Mercer's page are broken[edit source]
On the page "Matthew Mercer" (I can't link it because I'm a new user) the table "Template:List cards/Voice" under the header "Matthew Mercer" is broken, and so is "Template:Wp" under External Links.
173.75.32.189 06:33, 2 July 2018 (UTC)
Card Infobox[edit source]
Appears to be majorly broken at the moment, not sure who else to notify really, but I'd consider this an emergency situation, as multiple card pages aren't readable, and every one is displaying the unspecified datapage error. --Bannanawaffles (talk) 17:12, 14 July 2018 (UTC)
- I think I've fixed the problem, but a bot run is needed to force everything to update. Probably won't know for sure until it's done. — oOeyes 23:52, 14 July 2018 (UTC)
- Looks like things are good now. — oOeyes 07:27, 16 July 2018 (UTC)
- Some cards still need null refreshes, but yes it seems all fixed now. Aegonostic (talk) 17:01, 16 July 2018 (UTC)
Card counts not working[edit source]
{{Custom card count}} seems to be malfunctioning.
The card counts from {{Custom card count}} are different from the real card counts. The real card counts can be found in Card set#List.
I tried seeing why the Hall of Fame cards were showing up as "10" instead of "13", but it seems all the cards appear to be correctly classified as being in the "Hall of Fame" set. I think that the template showed Hall of Fame having the correct number of cards back some months ago.
Only Blackrock Mountain gives the correct card count, surprisingly.
- Standard
- Basic collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("B","a","s","i","c")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pag' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("B","a","s","i","c")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 133
- Classic collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("C","l","a","s","s","i","c")) ORDER BY COUNT(DISTINCT `cargo__Card' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("C","l","a","s","s","i","c")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 236
- Journey to Un'Goro collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("J","o","u","r","n","e","y"," ","t","o"," ","U","n","'","G","o","r"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("J","o","u","r","n","e","y"," ","t","o"," ","U","n","'","G","o","r","o")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 135
- Knights of the Frozen Throne collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("K","n","i","g","h","t","s"," ","o","f"," ","t","h","e"," ","F","r"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("K","n","i","g","h","t","s"," ","o","f"," ","t","h","e"," ","F","r","o","z","e","n"," ","T","h","r","o","n","e")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 135
- Kobolds and Catacombs collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("K","o","b","o","l","d","s"," ","a","n","d"," ","C","a","t","a","c"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("K","o","b","o","l","d","s"," ","a","n","d"," ","C","a","t","a","c","o","m","b","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 135
- The Witchwood collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("T","h","e"," ","W","i","t","c","h","w","o","o","d")) ORDER BY COU' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","W","i","t","c","h","w","o","o","d")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
/ Should be 135
- The Boomsday Project collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("T","h","e"," ","B","o","o","m","s","d","a","y"," ","P","r","o","j"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","B","o","o","m","s","d","a","y"," ","P","r","o","j","e","c","t")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 135 (once all cards are revealed)
- The Boomsday Project collectible cards with added category "Upcoming": Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("T","h","e"," ","B","o","o","m","s","d","a","y"," ","P","r","o","j"' at line 1
- The Boomsday Project collectible cards with added category "Upcoming":
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Upcoming_card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","B","o","o","m","s","d","a","y"," ","P","r","o","j","e","c","t")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
- Wild
- Naxxramas collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("N","a","x","x","r","a","m","a","s")) ORDER BY COUNT(DISTINCT `car' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("N","a","x","x","r","a","m","a","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 30
- Goblins vs Gnomes collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("G","o","b","l","i","n","s"," ","v","s"," ","G","n","o","m","e","s"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("G","o","b","l","i","n","s"," ","v","s"," ","G","n","o","m","e","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 123
- Blackrock Mountain collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("B","l","a","c","k","r","o","c","k"," ","M","o","u","n","t","a","i"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("B","l","a","c","k","r","o","c","k"," ","M","o","u","n","t","a","i","n")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 31
- The Grand Tournament collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("T","h","e"," ","G","r","a","n","d"," ","T","o","u","r","n","a","m"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","G","r","a","n","d"," ","T","o","u","r","n","a","m","e","n","t")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 132
- The League of Explorers collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("T","h","e"," ","L","e","a","g","u","e"," ","o","f"," ","E","x","p"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","L","e","a","g","u","e"," ","o","f"," ","E","x","p","l","o","r","e","r","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 45
- Whispers of the Old Gods collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("W","h","i","s","p","e","r","s"," ","o","f"," ","t","h","e"," ","O"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("W","h","i","s","p","e","r","s"," ","o","f"," ","t","h","e"," ","O","l","d"," ","G","o","d","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 134
- One Night in Karazhan collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("O","n","e"," ","N","i","g","h","t"," ","i","n"," ","K","a","r","a"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("O","n","e"," ","N","i","g","h","t"," ","i","n"," ","K","a","r","a","z","h","a","n")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 45
- Mean Streets of Gadgetzan collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("M","e","a","n"," ","S","t","r","e","e","t","s"," ","o","f"," ","G"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("M","e","a","n"," ","S","t","r","e","e","t","s"," ","o","f"," ","G","a","d","g","e","t","z","a","n")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 132
- Hall of Fame collectible cards: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("H","a","l","l"," ","o","f"," ","F","a","m","e")) ORDER BY COUNT(D' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("H","a","l","l"," ","o","f"," ","F","a","m","e")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
// Should be 13
Aegonostic (talk) 16:58, 16 July 2018 (UTC)
- It was still using the Semantic MediaWiki data, and that seemed to be at least partially hosed after Friday's conversion work. I've converted it to Cargo... and there are still small errors. I doubt that's Custom card count; it's probably cache-related or actual errors in the data somehow. I have the bot running again in case it's caching. That takes a while these days, so I'll check back tonight to see if the bot run resolves them. — oOeyes 10:19, 17 July 2018 (UTC)
- Okay, I went through Knights of the Frozen Throne card by card. The missing one appeared to be only the result of an ambiguous card infobox usage. Found some rarity errors too, though that doesn't affect the count. I don't have the time to do this with every card set showing an incorrect count, but I think it's a safe bet the remaining problems are in the actual data. — oOeyes 05:54, 18 July 2018 (UTC)
- Oh, also, Boomsday needs
|category=Upcoming
added on to show any count:Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS CONCAT("T","h","e"," ","B","o","o","m","s","d","a","y"," ","P","r","o","j"' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Upcoming_card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","B","o","o","m","s","d","a","y"," ","P","r","o","j","e","c","t")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
— oOeyes 05:56, 18 July 2018 (UTC)
Broken templates in page "Triggered effect"[edit source]
The page "Triggered effect" has a ton of {{cards|query= ... }} templates that are broken. Most of them are querying for hidden tags. Some of them are querying for normal tags. Aegonostic (talk) 10:46, 19 July 2018 (UTC)
- Yeah,
query
is obsolete now. That sent its value to Semantic MediaWiki directly, but Cargo is doing the heavy lifting now, and Cargo doesn't grok SMW syntax. There's a newwhere
parameter to send a custom where clause to Cargo, but the syntax is very different and certain queries need an ugly workaround. The good news is that it's possible to use "or" logic now intag
,hiddentag
,ability
,set
and other list parameters I may be forgetting, so hopefully the need forwhere
will be much rarer. The ugly{{!}}{{!}}
functions as "or" in these cases. — oOeyes 16:21, 21 July 2018 (UTC) - (Oh, and yeah,
hiddentag
needed a minor fix.) — oOeyes 16:32, 21 July 2018 (UTC)
More broken templates (don't know how to fix)[edit source]
More broken templates here: Target#Cards_with_targeted_effects. Aegonostic (talk) 19:50, 20 July 2018 (UTC)
- This page is leaking HTML code: Passive. Aegonostic (talk) 15:57, 21 July 2018 (UTC)
- Never mind, a null refresh solved it. Aegonostic (talk) 15:59, 21 July 2018 (UTC)
- Yeah, that's an intermittent Cargo bug that I'm really hoping the dev will get around to fixing. A refresh/purge should fix it every time. (Oddly enough, null edits don't always fix it.) — oOeyes 16:14, 21 July 2018 (UTC)
[edit source]
Question: is there a fast way to query all of the hiddentags used by cards on this wiki? I want to build a list of hidden tags and add them to the page Tag. Thanks! Aegonostic (talk) 15:55, 21 July 2018 (UTC)
{{#cargo_query: tables=Cards |fields=Cards.hiddentags |where=Cards.hiddentags__full IS NOT NULL |group by=Cards.hiddentags |limit=5000 |format=ul }}
At least this is one thing Cargo makes relatively easy. If you want it displayed differently, you can change the format: Here's the documentation on that.. — oOeyes 16:30, 21 July 2018 (UTC)
- Also, is it safe to assume that Semantic search will be deprecated and no longer function? Aka: Special:Ask. Is there going to be a similar interface for Cargo? Also, is Special:PageProperty still going to work? Aegonostic (talk) 16:37, 21 July 2018 (UTC)
- Yeah, I'm not even sure the data in SMW is good right now, and those features will likely be removed soon. Special:ViewData is roughly the equivalent of Special:Ask, though it's a bit more complicated is some cases since querying by category requires using the
join
clause to hook the Cards and _pageData tables together. (In most other cases, you should be able to work with just Cards.) For more details, this is the documentation on querying. Also, Cargo queries are really just SQL SELECT statements with some syntax tweaks to make it a wiki parser function, so this documentation can also be useful. — oOeyes 16:57, 21 July 2018 (UTC)
- Yeah, I'm not even sure the data in SMW is good right now, and those features will likely be removed soon. Special:ViewData is roughly the equivalent of Special:Ask, though it's a bit more complicated is some cases since querying by category requires using the
- I want to delete a tag from all its pages, but when I query for cards that have the tag "Card-related", this is giving back no results, even though "Card-related" is listed in the Cargo query for normal tags:
{{Cards|tag=Card-related}}
{{#cargo_query: tables=Cards |fields=Cards.tags |where=Cards.tags__full IS NOT NULL |group by=Cards.tags |limit=5000 |format=ul }}
- Why does a tag exist if no pages use the tag? Aegonostic (talk) 17:43, 21 July 2018 (UTC)
- Also, why does this query result in an error?
{{Cards|tag=Class-related}}
- Aegonostic (talk) 17:48, 21 July 2018 (UTC)
{{Cards|category=All|tag=Card-related}}
More card querying questions[edit source]
Why does querying for this hiddentag not work anymore? It was working an hour ago.
{{Cards|hiddentag=Refresh Hero Power}} {{Cards|category=All|hiddentag=Refresh Hero Power}}
Aegonostic (talk) 19:05, 21 July 2018 (UTC)
- Guess the workaround wasn't hideous enough to cope with spaces. -_- — oOeyes 19:37, 21 July 2018 (UTC)
- Magnifico! *Applause* Aegonostic (talk) 19:40, 21 July 2018 (UTC)
Err, why doesn't this work? Ex: Amara, Warden of Hope is tagged as Quest-generated. Never mind, I messed up on the query, using "hiddentag" instead of "tag".
{{Cards|tag=Quest-generated}} {{Cards|category=All|tag=Quest-generated}}
Aegonostic (talk) 19:49, 21 July 2018 (UTC)
"Template:List cards/Wild" different from "Template:List cards|format=Wild"[edit source]
Can you help fix these two templates to be equal?
Things to look out for:
- Fadeleaf Toxin I think should be in the first template (currently it's not).
- Shellshifter (5/3) should not be in the second template, it is not in Wild format.
- Stranglethorn Tiger (5/5) should not be in the second template, it is in the Classic set, not in Wild format.
- Valeera the Hollow should not be in the second template, it is not in Wild format.
- Smoke Bomb should not be in the second template, it is an Arena-only card.
Aegonostic (talk) 07:21, 25 July 2018 (UTC)
Cards with Stealth 1[edit source]
Cards with Stealth 2[edit source]
Wild format[edit source]
{{wild-section}}
The reply[edit source]
- Looking over things again,
format
is designed to takestandard
orwild-only
.wild
just actually includes everything. I forgot that little detail updating things last week. List cards/Wild seems to differ only by usingwild-only
.
{{List cards|format=wild-only|ability=Stealth}}
- I'm not sure if it should be kept that way or not. — oOeyes 10:50, 25 July 2018 (UTC)
- Ok that makes sense now, I will just use
{{List cards|format=wild-only|ability=Stealth}}
to list Wild-only cards, which is what I was aiming for. Can you delete and recreate Fadeleaf Toxin perchance, I think I messed the page up, it is stuck being non-Wild format, like last time that happened with other cards. Aegonostic (talk) 18:51, 25 July 2018 (UTC)- Done. — oOeyes 00:02, 26 July 2018 (UTC)
- Ok that makes sense now, I will just use
Emergency: "Template:Card" died[edit source]
{{Card}} died. Example: The Boomsday Project Aegonostic (talk) 05:38, 26 July 2018 (UTC)
- ...yeah, I had a bad feeling I was forgetting something. It should be working now. — oOeyes 11:01, 26 July 2018 (UTC)
- Still an emergency, the cards are not clickable and they don't show their enlarged popup form when hovered over. Examples: GVG, The Boomsday Project Aegonostic (talk) 06:44, 27 July 2018 (UTC)
- Both issues should be fixed now. — oOeyes 15:04, 27 July 2018 (UTC)
- Thanks! --DeludedTroll (talk) 15:07, 27 July 2018 (UTC)
A Brawl of Fire and Ice has broken tables and card images[edit source]
Not sure if related to the "Semantic MediaWiki emptying out", but this seems like the best place to report.
- It doesn't look like pages for these cards were ever created, so it wouldn't be related. Looks like they were never in any of the data sets to begin with. — oOeyes 19:44, 28 July 2018 (UTC)
Cargo queries on this page needs fixing[edit source]
Just a couple templates, needs fixing: Minion/Wild_format#Battlefield-related. Aegonostic (talk) 08:36, 29 July 2018 (UTC)
- Also this page: Secret. Aegonostic (talk) 17:18, 2 August 2018 (UTC)
HTML raw source code leaks[edit source]
Also, I want to push for a resolution to the HTML source code leaks, just wanting to make sure that it's on a TODO list somewhere. Thanks. Aegonostic (talk) 18:06, 2 August 2018 (UTC)
- It's been reported to the developer. I believe there's a ticket in our system for it as well. — oOeyes 01:45, 3 August 2018 (UTC)
Admin site notice for "Purge Cache" option?[edit source]
The "Purge Cache" option seems to work everytime to fix the HTML leaks for a page that has HTML source code leaking from it. Maybe a site-wide notice should be put up to let users know about purging the cache for pages to fix their problems? Just a suggestion. Aegonostic (talk) 23:23, 7 August 2018 (UTC)
- Seems a good enough idea for now. It also sounds like there's a workaround for this by performing the queries through Extension:Scribunto. I've been swamped the last couple weeks, but I'm hoping I can squeeze in setting this up and testing it sometime next week. — oOeyes 05:24, 9 August 2018 (UTC)
Hover image on card link[edit source]
Newly created card links don't show card image on hover. The card image does show on hover when in the edit source / show preview screen. Also, it looks like older pages still work as expected.
New page example (hover doesn't work in Decks section): https://hearthstone.gamepedia.com/Hex_Lord_Malacrass_(boss)
Old page example (hover works in Deck section): https://hearthstone.gamepedia.com/Candlebeard
Jazminite (talk) 05:07, 11 January 2019 (UTC) Jazminite
- I opened Hex Lord Malacrass for editing and saved it without any changes and it seems to be working now. I've seen a similar issue with the watchlist star where pages will look unwatched when I first save them, even though they do go on the watchlist, so there does seem to be something a little screwy going on with the caching lately, but I'm pretty sure there's a ticket in for it. Hopefully we'll get it cleared up soon. — oOeyes 09:18, 12 January 2019 (UTC)
- It may be on a per user basis. I went to Hex Lord Malacrass and the hover still wasn't working. I then opened it for editing and saved without making any changes. Now the card hover works for me. Thanks for checking on this. Jazminite (talk) 03:02, 13 January 2019 (UTC)Jazminite
Images and cards display[edit source]
1) Some golden Battlegrounds cards aren't displaying on artists' pages. I'll compare for example Rockpool Hunter (Battlegrounds, golden) and Defender of Argus (Battlegrounds, golden). They both have the artist and battlegrounds categories as it may be seen in source editing but golden Defender of Argus doesn't show up on artist page.
Is it small bug that can't be fixed now or what?
2) I recently learned from user Use25 that if to move images without redirect then the output of Data templates will be corrupt (only names are displayed, images are missing). I accidentally moved several images this way before Use25 said it to me. Some of them look like they've recovered themselves (for example, File:Orgrimmar Guard(151584).png is displayed on Curious Bystander page normally), but File:Reno's Junkpile(151588).png and File:White King(151592).png are now displayed only as names if they're point with Template:card; this can be clearly seen here or here. I can't undo my actions (moving to other pages) because "The edit appears to have already been undone.", redirecting to the old address didn't help (I tried it on Reno's Junkpile so: File:Reno's Junkpile (Road to Northrend).png -> File:Reno's Junkpile(151588).png -> File:Reno's Junkpile (Road to Northrend).png).
So do you know how to solve a problem with the missing display of the above two images - Reno's Junkpile and White King (road to northrend)? Maybe just delete them and upload again? Podstail12 (talk) 18:00, 15 June 2020 (UTC)
- 1) There's a recurring problem with the categories not always updating automatically in the card tables. I keep hoping they'll find a fix, but so far, no such luck. I'll fire up a bot job tonight to force all the card pages and pages using them to update. It does take a while these days with the large number of cards, so it may be a day (or even two, depending on when I can the second part running).
- 2) This one is easier to fix. Follow that text link to the card page itself, open it for editing, and save without changes. Then go back to the previous page and do the same thing. It's not actually a corruption, but a matter of something sticking in the wiki's cache. Forcing both pages to update like that (what we call a null edit), in that order, kicks it loose. (Edit: I've already done that with these two. This usually fixes image problems like that, though, so it's good to know.) — oOeyes 00:20, 16 June 2020 (UTC)
Incorrect edits[edit source]
Hello. User Battlegroundsfan29BEST intentionally adds a false quotes information for a long time on Waxrider Togwaggle page with absurd arguments (a wrongness can be easily confirmed during almost any BG match in game or youtube). In my opinion he just tries to get an angry reaction and won't stop even if he'll get it so only the blocking can help there.
Could you please do something with him? I made a request to Gamepedia Rapid Anti-Spam Patrol but they said it's not an obvious vandalism so the decision should be made by a local administration.Podstail12 (talk) 22:37, 3 September 2020 (UTC)
- I opted for a two-week block. Should be enough time for the user to get bored with it and move on, I think. — SBEyes 14:23, 4 September 2020 (UTC)
Admin[edit source]
Please, make me an admin too. I am relabile, edits this wiki for more time and have great experience in being admin in the HotS Wiki! Senescalzin (talk) 23:41, 12 November 2020 (UTC)
- I certainly see your name in notifications enough, so sure, I'm on board with this. Congratulations! SBEyes (talk) 23:53, 12 November 2020 (UTC)
Mass deletion[edit source]
Good evening. Creating a topic on Hearthstone Wiki talk:Community portal really looks a bit useless now because all messages there are very rare to call a particular person to answer/discuss, and (probably) not so many active users use "Recent changes" button, so I want to write this one to you:
Gamepedia's Tech Support said it's better to notify Wiki members in a case of mass deletions. I spent some time looking for redundant images of card images and datapages of adventures, and the list turned out to be this. All that are marked "DELETE" are unused (File:Maexxna.png), unnecessary at present time (Data:Cards/Heroic Zinaar(27307)), or unnecessarily created (Data:Cards/Zinaar while having Data:Cards/Zinaar(27306)). In general, this mass deletion is aimed at maintaining the hearthpwn numbering system.
So, do you approve this cleansing? I don't think it would affect anything except of the pages that using these datapages, but I'm not sure why some datapages were restored by Taohinton after your deleting (e.g. Data:Cards/Anub'Rekhan) Podstail12 (talk) 17:55, 3 January 2021 (UTC)
- I did see it, but I honestly didn't feel I had anything to say about it. I also don't know why Taohinton restored the pages. With as many wikis as I work on, and the fact I can struggle to remember the work I did last week, something that happened six years ago when we were still doing automated imports just isn't something that stuck, I'm afraid. And, as if you say, the pages and images, I don't have any issue with it. The only thing I can say is just the general rule of thumb that finding a sensible page to redirect to is usually better than deleting, but since these aren't mainspace articles, it's not likely to make much difference. SBEyes (talk) 18:37, 3 January 2021 (UTC)