Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 12:36

  • Please register to post and access all features, it's quick, easy and FREE!

 

Error When Adding Items

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
Error When Adding Items

I get an error when im trying to add an items to the SQL. How can I fix this ? Please help.

You must register and activate your account in order to view images.



TRTeta is offline  
Thanks
1 User
Old   #2
 
elite*gold: 0
Join Date: Aug 2011
Posts: 170
Received Thanks: 32
read the error what he said "Can not insert duplicate key"

it mean you can not insert tow some ID in DB.item.


Modamer9 is offline  
Old   #3
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,001
Received Thanks: 957
Check the ID values in the errors in your database dbo_ItemResource

You either already have the items or you have items in your database the use the same item IDs.
ThunderNikk is offline  
Old   #4
 
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
what should I do


TRTeta is offline  
Old   #5
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,001
Received Thanks: 957
You should look at the item IDs in the error.

Find out what items they are in you dbo.ItemResource table and see if they are the same items.

If they are then you don't need to run the script to add the items cause they are...already in there.

If the item IDs are in there for some other items then you're in a pickle.
ThunderNikk is offline  
Old   #6
 
elite*gold: 0
Join Date: Jun 2013
Posts: 45
Received Thanks: 31
You should: not try to insert items that already exist into the database.

So unless you feel like spending a REALLY long time thumbing through 30k+ items, I'd open the script your trying to use (or scroll to the top of the query window) and add TRUNCATE TABLE dbo.ItemResource BEFORE the first INSERT [[WARNING!!! THIS WILL DELETE ALL DATA IN YOUR dbo.ItemResource]]
TealSky is offline  
Old   #7
 
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
fixed


TRTeta is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Adding NPC's and Adding Items in Shopping Mall
Hello there, I have an 5518 source; Albetros Source. Now I have a few questions about it. 1. How do you add new NPC's and where can I find them...
21 Replies - CO2 PServer - Discussions / Questions
Error adding vigor
I get this error Yes, I followed the guide which I can't link here. I added to refpackageitem, refScrapofItem, RefShopgoods, and...
0 Replies - SRO PServer Ask the Experts
Error,adding new npc
Hey,i finished in db/media to add a new npc(tutorial by kira) and i get this http://i.imgur.com/R7YFu.png
8 Replies - SRO PServer - Discussions / Questions
a Qustion about Adding items to Items mall ... PLEASE HELP
Hello i need to add some items to my incoming server i need to add Circus bear and , Devil spite upgrader , and Some new avatars i am...
0 Replies - SRO PServer - Discussions / Questions
Error adding new monster
IntersectRayTri : 버텍스버퍼의 개수가 너무 크다 15006 any idea why client crash with this error after adding a monster in game with new models ?...
6 Replies - Flyff PServer - Discussions / Questions



All times are GMT +2. The time now is 12:36.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.