A Little Problem

[Mitk0o0]

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

[George St-Pierre]

See if you have a table called dbo.product list

[Mitk0o0]

I have ProductList in database but he is empty.

[George St-Pierre]

That can be the problem, you have used some kind of script to clean it?.

[Riouk]

You must set column RowID to auto increment.

[treica]

Run compatible as your client the database
EP4 Client - EP4 Database
EP4.5 Client - EP 4.5 Database
EP5 Client - EP5 Database

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.

[Mitk0o0]

No i update Npc.sql its EP 4.5 to Database Ep 4.5 and again have some problem

[treica]

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.

[Mitk0o0]

Yes i follow ur step but now my Game Service can't start (

treica Can you help me i will thanks

[treica]

Post here your logs so i can see your error can be found on
C:\ShaiyaServer\Server\PSM_Client\Bin\Log

[Mitk0o0]

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 ....

[AnyChat]

You must decrypt the NpcQuest.SData befor you can replace ist on server.

[Mitk0o0]

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