A Little Problem

05/26/2012 19:14 Mitk0o0#1
Hello every one.I have the problem when i update Cash.sql i click execute but get this error:
Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition.
Who can help me please post i will very thanks :)
05/26/2012 20:41 George St-Pierre#2
See if you have a table called dbo.product list
05/26/2012 21:02 Mitk0o0#3
I have ProductList in database but he is empty.
05/26/2012 21:04 George St-Pierre#4
That can be the problem, you have used some kind of script to clean it?.
05/26/2012 21:12 Riouk#5
You must set column RowID to auto increment.
05/26/2012 21:40 treica#6
Run compatible as your client the database
EP4 Client - EP4 Database
EP4.5 Client - EP 4.5 Database
EP5 Client - EP5 Database

Code:
Column name or number of supplied values does not match table definition.
This is your error then you have tryed to update from an ep5 client to an ep4 database...use compatible mate.
05/27/2012 10:04 Mitk0o0#7
No i update Npc.sql its EP 4.5 to Database Ep 4.5 and again have some problem :(
05/27/2012 10:18 treica#8
decrypt NpcQuest.sdata...or how is called i forget sorry, and put it on C:\ShaiyaServer\Server\PSM_Client\Bin\Data here you will see another NPCQuest.sdata and paste on it.
Then restart server and you have server working, because is mixmatching NPC's items.
05/27/2012 12:30 Mitk0o0#9
Yes i follow ur step but now my Game Service can't start :((

treica Can you help me i will thanks :)
05/27/2012 17:37 treica#10
Post here your logs so i can see your error can be found on
C:\ShaiyaServer\Server\PSM_Client\Bin\Log
05/28/2012 14:56 Mitk0o0#11
No i put new Npc.Quest.Sdata and i can't start only Game Services now i put old Npc.Quest.Sdata and now server working but NPC not work ....
05/28/2012 15:43 AnyChat#12
You must decrypt the NpcQuest.SData befor you can replace ist on server.
05/28/2012 20:13 Mitk0o0#13
Ok i know to i need to decrypt but this program Shaiya Data File Tool have error and i can't decrypt

Problem fixed ty all.

But when i make NPC how to i add more items for i put in Merchant ?? any one know pls say i will thanks :)