i have a some problem on data save

11/04/2010 22:56 Andpaur#1
hi great boys
i have a some problem with my shaiya server (ep4)
im shaiya server ep4 created using this topic [Only registered and activated users can see links. Click Here To Register...]
but when i do not save the output game
for example: any npc, any ap items or other
and fails to "connection with server has been disconnected error 2"

but all dress is recorded
what can i do this problem :(
11/09/2010 17:53 13latrix#2
Hmm thats a new one on me. I would suggest always checking server logs first. If you're unsure post the logs here.
11/09/2010 23:12 Andpaur#3
Ty for Reply

my all log files is here

Code:
2010-11-09 18:30:28 PS_DBAGENT__system log start (DBAgent)

2010-11-09 18:30:41 connect game, Name=



2010-11-09 18:30:41 connect game, Name=



2010-11-09 18:37:25 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 18:37:25 ::SaveCharacter 29 Neji ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(29,31,3,577)}

2010-11-09 18:37:25 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 18:37:25 ::SaveCharacter 29 Neji ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(29,31,3,577)}

2010-11-09 18:44:49 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 18:44:49 ::SaveCharacter 29 Neji ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(29,31,3,585)}

2010-11-09 18:44:49 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 18:44:49 ::SaveCharacter 29 Neji ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(29,31,3,585)}

2010-11-09 18:54:14 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 18:54:14 ::SaveCharacter 13 GM-Demonic ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(13,286,1,604516)}

2010-11-09 18:54:14 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 18:54:14 ::SaveCharacter 13 GM-Demonic ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(13,286,1,604516)}

2010-11-09 20:07:40 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 20:07:40 ::SaveCharacter 36 CRAZYEFE ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(36,38,100,180)}

2010-11-09 20:07:40 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 20:07:40 ::SaveCharacter 36 CRAZYEFE ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(36,38,100,180)}

2010-11-09 22:52:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 22:52:42 ::SaveCharacter 28 IMHOTEP ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(28,104,100,180)}

2010-11-09 22:52:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 22:52:42 ::SaveCharacter 28 IMHOTEP ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(28,104,100,180)}

2010-11-09 23:07:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 23:07:43 ::SaveCharacter 28 IMHOTEP ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(28,228,1,300)}

2010-11-09 23:07:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-09 23:07:43 ::SaveCharacter 28 IMHOTEP ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(28,228,1,300)}
11/09/2010 23:15 Andpaur#4
Code:
2010-11-09 18:30:35 PS_GAME__system log start (Game) [KR]

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/sorp1

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/croco1

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/croco2

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/Troll1

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/Spink1

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/GoldenPig

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/Sorp3

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/SorpNamed1

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/SorpNamed2

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/Sorp2

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/CrocoNamed1

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/CrocoNamed2

2010-11-09 18:30:35 Loaded Behavior In Factory : data/ai/CrocoNamed3

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/OrcNamed1

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/OrcNamed2

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/OrcNamed3

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/TrollNamed1

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/Deinos

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/Parridalis

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/Alcarian

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/ZinAlcaria

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/Belizabeth

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/Kirhiross

2010-11-09 18:30:36 Loaded Behavior In Factory : data/ai/CrypticOne

2010-11-09 18:30:41 connect mgr 668

2010-11-09 18:30:41 connect dbagent 676

2010-11-09 18:30:41 connect dbagent2 688

2010-11-09 18:30:41 connect gamelog 720

2010-11-09 18:30:42 Market End -----------------------

2010-11-09 18:30:58 <Console input> /nprotectoff

2010-11-09 18:30:58 <Console output> cmd NProtect off ok

2010-11-09 18:37:25 discon client: (104,    64) T=000:05:00:000, RC=47,RCS=0, RB=822,RBS=2, SC=323,SCS=0, SB=14690,SBS=41

2010-11-09 18:44:50 discon client: (104,    64) T=000:00:00:000, RC=8,RCS=0, RB=163,RBS=3, SC=72,SCS=1, SB=5892,SBS=125

2010-11-09 18:54:15 discon client: (104,    64) T=000:05:00:000, RC=17,RCS=0, RB=372,RBS=1, SC=226,SCS=0, SB=7078,SBS=21

2010-11-09 19:30:52 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2010-11-09 20:07:41 discon client: (104,    64) T=000:45:00:000, RC=3207,RCS=1, RB=48508,RBS=17, SC=9043,SCS=3, SB=161048,SBS=59

2010-11-09 20:30:52 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2010-11-09 21:30:52 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2010-11-09 22:30:52 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2010-11-09 22:52:42 discon client: (104,    64) T=002:44:00:000, RC=7694,RCS=0, RB=105538,RBS=10, SC=21398,SCS=2, SB=365007,SBS=36

2010-11-09 23:07:43 discon client: (104,    64) T=000:14:00:000, RC=195,RCS=0, RB=2244,RBS=2, SC=660,SCS=0, SB=19056,SBS=21

2010-11-09 23:30:52 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
11/09/2010 23:16 Andpaur#5
Code:
2010-11-09 18:30:31 PS_SESSION__system log start (Session)

2010-11-09 18:30:33 connect login

2010-11-09 18:30:41 connect game

2010-11-09 18:31:54 [Uchiha] NewUser Enter : Char=Neji, Lv=60, Map=35, X=589.5, Z=277.1

2010-11-09 18:33:49 [Uchiha] NewUser Leave : Char=Neji, Lv=60, Map=35, X=584.3, Z=270.4

2010-11-09 18:33:58 [Uchiha] NewUser Enter : Char=Neji, Lv=60, Map=35, X=584.3, Z=270.4

2010-11-09 18:37:25 [Uchiha] NewUser Leave : Char=Neji, Lv=60, Map=35, X=584.3, Z=270.4

2010-11-09 18:48:49 [Uchiha] NewUser Enter : Char=GM-Demonic, Lv=60, Map=42, X=74.8, Z=52.2

2010-11-09 18:54:14 [Uchiha] NewUser Leave : Char=GM-Demonic, Lv=60, Map=42, X=74.8, Z=52.2

2010-11-09 19:22:39 [Uchiha] NewUser Enter : Char=CRAZYEFE, Lv=60, Map=0, X=269.7, Z=1798.4

2010-11-09 20:07:41 [Uchiha] NewUser Leave : Char=CRAZYEFE, Lv=60, Map=29, X=1665.1, Z=702.5

2010-11-09 22:52:42 [Uchiha] Money Over : Char=IMHOTEP, Old=1172742794, Now=3996720183

2010-11-09 22:53:26 [Uchiha] Money Error : Char=IMHOTEP, Old=3996720183, Now=4000032984

2010-11-09 23:08:19 [Uchiha] Money Error : Char=IMHOTEP, Old=3938879870, Now=4000032984
11/09/2010 23:18 Andpaur#6
And my all config files

Ps_Game.ini
Code:
[SERVER]
ServerName=Game
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=127.0.0.1, PS_GameDefs, Shaiya, 8CD21AB3BDAA28C1B437F93C1D538FD596E090F149E9B6F9A0F7AF03FB310F0758F92FE235864F70FE9846D77A1B37593A8D4662ACC6F666A6AEB5BFB05A31FFCCC36C655F805218DA6D305ADD623F76B648B5473DC19E039BB9EA97864EE09F3D909ED8C95E794140F302D3852E3B3E0991BAB7B7158E7DAA8D58515B852566
GameData=127.0.0.1, PS_GameData, Shaiya, 15820DF37FFD68B04069D2E259F063B716123F1FA32C9F606348717D5C28F6B3D387E53E9359AB39DEFD3C4449828CF211699FC5D8DFA0031A2D902C38F4E141D23E43DD3A8F1A374F8ADD3BF7B33FC1EB2BB320537341C683E3B2435F80D0CCB14ACD6C6E3FFD6BB55127E820AB4A79E688B3E574EB8E5879A6A7C6263BC7F7
[GAMEINFO]
GameName=Uchiha
GamePublicIP=88.251.***.***
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
11/09/2010 23:19 Andpaur#7
Ps_Login.ini
Code:
[SERVER]
ServerName=Login
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, Shaiya, 194361ACE26E4A33C282972B1421F2E09D5115593E326CD1D1D2D7F15DA9D586E6A5CBE96942F48EBBF2C6981FF7041B4E5DA4BF28DBF767BFC771A1E10EE0B5AFF132E8398D52C31C4A040F301E24FC0B00F505A0C3C9A744C3ADA04D048A481134A919A605BB9551CFDCD7845FC2FEC34738AC364282650F95085E88D6ECC4
[GAMESERVERS]
// Game01 = name, Mapping ServerID, Mapping DB ID(use prev server id)
GameServerCount=1
Game01=Uchiha, 1, 1

[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
11/09/2010 23:20 Andpaur#8
Ps_UserLog.ini
Code:
[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, Shaiya, C9260EEA14BF4DB7AB62CEB5387731E0C074D3EC268F7435D3E2DC7A04072E7C845A2C5760453AE01B1C06580CCB6C51022D1E6B7B4CDB6A7FF103AE999FE4DA36EAF5BC8FFF2ED36E5CD28F77C37E3DB2BD961C8DC1B0E75F5B42FC3560F8B3A1DFA0EE4887606AF370A5FDCDCF199A16984340BACE0AF5A5B5BFFF125909B6
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001
Ps_Session.ini
Code:
[SERVER]
ServerName=Session
ServerPort=
MaxConnection=

[CONNECTION]
UserLog=127.0.0.1

[GAMESERVERS]
GameServerCount=1
Game01=Uchiha

[LOGFILE]
Replace=0
Append=1

[MONITOR]
Enable=0
Port=50000
11/09/2010 23:21 Andpaur#9
Ps_GameLog.ini
Code:
[SERVER]
ServerName=GameLog
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, FC81F76DD55DD2B8A22C296D07B5A41646DEECD4F6F62751126BB0129B44DC154B4B095B125C51C5A2A866B0963044C79A5DEE0668B602013D761A01C63CC5F156D574D165159CD0981F0876833343EBD272BB97B2C7F7694B6C3A9FCB17F35AD7DFE9239135BE7EDFFB7AC7D9DDF96F5CF9E623E674302D170FF399D0402BA3
DBChat01=127.0.0.1, PS_GameLog, Shaiya, C0AEA1156A49A39AD9070E3E21B7714F1C2F8D365A436416D38A91847E46014CA96436E2E272FAF8205CED3306D793624A3936137331151A52B8520B0FBD57193348F90F30EE29F3E4CC291ECDA62E34FD22DA0AC712E51779E501AD15CC9E118A8BD2D015EA1F2EF29D99148AE00D3F3BDEC4FB93E34AC5A695199FFAF3C4B8
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001
Ps_DbAgent.ini
Code:
[SERVER]
ServerName=DBAgent
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, Shaiya, CC89C67C99478C1CB1C1E2C0606BD91DA36B59259516A13AFF8F535A9626A349E4013168C994CA1436A06D634CC20E3C363D9BEA7660E7602D112BB021E9F55370DADAFD8057BAE0C33B4EDFE1EB4B258A56DCFBA5100BA5426B8CFD7BD3730912ED99FB72A62775C601690FEF3E671F3967E3A8D8A3B40778ACE805DCA0C71D
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
11/09/2010 23:22 Andpaur#10
PsmServer_Config.ini
Code:
[Main]

  <ip_session> = 127.0.0.1

  <ip_userlog> = 127.0.0.1

  <db_user>    = 127.0.0.1, PS_UserData, Shaiya, 3B54E15A553C31E242E73EB53C9AAC2419E5514E25B73B998D1746244B9BBDA76E1995A701704C1C7EFC94B12F6D8014FEE551DA6F0528828A49D112F2B16AB6B2735C719178028F43BAD10033AF95DD36A2E8EFA2A9BCD1869F0F3B8C4C63366B6AAAB998218978962FFBBDF55B5C2CBF9DC0D5619F39A0826A34FC8F7E5F52



[Login_001]

  <sv_maxuser>  = 10

  <ip_login>    = 127.0.0.1



[GameGroup_001]

  <sv_maxuser>     = 10

  <sv_gameversion> = 0x08022100

  <sv_gamename>    = Uchiha

  <sv_publicip>    = 88.251.***.***

  <ip_game>    = 127.0.0.1

  <ip_dbagent> = 127.0.0.1

  <ip_gamelog> = 127.0.0.1

  <db_game>    = 127.0.0.1, PS_GameData, Shaiya, AEE005C2BD754A41E5903C79B16950F6FA87B3E14F750CBF730AFCF64F677B8B5D36D40C00CE9116187BCC8178411BC004DE4FD4FF3B3E0800D9767812AF518EBE19E6BFA47C38343BBADE4CD0E255C253DE150B89F34B8C71B3800A584420C1574931065D17EA6AA359BA2BF69DE7048C1CD0C1BC55D66931975C4BEC4E62C4

  <db_gamedef> = 127.0.0.1, PS_GameDefs, Shaiya, 31CAC9875EEAB7DF02132105583283345E4BAE6A15E8C228ABEF669CFE63312B08B16472CBB1AB6ACE92D50B2A09920C0DA4031CEDF45EDB794BB27D812F8705CA63BE7A4574A66AE17D66E027A88316427013619D343F74AB623912DE23A9BB14681B7CE75DE90AD0B80746B4E57DC6C03FDEFDCD3D818E5711DDE96A46E22D

  <db_gamelog> = 127.0.0.1, PS_GameLog, Shaiya, E620913B56ED1C3897BD0C46A7463D0C95F9703D12F1A18B6498E21316719F824B42559A9011F0329FE62EC1D27AD54504900483591B99134F9BD53654EC00328749A9C66C4825A1B4E522B2364616E5D2CB9D2F1730B4E54703684FBF5975EC8936811CE086590EA871208F6914B57B4E3719E6C46BA5C63CE9C14512982443

  <db_chatlog> = 127.0.0.1, PS_GameLog, Shaiya, F1BCE24DBA2A8EAC73948D40839649D0AFB4B4E6E92F33550E0CCDFCD07174AED3CB272BCC07710079A111DC4B011CEBB532345E03F111C4DDDE171DE0866DB90D4A5184A31964BC932EE6C0A618E8516C341680426658426EFB5297796E254E609462B5617CFE6E25D22C8E20537BB55DC1EE814732E75028032B345EE995DD
11/10/2010 20:09 Andpaur#11
Code:
2010-11-10 19:11:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:11:20 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2010-11-10 19:11:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:11:20 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2010-11-10 19:11:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:11:20 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2010-11-10 19:30:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'int'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:30:45 ::SaveCharacter 14 GM-KOPKOP ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(14,60, 23479,546, 28650,28000,28650,28650,28650,28650, 5714,-4525,-5592, 0,231, 1405399100,-753405338, 228.800659,26.547743,1829.055664, 0,200,0,0,0, 200000,0,1,4, 0,0)}

2010-11-10 19:30:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'int'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:30:45 ::SaveCharacter 14 GM-KOPKOP ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(14,60, 23479,546, 28650,28000,28650,28650,28650,28650, 5714,-4525,-5592, 0,231, 1405399100,-753405338, 228.800659,26.547743,1829.055664, 0,200,0,0,0, 200000,0,1,4, 0,0)}

2010-11-10 19:35:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'int'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:35:52 ::SaveCharacter 37 111 ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(37,1, 0,5, 14,12,9,8,7,15, 369,115,269, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0, 0,0,0,0, 0,0)}

2010-11-10 19:35:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'int'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:35:52 ::SaveCharacter 37 111 ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(37,1, 0,5, 14,12,9,8,7,15, 369,115,269, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0, 0,0,0,0, 0,0)}

2010-11-10 19:37:23 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'int'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:37:23 ::SaveCharacter 37 111 ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(37,1, 0,5, 14,12,9,8,7,15, 369,115,269, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0, 0,0,0,0, 0,0)}

2010-11-10 19:37:23 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'int'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2010-11-10 19:37:23 ::SaveCharacter 37 111 ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(37,1, 0,5, 14,12,9,8,7,15, 369,115,269, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0, 0,0,0,0, 0,0)}
11/11/2010 00:15 ProfNerwosol#12
Your problem lies in stored procedures. usp_Read_Guild2_R is an example. You can find everything you need in logs. I suggest to go through the procedures and see what could be wrong, or contact someone who knows T-SQL to fix them for you.
11/12/2010 00:20 Andpaur#13
Code:
2010-11-11 14:34:39 PS_DBAGENT__system log start (DBAgent)

2010-11-11 14:34:51 connect game, Name=



2010-11-11 14:34:51 connect game, Name=



2010-11-12 01:18:48 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-12 01:18:48 ::SaveCharacter 37 Sakura ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(37,47,3,300)}

2010-11-12 01:18:48 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2010-11-12 01:18:48 ::SaveCharacter 37 Sakura ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(37,47,3,300)}
11/13/2010 01:33 Andpaur#14
Does anyone know of this problem? :(