Ep 6 Problem Help Deleting rune

11/25/2012 16:17 yukolo#1
Hello friends, we want to build shaiya server.
We tried to establish Episode 6 alone failed to result.
We need friends to Us to Help About It
Our website is okay.
Exit and re-entered the game in-game by pressing problem rune
When the rune seems to have been deleted.
Skil at the same time
looking for friends to help us
would like to thank


skype=bulutumyuksel
11/26/2012 20:16 JohnHeatz#2
You might want to explain further, because I can't understand what your problem is
12/02/2012 19:08 yukolo#3
I'm sorry for my english is bad
I am from Turkey
I do not understand much english
I can write so sloppy translations
my problem
pressing entered the game rune
alone will be deleted from the game when you go back to the rune
I think the database does not work
Turkish friends who could not be helpful in this regard

(selamun aleyküm hocam mecbur buraya yazdım çünkü dil problemimiz var kusura bakmayın şimdi biz ep 6 server kurduk yalnız oyuna girdiğimizde rünü ve siklleri basıyoruz oyuna girip çıktığımızda rün ve skiller geri siliniyor tam 2,5 aydır bu problemin çözümünü bulamadık databaseyemi kaydetmiyor acaba problem nedir bir yardımcı olabilirmisiniz)

Skype=bulutumyuksel
12/02/2012 19:11 nephren#4
Did you mean Rollback ?

please post logs: PSM_Client/bin/logs
12/02/2012 19:25 yukolo#5
now that we have established ep 6 server to play alone when we entered the rune and the rune and skills that cyclin pressing back in the game and deleting the database does not record the full 2.5 months, I wonder what the problem could not find a solution to this problem Can you help

soon be installing okay, thank you
12/02/2012 19:35 nephren#6
Well, I guess you mean Rollback.
But without Logs we cannot help.
Please share your Serverlogs with us: PSM_Client/Bin/Logs post it here, it contains error-messages.
12/02/2012 19:56 yukolo#7
Quote:
Originally Posted by peripher View Post
Well, I guess you mean Rollback.
But without Logs we cannot help.
Please share your Serverlogs with us: PSM_Client/Bin/Logs post it here, it contains error-messages.
DBAGENT

2012-12-02 20:33:29 PS_DBAGENT__system log start (DBAgent01)

Module list:

D:\ShaiyaServer\PSM_Client\Bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2012-12-02 20:33:36 ### Connect[3688] : Game[?][0x0073F7C0], Addr=127.0.0.1, DBJobEnd=1

2012-12-02 20:33:36 ### Connect[3688] : Game[?][0x0073F918], Addr=127.0.0.1, DBJobEnd=2

2012-12-02 20:33:36 ### DB_SYSTEM_CONNECT[3736] :Game[1][0x0073F7C0], Name=Game01, Addr=127.0.0.1

2012-12-02 20:33:36 Error Packet : 0x209, CConnection::PacketSystemConnect

2012-12-02 20:37:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-12-02 20:37:05 ::SaveCharacter 2 artist ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(2,286,3,2591980)}

2012-12-02 20:37:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-12-02 20:37:05 ::SaveCharacter 2 artist ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(2,286,3,2591980)}





PSGAME


2012-12-02 20:33:31 PS_GAME__system log start (Game01) [KR]

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/sorp1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/croco1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/croco2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Troll1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Spink1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/GoldenPig

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Sorp3

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Sorp2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Deinos

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Parridalis

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Alcarian

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Belizabeth

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Kirhiross

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/CrypticOne

2012-12-02 20:33:32 RandomOption Error : ItemID=24070, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24111, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24112, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24118, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24119, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24125, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24126, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24154, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24240, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24249, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24250, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24251, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24252, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24253, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24254, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39070, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39111, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39112, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39118, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39119, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39125, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39126, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39154, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39240, byServer=2, Wis=0

2012-12-02 20:33:36 connect mgr 740

2012-12-02 20:33:36 connect dbagent 748

2012-12-02 20:33:36 connect dbagent2 760

2012-12-02 20:33:36 connect gamelog 792

2012-12-02 20:33:37 Market End -----------------------

2012-12-02 20:33:38 Load Shaiya.SData 0

2012-12-02 20:34:02 <Console input> /nprotectoff

2012-12-02 20:34:02 <Console output> cmd NProtect off ok

2012-12-02 20:37:05 discon client: (104, 64) T=000:02:00:000, RC=36,RCS=0, RB=324,RBS=2, SC=231,SCS=1, SB=4251,SBS=33




PS GAMELOG


2012-12-02 20:33:29 PS_GAMELOG__system log start (GameLog01)

Module list:

D:\ShaiyaServer\PSM_Client\Bin\ps_gameLog.exe, loaded at 0x00400000 - 10/10/18 16:33:52

2012-12-02 20:33:36 connect game

2012-12-02 20:35:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '237959233063284080000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-02 20:35:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,0,'', 7086,-568516798,60484, -237959233063284080000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL

2012-12-02 20:35:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '237959233063284080000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-02 20:35:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,0,'', 7086,-568516798,60484, -237959233063284080000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,107, 0,83886080,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL , '0.0.0.0','money=184549376, bank=117444096, cash=167774720','level=0,skp=3328,stp=32512','s=0, d=257,i=0,w=0,r=0,l=0'

2012-12-02 20:36:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '10419551905839035000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-02 20:36:31 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,1232609113,'š|1T', 0,0,29545, 69768364807739612000000.000000,1041955190583903500 0000000000000000.000000,-0.000000, '2012-12-02 20:36:31',180, 103,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'çxIš G',NULL,NULL,NULL

2012-12-02 20:36:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-02 20:36:42 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,0,'', 7082,-568516798,10820, 0.000000,0.000000,2864.330322, '2012-12-00 00:06:07' ,111, 69540876599088,512,0,NULL,NULL,NULL,NULL,NULL,NULL ,NULL,'',NULL,'7,0,0,0,0,208 (Option:)','2000-00-15 25:38:18'

2012-12-02 20:36:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-02 20:36:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,262151578,'', 7082,-568516798,11332, 0.000000,0.000000,2864.330322, '2012-12-00 00:06:07' ,112, 69540876599088,-1706461184,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL ,'xIšç E','use_item','30,1,3,0,0,0 (Option:,Ìx»PF)-2002-12-00 00:00:00','bag=23,slot=104'

2012-12-02 20:37:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-02 20:37:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-48471899,'0', 7082,-568516798,17732, 0.000000,0.000000,0.000000, '2001-04-00 00:00:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=184549376, bank=117444096, cash=167774720','level=0,skp=3328,stp=256','s=0,d= 0,i=0,w=0,r=0,l=0'

2012-12-02 20:37:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-02 20:37:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-48471899,'0', 7082,-568516798,17732, 0.000000,0.000000,0.000000, '2001-04-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Leave',NULL,NULL,NULL
12/02/2012 20:10 nephren#8
Quote:
Originally Posted by yukolo View Post
DBAGENT


PS GAMELOG

2012-12-02 20:35:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '237959233063284080000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-02 20:35:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,0,'', 7086,-568516798,60484, -237959233063284080000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL

2012-12-02 20:37:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-48471899,'0', 7082,-568516798,17732, 0.000000,0.000000,0.000000, '2001-04-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Leave',NULL,NULL,NULL
Your database/Stored Procedure have a lot of Errors.
That is the Point - i suggest to install a new: PS_GameDefs and PS_GameData.
You can backup characters with Export/import
but at this time the best thing is to attach a new
PS_GameDefs/Data. You can fix it of course, just download other Serverfiles and take a look at stored procedures.

The number '237959233063284080000000000000000000000.000000' is out of the range which means it cannot be stored please check your Chars/CharItems there is something wrong or cannot cooperate with current files/database

Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-12-02 20:37:05 ::SaveCharacter 2 artist ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(2,286,3,2591980)}

SkillID is not decleard - > @Skillid smallint

Take a look at here - this will help you a bit (should fix Skills):

Stored Procedure > PS_GameData -> Save_Char_Apply_Skill_E2:
Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2]    Script Date: 12/02/2012 20:17:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]

@CharID int,
@SkillID smallint,
@SkillLevel tinyint,
@LeftResetTime int

AS

SET NOCOUNT ON

INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES(@CharID,@Skillid,@SkillLevel,@LeftResetTime)

IF(@@ERROR = 0)
BEGIN
    RETURN 1
END
ELSE
BEGIN
    RETURN -1
END

SET NOCOUNT OFF
12/02/2012 21:47 yukolo#9
Thank you very much for your interest
I'll try, thank you very, very much