search

zunath / SWLOR_NWN

Star Wars: Legends of the Old Republic server code, a persistent world for Neverwinter Nights
40 stars 98 forks source link

GAME: String/Guid exception #405

Closed zunath closed 6 years ago

zunath commented 6 years ago

Conversion failed when converting from a character string to uniqueidentifier. Conversion failed when converting from a character string to uniqueidentifier.

EVENT ERROR (C#) Insert EXCEPTION: Exception type: System.Data.SqlClient.SqlException Message : Conversion failed when converting from a character string to uniqueidentifier. Conversion failed when converting from a character string to uniqueidentifier. Stacktrace: at System.Data.SqlClient.SqlConnection.OnError (System.Data.SqlClient.SqlException exception, System.Boolean breakConnection, System.Action1[T] wrapCloseInAction) [0x0004c] in <d3bd623f3b7341e5a51a2d4030374687>:0 at (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlConnection.OnError(System.Data.SqlClient.SqlException,bool,System.Action1) at System.Data.SqlClient.SqlInternalConnection.OnError (System.Data.SqlClient.SqlException exception, System.Boolean breakConnection, System.Action1[T] wrapCloseInAction) [0x00013] in <d3bd623f3b7341e5a51a2d4030374687>:0 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning (System.Data.SqlClient.TdsParserStateObject stateObj, System.Boolean callerHasConnectionLock, System.Boolean asyncClose) [0x00152] in <d3bd623f3b7341e5a51a2d4030374687>:0 at System.Data.SqlClient.TdsParser.TryRun (System.Data.SqlClient.RunBehavior runBehavior, System.Data.SqlClient.SqlCommand cmdHandler, System.Data.SqlClient.SqlDataReader dataStream, System.Data.SqlClient.BulkCopySimpleResultSet bulkCopyHandler, System.Data.SqlClient.TdsParserStateObject stateObj, System.Boolean& dataReady) [0x009bf] in <d3bd623f3b7341e5a51a2d4030374687>:0 at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData () [0x00040] in <d3bd623f3b7341e5a51a2d4030374687>:0 at System.Data.SqlClient.SqlDataReader.get_MetaData () [0x00031] in <d3bd623f3b7341e5a51a2d4030374687>:0 at (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader (System.Data.SqlClient.SqlDataReader ds, System.Data.SqlClient.RunBehavior runBehavior, System.String resetOptionsString) [0x000d3] in <d3bd623f3b7341e5a51a2d4030374687>:0 at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds (System.Data.CommandBehavior cmdBehavior, System.Data.SqlClient.RunBehavior runBehavior, System.Boolean returnStream, System.Boolean async, System.Int32 timeout, System.Threading.Tasks.Task& task, System.Boolean asyncWrite, System.Data.SqlClient.SqlDataReader ds) [0x004d8] in <d3bd623f3b7341e5a51a2d4030374687>:0 at System.Data.SqlClient.SqlCommand.RunExecuteReader (System.Data.CommandBehavior cmdBehavior, System.Data.SqlClient.RunBehavior runBehavior, System.Boolean returnStream, System.Threading.Tasks.TaskCompletionSource1[TResult] completion, System.Int32 timeout, System.Threading.Tasks.Task& task, System.Boolean asyncWrite, System.String method) [0x00079] in :0 at System.Data.SqlClient.SqlCommand.RunExecuteReader (System.Data.CommandBehavior cmdBehavior, System.Data.SqlClient.RunBehavior runBehavior, System.Boolean returnStream, System.String method) [0x0000b] in :0 at System.Data.SqlClient.SqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0003c] in :0 at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00000] in :0 at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback (System.Data.IDbCommand cmd, System.Boolean wasClosed, System.Data.CommandBehavior behavior) [0x00008] in <6213727ee896483f97b3bda884e9dd37>:0 at Dapper.SqlMapper.QueryMultipleImpl (System.Data.IDbConnection cnn, Dapper.CommandDefinition& command) [0x000d0] in <6213727ee896483f97b3bda884e9dd37>:0 at Dapper.SqlMapper.QueryMultiple (System.Data.IDbConnection cnn, System.String sql, System.Object param, System.Data.IDbTransaction transaction, System.Nullable1[T] commandTimeout, System.Nullable1[T] commandType) [0x00018] in <6213727ee896483f97b3bda884e9dd37>:0 at SqlServerAdapter.Insert (System.Data.IDbConnection connection, System.Data.IDbTransaction transaction, System.Nullable1[T] commandTimeout, System.String tableName, System.String columnList, System.String parameterList, System.Collections.Generic.IEnumerable1[T] keyProperties, System.Object entityToInsert) [0x0003c] in :0 at SWLOR.Game.Server.Data.SqlMapperExtensions.Insert (System.Data.IDbConnection connection, System.Type type, System.Object entityToInsert, System.Data.IDbTransaction transaction, System.Nullable`1[T] commandTimeout) [0x001ca] in :0 at SWLOR.Game.Server.Threading.DatabaseBackgroundThread.Run () [0x00092] in :0

zunath commented 6 years ago

This is a problem with DMs speaking. Probably because they don't have IDs.