• Encountered error in Spell Editor

Posted: **Sat Dec 07, 2013 1:56 pm**

John,
Playing with the spell editor this morning I got this when trying to add a new tier

Error Code: 0

INSERT INTO spell_tiers (`spell_id`, `tier`, `hp_req`, `hp_req_percent`, `hp_upkeep`, `power_req`, `power_req_percent`, `power_upkeep`, `savagery_req`, `savagery_req_percent`, `savagery_upkeep`, `dissonance_req`, `dissonance_req_percent`, `dissonance_upkeep`, `req_concentration`, `cast_time`, `recovery`, `recast`, `radius`, `max_aoe_targets`, `min_range`, `range`, `duration1`, `duration2`, `resistibility`, `hit_bonus`, `call_frequency`, `unknown9`) select `spell_id`, `4`, `hp_req`, `hp_req_percent`, `hp_upkeep`, `power_req`, `power_req_percent`, `power_upkeep`, `savagery_req`, `savagery_req_percent`, `savagery_upkeep`, `dissonance_req`, `dissonance_req_percent`, `dissonance_upkeep`, `req_concentration`, `cast_time`, `recovery`, `recast`, `radius`, `max_aoe_targets`, `min_range`, `range`, `duration1`, `duration2`, `resistibility`, `hit_bonus`, `call_frequency`, `unknown9` FROM spell_tiers WHERE id = 40224;

Posted: **Sun Dec 08, 2013 11:24 am**

Fixed. Mistakenly used the wrong tick marks on the new tier value:

Code: Select all

select `spell_id`, `4`, ...

Back-ticks are column names. Should have been '4' (single quote).

I thought we weren't going to add data missing from SOE API?

Posted: **Sun Dec 08, 2013 4:22 pm**

John Adams wrote:Fixed. Mistakenly used the wrong tick marks on the new tier value:
Code: Select all
select `spell_id`, `4`, ...
Back-ticks are column names. Should have been '4' (single quote).

I thought we weren't going to add data missing from SOE API?

We are not, I finally realized that this spell is only one tier after encountering the error.

Posted: **Mon Dec 09, 2013 2:51 pm**

Ahh, you can always use the icon to see the SOE JML, when in doubt. So far though, aside from mis-classifications, I have found nothing missing from SOE API data and our local spells.

Encountered error in Spell Editor

Encountered error in Spell Editor

Re: Encountered error in Spell Editor

Re: Encountered error in Spell Editor

Re: Encountered error in Spell Editor