[Error]Product List SQL

[DEvolver]

This is what i got when i executed the Cash.sql

 Spoiler

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.
Msg 213, Level 16, State 1, Line 41
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 42
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 43
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 44
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 45
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 46
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 47
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 48
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 49
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 50
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 51
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 52
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 53
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 54
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 55
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 56
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 57
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 58
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 59
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 60
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 61
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 62
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 63
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 64
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 65
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 66
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 67
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 68
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 69
Insert Error: Column name or number of supplied values does not match table definition.

[·Tyler·]

Cash.sql doesn't include the RowID, if you set your RowID to the Identity of the table, it should work.

Tyler

[RebeccaBlack]

or delete RowID, it's basically useless lol

[·Tyler·]

It creates some kind of order to the table, other than that, it would be hard to read it.

Tyler

[DEvolver]

Originally Posted by ·Tyler·

Cash.sql doesn't include the RowID, if you set your RowID to the Identity of the table, it should work.

Tyler

>.< sorry i'm newb when it comes to sql , how do i do that exactly? lol

[RebeccaBlack]

It doesn't any kind of "order" lol

[·Tyler·]

Originally Posted by DEvolver

>.< sorry i'm newb when it comes to sql , how do i do that exactly? lol

1. Right click the table and select "Design"
2. Under the Table Designer Header find the Identity Specification sub-header and expand it
3. Change "Is Identity" to Yes

That should do it for you, and remember to save it.

Tyler

[DEvolver]

ok well i did what you said tyler and it worked i was able to execute the file successfully, i've patched the cash.sdata into the client , but when i go ingame the item mall has the old stuff and prices and says "No item located on this spot" any clue to why this is?

[JohnHeatz]

Try actually using the search, that "new" issue has been adressed already (recently) on another thread

[DEvolver]

Originally Posted by JohnHeatz

Try actually using the search, that "new" issue has been adressed already (recently) on another thread

if you have nothing helpful to say then don't make a post just to increase your post count by saying "Use the search button".

[viper4513]

if you have nothing helpful to say then don't make a post just to increase your post count by saying "Use the search button".

Actually, by saying "use the search button" he was infact being helpful to you.. If you took a minute you would have easily found the answer to your question using that little search tool. So before lashing out at someone, atleast take their advice.

extract cash.sdata from your client, decrypt it, then decompile it to csv, edit it. Recompile it to Sdata, and make the DB produclist.import.csv => Import it to your database after truncating the current table.
Encrypt this edited cash.Sdata and import it to your client.

From Alladrios, found using the SEARCH BUTTON. Go give it a go, theres a tonne of other cool looking topics that can be found with that tool.

[DEvolver]

Originally Posted by viper4513

Actually, by saying "use the search button" he was infact being helpful to you.. If you took a minute you would have easily found the answer to your question using that little search tool. So before lashing out at someone, atleast take their advice.

From Alladrios, found using the SEARCH BUTTON. Go give it a go, theres a tonne of other cool looking topics that can be found with that tool.

well guess what, ive been using the "Search" button for 10 minutes and i can't seem to find w/e effing post you guys are talking about.... so like i said unless u have something helpful to post then don't post to increase your post count.../done

[[Admin]Snuggle]

Sometimes a search takes more than 10 minutes -.-
*increases post count* use the search button >.>
Ever think you might not be searching for the right thing?
And no I won't give you a link or anything to where that post is located.
Sometimes we have to do things for ourselves instead of asking others.
^helpful info for life.

[viper4513]

well guess what, ive been using the "Search" button for 10 minutes and i can't seem to find w/e effing post you guys are talking about.... so like i said unless u have something helpful to post then don't post to increase your post count.../done

You do realise by posting this ****, you're doing exactly as you say not to do, right??

And if you cant work out what to type in the search, then you must be a **** moron. I copied a line of text from YOUR own question, and searched that, got the **** answers right away.

I tell you what, use that nifty little search tool, and search for a guide on how to use it.. theres a nice one around from Bane i think.. that may help you out.. and in the Future, try not to bite the hand that feeds you.

[JohnHeatz]

Originally Posted by DEvolver

if you have nothing helpful to say then don't make a post just to increase your post count by saying "Use the search button".

It is not to increase the post count, that doesn't really matter, if you are trying to get something done, you must look by yourself, the question you asked, that same day was asked on another thread, and in there it was answered, so actually, there is no point on you asking a question that was already answered