Whats goin on with the Refresh????

[Julesx]

I love ur merchant and loot editor's george great work!! I just have one complaint your item editor keeps saying something about needs to be refreshed every time i try and do a search i can't edit or create any custom items with it is there some way to refresh it that i'm just not seeing?? Any help would be appreciated thanks agian for your great tools..

[GeorgeS]

Your items database schema is not the same as PEQ or up to date. This message comes from an error when looking at your database and something does not match.

GeorgeS

[theeris23]

I am having the same issue once I upgraded to the latest database - 1129REV245. I had no issues with REV 233. I even loaded up a backup copy of 233 and it worked. Any ideas? Thanks.

[theeris23]

I just re-verified that rev 245 doesn't work with the item editor. I did a fresh install of 245 and 233 and the item editor worked perfectly with 233, but it gave me a refresh error with 245.

[WillowyLady]

Same "refresh" issue with Rev 245.

[GeorgeS]

I'll load up the current schema and have a look.

GeorgeS

[cavedude]

Kayot was kind enough to give PEQ his schema for items which is a bit different and makes the table a bit easier to understand/work with and also reduces memory usage a bit. That's probably the cause of the problem. Sorry about that!

[GeorgeS]

ok - I found the error after changing the schema. It was a variable declaration.

Everquest Item Editor and Character Inventory Editor
- 14.3.1 - Fixed crash when running db schema 245 -" ..requires refresh" error. This was caused by a variable declaration (Integer, when required Long)


I tested this and works on my end. Give it a go.

GeorgeS


..I'm not sure what difference Kayot's schema has to the past one. I'll look into this today, but the program appears to work ok.
I'm refering to his post here
http://www.eqemulator.net/forums/showthread.php?t=25773

[theeris23]

Thanks GeorgeS, it works for me!

[theeris23]

Spoke too soon - icon's are all messed up - it doesn't load up the correct icon when you edit an item, and if you click on an item in the inventory window, it comes up with a 'Reference Error 1000 - unknown icon reference'.

[GeorgeS]

Thanks for the error report. I found the schema diffs from the new items table, and there's a ton of issues, but I went thru them one at a time and I think I got them all.

Dl the newest version - that should do it.

GeorgeS

[WillowyLady]

Thanks G! New version appears to be working fine now:) Have not come across any more issues <yet> *winks*