I suggest you run deletemall.sql then, it will delete everything that have the same ID as in the mall.
I suggest you run deletemall.sql then, it will delete everything that have the same ID as in the mall.
Freelance Digital Artist
https://reflectionartwork.deviantart.com
You did not desert me
My brothers in arms
i dont work i only get this error [Err] 1062 - Duplicate entry '235001' for key 1
[Err] ##Enchanter - Credits to Snailz of MMOwned.
INSERT INTO `items` VALUES ('235001', '0', '8', '-1', 'Enchant 2H Weapon - Savagery', '', '', '', '16598', '1', '64', '5000000', '0', '0', '-1', '-1', '70', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '46462', '0', '-1', '1000', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '-1', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
waht i gonna do???
Ehm, not sure if I added a delete sql for that.. Your best bet is to check the SQL for item id's, and then delete them from your DB.
Freelance Digital Artist
https://reflectionartwork.deviantart.com
You did not desert me
My brothers in arms
ok how do that edit: i did that now but now i get [Err] 1136 - Column count doesn't match value count at row 1
[Err] ##Creature_Spawns
INSERT INTO `creature_spawns` VALUES ('2000022257', '5144', '35', '-77.4144', '77.0395', '-32.9673', '3.45968', '0', '3108', '875', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully
-------------------------------------------------- and i get this error for both your malls i know i need to update my database but how???
Last edited by adde007; 09-04-2008 at 12:48 PM.
its not a problem with your DB, its a problem with his SQL. im going to update both his karazhan mall and his SW Vaults mall and post them sometime this weekend for him to add to the first post.
~death~
Nice mall man, I like the pics and the tags too+Rep
Thanks Deathomen, I'll make sure to post credits to you if you get it to work.
Freelance Digital Artist
https://reflectionartwork.deviantart.com
You did not desert me
My brothers in arms
ok good i really want this mall