Updated EQITEMS and BOTS editor

[fade1973]

I am also getting the same runtime error. althou i can get in and get the program to work i get the run time error anytime i try to save an edited item.

BTW great work on the tools.

[GeorgeS]

Great work on that fix!!!

I'll work on adding this to the program and post the update later!

GeorgeS

[nosfentora]

Sent pm this am.

[GeorgeS]

Thanks, I have what I need, and I think I already found my table has missing fields. This is likely the issue.

I'll post the fix when I get back from work.

GeorgeS

[nosfentora]

Yw. And awesome job on this tool!

[GeorgeS]

I am still trying to fix the issue.

Regarding error "Old Edit gives 'Run time error '9' Subscript out of range' for any item."

This was fixed today. Field# exceeded variable declaration.

Now regarding the other more serious error. So we know that 'new edit' copy works fine, but fails if you save the copied item ~ around where it updates the "range" field.

Can you verify this assumption below?
if you save an original (not copied) item in new edit with no changes -- it works ok? but fails when saving the copied one?

BTW - I loaded in the latest schema and could not reproduce the error. Could be my version of mysql (mysql-5.0.77) that may be causing this, but still there has to be a reason why a simple query like UPDATE items SET range="0" WHERE id='1079' (it fails here everytime?)
fails???

This is weird and a real brain twister..
I'm on it and I'll let you know when I'm done

GeorgeS

[nosfentora]

Just tested now with a newly downloaded copy of eqitems (14.4.13) and newly installed OBDC drivers (3.51) to make sure i was up to date.

DB is still PEQ 946

It failed on saving an un-edited (non-copy) item, failed on saving an edited (non-copy) item, saving an un-edited copy, and saving an edited copy. (this time i tried on id 47344 (Abhorrent Brimestone of Charring)

could it be that MySQL 5.1.37 has something new that doesn't like that query?

Using NaviCat 8.2.11 i ran the query:
update items set range=0 where id=47344

it failed

"[SQL] update items set range=0 where id=47344

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range=0 where id=47344' at line 1"

[nosfentora]

Same error - i did try those variations before posting, should have posted that too =)

[bergalas]

is it posible for you to make a way to disable sound in these files my sound card crapped out on me and now i cant load your programs i get the following error

runtime error'-2137220906 (80040256)' Automation Error it didnt start till my sound card died on me

[nosfentora]

When the app starts, before you click on 'lets start' you can click on the radio button to the left 'editor music off' that will turn the music off for that session.

GeorgeS - would you want to make that selection 'permanent' so that one doesn't need to turn it off every time?

also, i believe that the app loads spells from the database, so pointing it to the eq folder is no longer necessary. If you set it to nothing (="") it shouldn't load the music (though it will give you the 'music library error') and you should be all set. Clicking 'editor music off' does away with that error in either case.

[GeorgeS]

Ok folks,

- 14.4.14 - Changed sql to use `range` with quotes since it's a reserved word in mysql. Saving items should now work.

Download the latest binary with this fix.
Regarding the sound issue, just disable it at the splash screen option.

GeorgeS

[bergalas]

maybe im missin something here?

[bergalas]

i see no radio button??

[bergalas]

also tried the eq folder fix in the ini same error ugh

[nosfentora]

that's definitely an old version - current is 14.4.14 (you have 14.4.12)