Spawn editor freezes on Save

[ChaosSlayerZ]

George, I am using your latest copy of npc editor with build in Spawn editor.

When I change something (anything) in the spawn editor and click SAVE - its lights up as "saving" but never returns from this action, and just freezes.

I am on remote connect to the Db right now, is it possible that spawn editor save requires some sort of special access permission?

NPC editor itself works fine- creates new npcs, alters them, copies etc.

[GeorgeS]

The save part should never say 'saving' - there's no code for that.
There are sql UPDATE statements that itterate through a recordset line by line and I think it just takes a while. Sometimes these are slow due to the "live" nature of the recorsdet and running over a line.

GeorgeS

[ChaosSlayerZ]

by "saving" I mean- when you click on SAVE - it turn BLUE- and stays that way for at least 12 min =) after that I just shut the program down =)

the previous version I used was from may revision and that one was saving in under 15 seconds

[pfyon]

If you're making changes to a live database (ie in use when you're working on it), it might be slow because you have multiple queries running at the same time.

After reading this article on MyISAM versus InnoDB, I have wondered why all the eqemu tables are default MyISAM instead of InnoDB considering that InnoDB uses row-level locks whereas MyISAM locks whole tables when updates are made.

[ChaosSlayerZ]

well I have edited living (running) server Db before- and there was no difference in update between running and non running server.

I just tried using Item editor over remote connection- and it goes into "thinking" when I try to do anything and never recovers from it.

On local connection- even with running server, it only takes 2-3 seconds to make a new item
on other hand- the NPC editor works fast enough - all updates are only 5-6 seconds slower than on local connection

[Lillu]

yes, I can confirm this, and I would really appreciate if Georges could look into this.

Georges = our heroe!

[ChaosSlayerZ]

as a side note, if you could tell us how to make item copy manually- like with insert statement? I tried and kept getting something like serialization error?

EDIT: it gives a warning that serialization value was out of range and was adjusted, but item is still created. I am willing to go ahead and make items like this if necessary, just want to know if there is any side effects to this serialization warning?