Unable to create or copy any new entries for spells.

[fauxieshaux]

Spell editor version
WoW Spell Editor - 3.3.5a 12340 - V2.2.1 (SQLite)

Describe the bug
Unable to copy/create new spells.

To Reproduce
Steps to reproduce the behavior:

1. Copied an existing spell
2. Entered a new spell ID for the copied spell
3. Try to delete the spell afterwards as I copied the incorrect one
4. Now get constant errors and unable to drop my tablets to re-import my DBCs or unable to create/copy spells anymore.

Expected behavior
Should be able to delete said spell and re-create/copy it again without an error.

Screenshots

debug_output.txt

Additional context
I have tried to drop the tablets and reimport my DBCs but had 0 luck as it gave me an error.
I have even tried to re-install the editor entirely, fresh DBC import, etc and it still gives me the same error.
I have checked my spell dbc via WDX editor and there's no "duplicated" issues or random defects as it states in the error.

[stoneharry]

I followed your reproduction steps using 3.3.5 and the DBCs provided with the spell editor, and cannot reproduce this.

[fauxieshaux]

I followed your reproduction steps using 3.3.5 and the DBCs provided with the spell editor, and cannot reproduce this.

As stated, I even tried a fresh install with imported DBCs for my spell.dbc / spellicon.dbc and its the same issues above. No longer unable to create or copy or delete spells. I'm just as lost as you are.

[stoneharry]

When you try a fresh install, are you using a new folder? SQLite saves to a SpellEditor.db file by default.

Are you importing any custom DBCs? SpellIcon.dbc does not need to be imported by default. Spell.dbc shipped with this spell editor works fine for me.

[fauxieshaux]

When you try a fresh install, are you using a new folder? SQLite saves to a SpellEditor.db file by default.

Are you importing any custom DBCs? SpellIcon.dbc does not need to be imported by default. Spell.dbc shipped with this spell editor works fine for me.

Completely deleted the spell editor and extracted/created a new folder.

And just all my custom changes made to my spell/icon dbcs.

[stoneharry]

Sounds like you have bad custom data. Does it work without your custom DBCs?

[fauxieshaux]

Sounds like you have bad custom data. Does it work without your custom DBCs?

Its been working fine until last night when using it for custom data. I simply copied one of my existing spells and added it as a new entry, but deleted it after copying the wrong entry and since then, I'm no longer able to do anything.
But the DBC files via WDX editor show 0 issues, everything is fine.

As for using a version with nothing custom, regardless - I'm still unable to copy/edit/delete/create a spell, so.

[fauxieshaux]

Same again

[stoneharry]

Upload your DBCs here and I will look at it later in the week.

If you are able to provide reproduction steps using the DBCs provided with the editor in a fresh install, then I can take a look at that. But I think it's a problem with your data.