RDM - Unable to Connect to your data source: unknown column 'a.ID' in 'where clause'

RDM - Unable to Connect to your data source: unknown column 'a.ID' in 'where clause'

avatar

I have the following error since I've updated to the last version of RDM
Unable to Connect to your Data Source
unknown colum 'aID' in 'where clause'

message:

MySqlConnector.MySqlException (0x80004005): Unknown column 'a.ID' in 'where clause' ---> MySqlConnector.MySqlException (0x80004005): Unknown column 'a.ID' in 'where clause'
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at MySqlConnector.Core.ResultSet.<ReadResultSetHeaderAsync>d__2.MoveNext() in /_/src/MySqlConnector/Core/ResultSet.cs:line 49
at MySqlConnector.MySqlDataReader.ActivateResultSet() in /_/src/MySqlConnector/MySqlDataReader.cs:line 124
at MySqlConnector.MySqlDataReader.<NextResultAsync>d__5.MoveNext() in /_/src/MySqlConnector/MySqlDataReader.cs:line 109
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at MySqlConnector.MySqlDataReader.NextResult() in /_/src/MySqlConnector/MySqlDataReader.cs:line 26
at System.Data.ProviderBase.DataReaderContainer.NextResult()
at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetDataSet(String sql, IDbDataParameter[] parameters, IDbConnection dbConnection)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseSecuritySubDataSource.GetUsers[T](Int32 userType, Nullable`1 userId)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseSecuritySubDataSource.GetUser(Guid userId)
at Devolutions.RemoteDesktopManager.Managers.OfflineManager.cf1bdcf0858d0250614884876e932b71f(BaseOfflineEngine cd3b6645869986711503f11b40d159337, String c774efff1e950beb970ecb1c0183f4ee5, String c9c7a494d3f4f0ba6c53796dad1acfe51, String ce8fe0cafea9fb334a7b930439b773ebf)
at Devolutions.RemoteDesktopManager.Managers.OfflineManager.SyncOfflineChanges(List`1 changes, Boolean showGoOffline)
at Devolutions.RemoteDesktopManager.Managers.OfflineManager.GoOnline()
at Devolutions.RemoteDesktopManager.Managers.ActionManager.RefreshConnections(Boolean resetCache, Boolean resetUserInfo, Boolean goonline, Boolean changingRepository)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.PerformClick()
at Devolutions.RemoteDesktopManager.Managers.ThreadManager.cc2365d13e441931fe2713968c8aa5c95(Object c19f185fd70cefc696ba148af1c4faf54, EventArgs cf1018bb83ec7debd818319fd3cb4844e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

All Comments (2)

avatar

Hello,

Could you please go in Files - Data Sources and create a new data source. Please be sure to configure the same parameters as your current data source. Let me know if that works.

Best regards,

Érica Poirier

avatar

Hello,

Could you please try the latest RDM beta version 2020.3.27 that is now available? It contains a fix for this problem.
https://remotedesktopmanager.com/home/download#Beta

Best regards,

Érica Poirier