Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
i have a some problem on data save i have a some problem on data save
You last visited: Today at 09:27

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

Advertisement


Advertise with us!

i have a some problem on data save

Discussion on i have a some problem on data save within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
Unhappy i have a some problem on data save

hi great boys
i have a some problem with my shaiya server (ep4)
im shaiya server ep4 created using this topic
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
Andpaur is offline  
Old 11/09/2010, 17:53   #2
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2009
Posts: 131
Received Thanks: 71
Hmm thats a new one on me. I would suggest always checking server logs first. If you're unsure post the logs here.
13latrix is offline  
Old 11/09/2010, 23:12   #3
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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)}
Andpaur is offline  
Old 11/09/2010, 23:15   #4
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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)
Andpaur is offline  
Old 11/09/2010, 23:16   #5
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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
Andpaur is offline  
Old 11/09/2010, 23:18   #6
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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
Andpaur is offline  
Old 11/09/2010, 23:19   #7
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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
Andpaur is offline  
Old 11/09/2010, 23:20   #8
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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
Andpaur is offline  
Old 11/09/2010, 23:21   #9
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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
Andpaur is offline  
Old 11/09/2010, 23:22   #10
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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
Andpaur is offline  
Old 11/10/2010, 20:09   #11
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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)}
Andpaur is offline  
Old 11/11/2010, 00:15   #12
 
ProfNerwosol's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2009
Posts: 449
Received Thanks: 647
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.
ProfNerwosol is offline  
Old 11/12/2010, 00:20   #13
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
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)}
Andpaur is offline  
Old 11/13/2010, 01:33   #14
 
Andpaur's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 39
Received Thanks: 2
Does anyone know of this problem?
Andpaur is offline  
Reply

« GM Stored Procs | DC Problem. »

Similar Threads Similar Threads
Does anyone actually know how to save this problem?
07/23/2010 - Shaiya Private Server - 23 Replies
Ok so i've been following the tuts on how to create a pserver and they've been helpful but only up to a certain point. We've had about 3 different people that are involved in our server try to get past it and they can't solve the issue either. I've searched google, Youtube and all over this forum, i've seen plenty of people with the problem but the responses i've been seeing are "figure it out yourself" and "you must not have followed the tut correctly" well we followed the tut to the letter a...
db-bot save config problem
06/03/2010 - SRO Private Server - 2 Replies
Hi. I got problem with my bot and saving config in it. When i set up then want to save i dont have saved file. When i relog and load config i got nothin...
SRO-DB save config problem
06/02/2010 - SRO Private Server - 0 Replies
I got 9.0a db-bot and when i click save, my acc config file dont want to save i need still do all from start after bot restart. Help? :D
[Save Problem]
03/04/2010 - Metin2 Private Server - 3 Replies
Hey leute und zwar folgendes Problem: Ich bin Ingame mache mir Sachen und dann reboote ich den Server und nach dem Hochfahren sind alle Items nicht mehr da? Weis jemand ne Lösung dazu?
World save problem??
01/05/2006 - WoW Private Server - 2 Replies
So ich wollte eigentlich nen wow server auf unsern root hochziehen.Aber ich habe immer das gleiche problem,sobald wir mit drei mann raufgehen und solange spielen bis der erste world save kommt gibt es keine probleme.Danach wird es kritsich beim 2 worldsave hängt er sich meistens auf und wenn nicht da dann beim dritten worldsave.Also habe ich World save time geändert nun bekommen wir ziemlich oft disconect.Wir benutzen momentan Ramas repack 1.0.8.5 hatten aber auch schon alle andern wow emus...



All times are GMT +1. The time now is 09:29.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, 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 ©2026 elitepvpers All Rights Reserved.