Psypoke http://m.psypokes.com/forums/ |
|
TechDex Search by Battle Effect is broken. http://m.psypokes.com/forums/viewtopic.php?f=35&t=31296 |
Page 1 of 1 |
Author: | Mektar [ Thu Nov 14, 2013 1:45 pm ] |
Post subject: | TechDex Search by Battle Effect is broken. |
I tried searching for Stat Increasing moves, and then this happened: Quote: You searched for "Stat Increase" moves. Results: -- Error -- Invalid query: SELECT DISTINCT a.atknum,a.name,a.type,a.effect_chance,a.effect_notes,e.effect,japanese FROM dex_attacks_data d,dex_attacks a, dex_attacks_effect e WHERE e.effectnum=a.effectnum AND class LIKE '%Stat Increase%' AND a.atknum=d.atknum AND generation=5 ORDER BY IF(name = '', japanese, name) MySQL error 1054: Unknown column 'class' in 'where clause' Stack Trace: Query() [/var/www/vhosts/psypokes.com/htdocs/dex/search/tmpvqgeffect.php#37] include() [/var/www/vhosts/psypokes.com/htdocs/dex/atksearch.php#96] Someone should probably get on that at some point. |
Author: | Serpentsounds [ Sat May 10, 2014 2:38 am ] |
Post subject: | Re: TechDex Search by Battle Effect is broken. |
Thanks for the report. The error has been fixed but some of our move data is still out of date (you might not get a complete list). I'll work on that when I get the chance. |
Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |