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!

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.

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

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.

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