search

stoneharry / WoW-Spell-Editor

A Spell Editor for WoW versions WOTLK 3.3.5, TBC 2.4.3, or Vanilla 1.12.1.
265 stars 121 forks source link

Error: Column 'SpellName-1' does not belong to table Table when spell ID 5 does not exist #239

Open syphex97 opened 2 months ago

syphex97 commented 2 months ago

Spell editor version In terms to try to be smart with data im trying to only export custom spells.

Describe the bug In a attempt to do this i have two MySQL Database imported thought the application. One holds the fully populated spells.dbc, the other will only hold the custom ones. I build both fully from the same Spell.dbc file, they both work as intended when loaded in the application.

Then i trunc the table removing all entries, then i copy all the custom spell entries to the clipboard as SQL imports, and import all the custom spells. In theory this should work, but instead im presented with a error doing this "ERROR: System.ArgumentException: Column 'SpellName-1' does not belong to table Table."

Expected behavior All custom spells should load in as intended.

stoneharry commented 2 months ago

If I understand correctly, you have a spell table only containing your custom spells and want this to be loaded by the spell editor.

I think you are being impacted by #57. If you copy spell ID 5 as well, it should work.

syphex97 commented 2 months ago

If I understand correctly, you have a spell table only containing your custom spells and want this to be loaded by the spell editor.

I think you are being impacted by #57. If you copy spell ID 5 as well, it should work.

Aye, that worked, thank you. Searched for the issue but it didnt show up for me before, but thanks for reply.