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/