Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya
You last visited: Today at 02:07

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

Advertisement



[HELP]Fix No Item Located On That Spot.

Discussion on [HELP]Fix No Item Located On That Spot. within the Shaiya forum part of the MMORPGs category.

Closed Thread
 
Old   #1
 
elite*gold: 23
Join Date: Nov 2011
Posts: 103
Received Thanks: 96
[HELP]Fix No Item Located On That Spot.

Hello *Elite*Pvpers* ,
I found from this One , I did the same
But after i execute in SQL i get this error.

Code:
Msg 213, Level 16, State 1, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 2
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 3
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 4
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 5
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 6
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 7
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 8
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 9
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 10
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 11
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 12
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 13
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 14
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 15
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 16
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 17
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 18
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 19
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 20
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 21
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 22
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 23
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 24
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 25
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 26
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 27
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 28
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 29
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 30
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 31
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 32
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 33
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 34
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 35
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 36
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 37
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 38
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 39
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 40
Insert Error: Column name or number of supplied values does not match table definition.
Thanks for ur time..
Regards , [*]Sindacco.
-FeaRs- is offline  
Thanks
1 User
Old 09/16/2012, 15:39   #2
 
TeddyBear94's Avatar
 
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,625
ur db and client arent matching if u get the error "Item not located in that spot"
TeddyBear94 is offline  
Thanks
2 Users
Old 09/16/2012, 15:47   #3
 
elite*gold: 23
Join Date: Nov 2011
Posts: 103
Received Thanks: 96
Ahh **** , So i gotta change DB? My client is 4.5 downloaded from Ariez..
And the DB too seems perfect.
-FeaRs- is offline  
Thanks
1 User
Old 09/16/2012, 17:24   #4
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,976
You need to have a database for the same EP (4.5) not EP5 or EP3, it both must match, so either updgrade/downgrade your database, or your client.
JohnHeatz is offline  
Thanks
3 Users
Old 09/17/2012, 15:31   #5
 
elite*gold: 23
Join Date: Nov 2011
Posts: 103
Received Thanks: 96
Yeah right john , Thanks for it.
Yeah I checked it , it was : D:\Shaiya\EP5 Database\Database\MyDatabase#1.sdf
u see there sdf? this is the place where u connect to DB , How would i make sdf so i can choose in SQL Now?

#The Topic Can be Closed
-FeaRs- is offline  
Thanks
1 User
Old 09/17/2012, 22:17   #6
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,976
#Closed as requested
JohnHeatz is offline  
Thanks
1 User
Closed Thread


Similar Threads Similar Threads
[Tutorial]How to fix "Item not located in that spot"
09/11/2018 - Shaiya PServer Guides & Releases - 4 Replies
Well, first of all, good afternoon to everyone reading this. I'm bringing a little guide on how to correct this error so often. First open Shaiya Data File Tool by lilprohacker Select your data.sah and in the folder called Data, you will find a file called Cash.sdata, you give and give right click to extract. http://i43.tinypic.com/ic1bnb.jpg Once you've extracted Cash.sdata, open Shstudio.
GOLD AND ITEM SPOT
08/03/2012 - Diablo 3 Guides & Strategies - 29 Replies
Jo in dem Video zeige ich euch den meiner Meinung besten farm spot in diablo. Hab schon einige gute Sachen bekommen und ca. 5 unique items. Akt 1 -> Irgendeine Quest auswählen -> Alte ruinen porten -> nach oben Laufen für den Checkpoint Falls Fragen bestehen einfach im Thread posten :) Ab und zu ist vor dem Ersten Keller noch der Brunnen offen.. war bei mir nur einmal der fall. + Vor dem zweiten Keller ist manchmal noch ein anderer Boss (selten)
No Item Located at that spot?
03/19/2012 - Shaiya Private Server - 8 Replies
Hello sir's, I have troubles with item mall. I get an bug that says "No Item Located at that spot" when I try and buy certain things and was hoping theres's a fix. If anyone has one i'd appreciate all the help I can get.
L2 IndO..Spot Hunt For Drop weapon and Item S84
06/21/2011 - Lin2 Exploits, Hacks, Bots, Tools & Macros - 1 Replies
Heelllo my friends from indonesia...i need your answer for the nice spot Hunt and have S84 weapon or armor...can you teLL me where is that place??



All times are GMT +1. The time now is 02:07.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.