alter table `item_stats` fails

[Anora]

I ran the world server it download's and updates it self than it run into this table and cant do anything, I have looked at the table and its only got item_id in it none of the rest, i tried deleting the hole DB and re download and that didn't work.

ALTER TABLE `item_stats` ADD UNIQUE `ItemStatsIDX` (`item_id`, `type`, `subtype`
, `text`)': #1061: Duplicate key name 'ItemStatsIDX'
[20090816 09:26:12] [Error] Attempting to update database table 'items' ...
FAILED!

[John Adams]

Yeah, this is apparently a problem that I created, which I believe is now fixed. Some updates made during a "bad update" may get effected down the road, but in the future I will try and work around these when it comes time.

Drop your entire DB and fetch a new one. Remember to run EQ2World a few times to get ALL updates and note that you get no Failures. Let me know how it turns out.

[Anora]

it defenitly fixed it, but now i get a mutch difrent problem, dumped the db 3 times to confirm it was not my side whit several updates atempts

[20090823 13:45:13] [Error] Unable to find parent command 'zones' for subcommand
: 'set'
Every subcommand must have a parent command!
[20090823 13:45:13] [Error] Unable to find parent command 'zones' for subcommand
: 'details'
Every subcommand must have a parent command!

dose not seam to be something that afects gameplay it self, mostly GM command's

[John Adams]

Yeah again, another typo on my part (I should not commit DB changes when sleepy )

You should just have to run eq2world a second time to clear that warning. You might need the latest EQ2World.exe too. I reported an issue with data updates to LE about this, but haven't heard back yet. Mine did eventually update tho. And yes, it is non-critical unless you want to use the new /zone details or /zone set functions, which are non-essential to just playing around. More a DB Team tool.

[Anora]

that's great, Id love to be able to participate in fine tuning the DB if possible