Re: Problem with MySQL for excel
Hello, Javier!
copypast from logfile:
------------ start
MySQLForExcel Information: 1 : MySQL for Excel Startup
DateTime=2016-08-30T18:06:44.8588198Z
Timestamp=83498827385
MySQLForExcel Information: 1 : Deleting automatically saved connection information entries with non-existent Excel Workbooks.
DateTime=2016-08-30T18:06:51.3961660Z
Timestamp=83512843136
MySQLForExcel Error: 1 : Application Exception on MySqlDataUtilities.GetDataFromSelectQuery - Идентификатор GUID должен содержать 32 цифры и 4 дефиса (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
в System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException)
в System.Guid.TryParseGuidWithNoStyle(String guidString, GuidResult& result)
в System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result)
в System.Guid..ctor(String g)
в MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal)
в MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject)
в MySql.Data.MySqlClient.ResultSet.get_Item(Int32 index)
в MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, Boolean checkNull)
в MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i)
в MySql.Data.MySqlClient.MySqlDataReader.GetValues(Object[] values)
в System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)
в System.Data.ProviderBase.SchemaMapping.LoadDataRow()
в System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
в System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
в System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
в System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
в System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
в System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
в MySql.Data.MySqlClient.MySqlHelper.ExecuteDataset(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters)
в MySql.Data.MySqlClient.MySqlHelper.ExecuteDataset(String connectionString, String commandText, MySqlParameter[] commandParameters)
в MySQL.ForExcel.Classes.MySqlDataUtilities.GetDataFromSelectQuery(MySqlWorkbenchConnection connection, String query, Int32 tableIndex)
DateTime=2016-08-30T18:07:04.8228232Z
Timestamp=83541627532
Callstack= в System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
в System.Environment.get_StackTrace()
в System.Diagnostics.TraceEventCache.get_Callstack()
в System.Diagnostics.TraceListener.WriteFooter(TraceEventCache eventCache)
в System.Diagnostics.TraceListener.TraceEvent(TraceEventCache eventCache, String source, TraceEventType eventType, Int32 id, String message)
в System.Diagnostics.TraceSource.TraceEvent(TraceEventType eventType, Int32 id, String message)
в MySQL.Utility.Classes.MySqlSourceTrace.WriteToLog(String message, SourceLevels messageType, Int32 messageId)
в MySQL.Utility.Classes.MySqlSourceTrace.WriteAppErrorToLog(Exception exception, SourceLevels messageType, Boolean useInnerException)
в MySQL.ForExcel.Classes.MySqlDataUtilities.GetDataFromSelectQuery(MySqlWorkbenchConnection connection, String query, Int32 tableIndex)
в MySQL.ForExcel.Classes.DbView.GetData()
в MySQL.ForExcel.Forms.PreviewTableViewDialog.FillPreviewGrid()
в MySQL.ForExcel.Forms.PreviewTableViewDialog..ctor(DbView previewTableOrView, Boolean showCancelButton)
в MySQL.ForExcel.Controls.ExcelAddInPane.EditTableData(DbTable tableObject, Boolean fromSavedConnectionInfo, Workbook workbook)
в MySQL.ForExcel.Panels.DbObjectSelectionPanel.EditDataHotLabel_Click(Object sender, EventArgs e)
в System.Windows.Forms.Control.OnClick(EventArgs e)
в MySQL.ForExcel.Controls.HotLabel.OnClick(EventArgs e)
в System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
в System.Windows.Forms.Control.WndProc(Message& m)
в System.Windows.Forms.ScrollableControl.WndProc(Message& m)
в System.Windows.Forms.ContainerControl.WndProc(Message& m)
в System.Windows.Forms.UserControl.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
------------ stop
Thank you!