Infraction bannëd
- Joined
- Nov 29, 2011
- Messages
- 616
- Reaction score
- 71
he is maybe? :dontknow: just give him a chance would you?
and why dont you post your log here? or to be exact what kind of error do you get.
14/08/2014 16:42:01 : [Character Data Collector] - ERR: Cannot insert the value NULL into column 'ID', table 'Part2_Zodiac.dbo.UserLoginInfo'; column does not allow nulls. INSERT fails.
The statement has been terminated.
(U:156, C:0, Z:0, L:0, IP:127.0.0.1)
Command : 1
ParamA : 0
ParamB : 0
Compressed : False
9c 00 00 00 16 00
Exception:
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'ID', table 'Part2_Zodiac.dbo.UserLoginInfo'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at rSec.Database.sendNonQueryReturnId(Databases db, String Query)
at rSec.PacketChecker.AuthLoginReturn(Packet p, Character c)
at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)
ClientConnectionId:dfe65439-0d44-4512-89cc-42d9da6af3a7
His game server login packet has invalid content. Theres only one setting in rSec that changes this - ryl version in config. I have ever only seen 2 login packet formats and therefor only has support for 2. If his server doesn't use either of those two formats - well, hes f*cked.
8/18/2014 3:42:20 AM : [Character Data Collector] - ERR: Sequence contains no matching element
MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166)
Command : a1
ParamA : 0
ParamB : 0
Compressed : False
f8 50 00 00 26 00 32 05 00 00 00 14 3e 82 53 01
00 00 00 10 e1 ed 32 05 14 01 00 00 00 00 00 00
Exception:
System.InvalidOperationException: Sequence contains no matching element
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
at rSec.Server.ItemHandler.Combine(IPos from, IPos to, UInt16 leftOverId, Byte leftOverAmount, Stream item)
at rSec.PacketChecker.ItemCombine(Packet p, Character c)
at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)
8/18/2014 3:43:09 AM : [Character Data Collector] - ERR: Sequence contains more than one matching element
MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166)
Command : 34
ParamA : 0
ParamB : 0
Compressed : False
00 00 00 00 00 00 00 00 f8 50 00 00 00 00 00 00
42 05 00 32
Exception:
System.InvalidOperationException: Sequence contains more than one matching element
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
at rSec.Server.ItemHandler.Add(IPos to, Int32 amount)
at rSec.PacketChecker.ParsePickupItem(Packet p, Character c)
at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)
@Alphaest
Hello Sir,
I facing this problem on RYL2 Server 1753/1750 version.
It from Character Data Collector the first is " ERR: Sequence contains more than one matching element" and the second is "ERR: Sequence contains no matching element"
Here the full log from rSecLog.txt
Code:8/18/2014 3:42:20 AM : [Character Data Collector] - ERR: Sequence contains no matching element MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166) Command : a1 ParamA : 0 ParamB : 0 Compressed : False f8 50 00 00 26 00 32 05 00 00 00 14 3e 82 53 01 00 00 00 10 e1 ed 32 05 14 01 00 00 00 00 00 00 Exception: System.InvalidOperationException: Sequence contains no matching element at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at rSec.Server.ItemHandler.Combine(IPos from, IPos to, UInt16 leftOverId, Byte leftOverAmount, Stream item) at rSec.PacketChecker.ItemCombine(Packet p, Character c) at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)
here the other one
Code:8/18/2014 3:43:09 AM : [Character Data Collector] - ERR: Sequence contains more than one matching element MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166) Command : 34 ParamA : 0 ParamB : 0 Compressed : False 00 00 00 00 00 00 00 00 f8 50 00 00 00 00 00 00 42 05 00 32 Exception: System.InvalidOperationException: Sequence contains more than one matching element at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at rSec.Server.ItemHandler.Add(IPos to, Int32 amount) at rSec.PacketChecker.ParsePickupItem(Packet p, Character c) at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)
@kz_3d
yes i see, i already reply your message for multiple time i think. @_@ ..
@Alphaest
thank you sir, i fix it by using rSec build from the source, the one connect to mysql database. If i use the one you release here i will get this error again. I dont know why @_@. Weird
The version that got released by that idiot has a major security issue. Good luck!
8/20/2014 1:14:03 PM : [DB Data Validator] - EQ Check failed
Exception:
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EQ_Changed'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at rSec.Database.sendSelectQuery(Databases db, String Query)
at rSec.DBTestsRunner.RunEQ()
at rSec.DBTestsRunner.Tick(Object runner, ElapsedEventArgs arg)
ClientConnectionId:1b9509d3-f510-4c92-9734-8fe0745b971c
USE [winner1]
GO
/****** Object: Table [dbo].[CharInfo] Script Date: 08/17/2010 12:02:00 ******/
ALTER TABLE [dbo].[CharInfo_1] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO
ALTER TABLE [dbo].[CharInfo_1] ADD CONSTRAINT [DF_CharInfo_1_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed]
GO
ALTER TABLE [dbo].[CharInfo_2] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO
ALTER TABLE [dbo].[CharInfo_2] ADD CONSTRAINT [DF_CharInfo_2_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed]
GO
ALTER TABLE [dbo].[CharInfo_3] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO
ALTER TABLE [dbo].[CharInfo_3] ADD CONSTRAINT [DF_CharInfo_3_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed]
GO
ALTER TABLE [dbo].[CharInfo_4] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO
ALTER TABLE [dbo].[CharInfo_4] ADD CONSTRAINT [DF_CharInfo_4_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed]
GO
just test on RYL1 tyfix released :
Error log :
Code:8/20/2014 1:14:03 PM : [DB Data Validator] - EQ Check failed Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EQ_Changed'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at rSec.Database.sendSelectQuery(Databases db, String Query) at rSec.DBTestsRunner.RunEQ() at rSec.DBTestsRunner.Tick(Object runner, ElapsedEventArgs arg) ClientConnectionId:1b9509d3-f510-4c92-9734-8fe0745b971c
PHP:USE [winner1] GO /****** Object: Table [dbo].[CharInfo] Script Date: 08/17/2010 12:02:00 ******/ ALTER TABLE [dbo].[CharInfo_1] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_1] ADD CONSTRAINT [DF_CharInfo_1_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_2] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_2] ADD CONSTRAINT [DF_CharInfo_2_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_3] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_3] ADD CONSTRAINT [DF_CharInfo_3_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_4] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_4] ADD CONSTRAINT [DF_CharInfo_4_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO
Sounds like the server files need to modified then .. any point?
makes rsec support?
how about the source 2.8 that been release ? so no need to modified serverfile . .isnt it?
The version that got released by that idiot has a major security issue. Good luck!
makes rsec support?
Exception:
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at rSec.Server.Data.SkillScript.ClassLearnedSkills(Byte bClass)
at rSec.PacketChecker.WorldLoginReturn(Packet p, Character c)
at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)
test on v1900 . .result not working :laugh:
well then I guest you're f*cked.
In my forum knowledge portal is a picture of olly/hex, search for those values in your client. The colors are constants.Dear alpha i need your help
What offset to modify to make red colored chat in client.exe for RYL2 ??
Versions supported by rSec were those active/popular at that time. So i would turn this around and say your choice for the version is poop.hell yeah! rsec support only for poop version of RYL/ROW
Features
[*]Ryl 1 and Ryl 2 support