01-21-2015, 05:21 PM
Perhaps you have one magic where the a_maxlevel is not the same as the amount of levels in the t_magicLevel.
try to run this query.
UPDATE t_magic m SET m.a_maxlevel = (SELECT max(a_level) FROM t_magicLevel WHERE a_index = m.a_index);

