User-1697400506 posted
My database tables have NO GUID field defined but varchar(36) as primary key.
In some time I got this error in SQL JOIN:
Unrecognized Guid format.
Can you shed me some lights what's wrong is that?
Thanks
********************************************************************************
Exception
Details: System.FormatException: Unrecognized Guid format.
Source Error:
Line 121: catch
Line 122: {
Line 123: throw;
Line 124: }
Line 125: finally
|
Source File: C:\WebClasses\WebClass\CommonClasses\DataServiceBase.cs Line:
123
Stack Trace:
[FormatException: Unrecognized Guid format.]
System.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument,
String failureArgumentName, Exception innerException) +3875935
System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result) +9665624
System.Guid..ctor(String g) +107
MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal)
+319
MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject)
+242
MySql.Data.MySqlClient.Driver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue value)
+52
MySql.Data.MySqlClient.ResultSet.get_Item(Int32 index) +351
MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, Boolean checkNull) +121
MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i) +172
MySql.Data.MySqlClient.MySqlDataReader.GetValues(Object[] values) +111
System.Data.ProviderBase.CommonLanguageSubsetDataReader.GetValues(Object[] values) +13
System.Data.ProviderBase.SchemaMapping.LoadDataRow() +46
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +96
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable,
DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords,
DataColumn parentChapterColumn, Object parentChapterValue) +164
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
+424
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
String srcTable, IDbCommand command, CommandBehavior behavior) +204
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +319
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
DataServiceBase.ExecuteDataSet(String query, MySqlParameter procParams) in C:\WebClasses\WebClass\CommonClasses\DataServiceBase.cs:123
ELogDataService.GetELogByAnnouncerID(String announcerID, DateTime eLogDate) in C:\WebClasses\WebClass\CommonClasses\ELogDataService.cs:176
ELogBusinessCollection.GetELogByAnnouncerID(String announcerID, DateTime eLogDate) in C:\WebClasses\WebClass\CommonClasses\ELogBusinessCollection.cs:46
ELogGenerator.GenerateAnnoucerELogs() in C:\WebLog\WebApplication1\WebApplication1\Help_Classes\ELogGenerator.cs:73
WebApplication1.Main.PopulateAllAnnouncerLogs() in C:\WebLog\WebApplication1\WebApplication1\Main.aspx.cs:102
WebApplication1.Main.InitialiseAnnouncerLogs() in C:\WebLog\WebApplication1\WebApplication1\Main.aspx.cs:94
WebApplication1.Main.Page_Load(Object sender, EventArgs e) in C:\WebLog\WebApplication1\WebApplication1\Main.aspx.cs:44
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207
