plz read

**curosue1232** · 08-01-2011

im looking for a offline custom item maker for my server besides wow-v becuase wenever a try to run the sql scipt a get a error saying (sql error (1054): unkown colmn 'name2' in 'field list') im runing the script threw heidi sql and navicat lite plz help me

i dont know if i posted this in the right place or not lol

**Will Scarlet** · 08-01-2011

what core?

---------- Post added at 01:37 AM ---------- Previous post was at 01:29 AM ----------

For Trinity: [Only registered and activated users can see links. ]

**curosue1232** · 08-01-2011

arcemu

**Lucian** · 08-01-2011

You can try using the ArcEmu manager you can download [Only registered and activated users can see links. ]

**curosue1232** · 08-01-2011

ty that looks good

---------- Post added at 11:47 PM ---------- Previous post was at 11:43 PM ----------

how do i enter settings info for logon data, character data, world data ?

**curosue1232** · 08-01-2011

[Err] 1062 - Duplicate entry '123513' for key 1
[Err] INSERT INTO items (entry, class, subclass, name1, displayid, quality, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, maxcount, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, bonding, description, sheathID, MaxDurability, socket_color_1, socket_color_2, socket_color_3, socket_bonus) VALUES ('123513', '2', '8', 'blade of dylan', '4', '5', '0', '-727389968', '17', '1535', '1791', '0', '0', '2', '50000', '90000', '0', '50000', '90000', '0', '9999999999999', '999999999', '99999999999999999', '9999999999999999999999999999999', '99999999999999', '999999999999999999999999', '99999999999999999', '100', '0', '0', '', '1', '999999999', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

**Dreadkiller** · 08-01-2011

the problem at you is that the item with that entry already exist ^^
add this to the sql at the first line before you add this sql files:

DELETE FROM `item` WHERE `entry` = 123513

**curosue1232** · 08-01-2011

when i .add it says invalid item id do i need to restart server ?

**Dreadkiller** · 08-01-2011

add my sql before you add your item and yes afetr a item addition you have to restart the server

**curosue1232** · 08-01-2011

kk i closed all every thing and restarted it and invalid item id ?

Thread: plz read

LinkBack

Thread Tools

Display

plz read

this is a error a get when i run the sql script by navicat

Visitors found this page by searching for:

Bookmarks

Bookmarks

Posting Permissions