starred/1Remote
1
0
Fork 0
mirror of https://github.com/1Remote/1Remote.git synced 2026-04-25 13:36:03 +03:00
Code Issues 89 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #100] Crash when saving connection: No such column: UpdatedToken #1042

New issue
Closed
opened 2026-02-28 12:00:57 +03:00 by kerem · 2 comments
kerem commented 2026-02-28 12:00:57 +03:00
Owner
Copy link

Originally created by @majkinetor on GitHub (Mar 25, 2021).
Original GitHub issue: https://github.com/1Remote/1Remote/issues/100

Originally assigned to: @VShawn on GitHub.

Happens when I open existing connection config and just click save.

Environment

Component Version
PRemoteM 0.5.10(EXE release)
.NET Framework .NET Framework 4.8
CLR 4.0.30319.42000
OS Windows 10 Enterprise 64-bits 6.2.9200.0 (2009)

Error Info

SQL logic error
no such column: UpdatedToken

Stack Trace

   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2813
   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 572
   at PRM.Core.DB.Dapper.DapperDb.UpdateServer(ProtocolServerBase server) in D:\DemoProject\PRemoteM\PRM.Core\DB\Dapper\DapperDb.cs:line 120
   at PRM.Core.Model.DbOperator.DbUpdateServer(ProtocolServerBase org) in D:\DemoProject\PRemoteM\PRM.Core\Model\DbOperator.cs:line 296
   at PRM.Core.Model.GlobalData.ServerListUpdate(ProtocolServerBase protocolServer) in D:\DemoProject\PRemoteM\PRM.Core\Model\GlobalData.cs:line 79
   at PRM.ViewModel.VmServerEditorPage.<get_CmdSave>b__34_0(Object o) in D:\DemoProject\PRemoteM\PRemoteM\ViewModel\VmServerEditorPage.cs:line 127
   at Shawn.Utils.RelayCommand.Execute(Object parameter) in D:\DemoProject\PRemoteM\PRM.Core\Utils\RelayCommand.cs:line 48
   at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
   at System.Windows.Controls.Primitives.ButtonBase.OnClick()
   at System.Windows.Controls.Button.OnClick()
   at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
   at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
   at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
   at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
   at System.Windows.Input.InputManager.ProcessStagingArea()
   at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
   at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
   at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
   at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)

Recent Log

2021-03-25T14:08:27.3939595+01:00[ThreadId:0000000004]		Debug		Check update.
2021-03-25T14:10:26.0435749+01:00[ThreadId:0000000001]		Debug		OrderServerList: GroupNameDesc
2021-03-25T14:10:35.6678715+01:00[ThreadId:0000000004]		Debug		Check update.
2021-03-25T14:14:09.1593349+01:00[ThreadId:0000000001]		Debug		OrderServerList: GroupNameDesc
2021-03-25T14:14:16.9064325+01:00[ThreadId:0000000001]		Debug		Call shortcut to invoke quick window.
2021-03-25T14:14:16.9474376+01:00[ThreadId:0000000001]		Debug		OrderServerList: GroupNameDesc
2021-03-25T14:14:18.7737629+01:00[ThreadId:0000000004]		Debug		Check update.
2021-03-25T14:14:32.9179333+01:00[ThreadId:0000000001]		Fatal		code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
no such column: UpdatedToken
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2813
   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 572
   at PRM.Core.DB.Dapper.DapperDb.UpdateServer(ProtocolServerBase server) in D:\DemoProject\PRemoteM\PRM.Core\DB\Dapper\DapperDb.cs:line 120
   at PRM.Core.Model.DbOperator.DbUpdateServer(ProtocolServerBase org) in D:\DemoProject\PRemoteM\PRM.Core\Model\DbOperator.cs:line 296
   at PRM.Core.Model.GlobalData.ServerListUpdate(ProtocolServerBase protocolServer) in D:\DemoProject\PRemoteM\PRM.Core\Model\GlobalData.cs:line 79
   at PRM.ViewModel.VmServerEditorPage.<get_CmdSave>b__34_0(Object o) in D:\DemoProject\PRemoteM\PRemoteM\ViewModel\VmServerEditorPage.cs:line 127
   at Shawn.Utils.RelayCommand.Execute(Object parameter) in D:\DemoProject\PRemoteM\PRM.Core\Utils\RelayCommand.cs:line 48
   at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
   at System.Windows.Controls.Primitives.ButtonBase.OnClick()
   at System.Windows.Controls.Button.OnClick()
   at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
   at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
   at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
   at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
   at System.Windows.Input.InputManager.ProcessStagingArea()
   at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
   at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
   at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
   at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2813
   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 572
   at PRM.Core.DB.Dapper.DapperDb.UpdateServer(ProtocolServerBase server) in D:\DemoProject\PRemoteM\PRM.Core\DB\Dapper\DapperDb.cs:line 120
   at PRM.Core.Model.DbOperator.DbUpdateServer(ProtocolServerBase org) in D:\DemoProject\PRemoteM\PRM.Core\Model\DbOperator.cs:line 296
   at PRM.Core.Model.GlobalData.ServerListUpdate(ProtocolServerBase protocolServer) in D:\DemoProject\PRemoteM\PRM.Core\Model\GlobalData.cs:line 79
   at PRM.ViewModel.VmServerEditorPage.<get_CmdSave>b__34_0(Object o) in D:\DemoProject\PRemoteM\PRemoteM\ViewModel\VmServerEditorPage.cs:line 127
   at Shawn.Utils.RelayCommand.Execute(Object parameter) in D:\DemoProject\PRemoteM\PRM.Core\Utils\RelayCommand.cs:line 48
   at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated)
   at System.Windows.Controls.Primitives.ButtonBase.OnClick()
   at System.Windows.Controls.Button.OnClick()
   at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
   at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
   at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
   at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
   at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
   at System.Windows.Input.InputManager.ProcessStagingArea()
   at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
   at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
   at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
   at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
Originally created by @majkinetor on GitHub (Mar 25, 2021). Original GitHub issue: https://github.com/1Remote/1Remote/issues/100 Originally assigned to: @VShawn on GitHub. Happens when I open existing connection config and just click save. <details> ## Environment | Component | Version | |:------------------|:--------------------------------------| |PRemoteM | `0.5.10`(EXE release)| |.NET Framework | `.NET Framework 4.8` | |CLR | `4.0.30319.42000` | |OS | `Windows 10 Enterprise 64-bits 6.2.9200.0 (2009)` | ## Error Info SQL logic error no such column: UpdatedToken ## Stack Trace ``` at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) at System.Data.SQLite.SQLiteCommand.BuildNextCommand() at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2813 at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 572 at PRM.Core.DB.Dapper.DapperDb.UpdateServer(ProtocolServerBase server) in D:\DemoProject\PRemoteM\PRM.Core\DB\Dapper\DapperDb.cs:line 120 at PRM.Core.Model.DbOperator.DbUpdateServer(ProtocolServerBase org) in D:\DemoProject\PRemoteM\PRM.Core\Model\DbOperator.cs:line 296 at PRM.Core.Model.GlobalData.ServerListUpdate(ProtocolServerBase protocolServer) in D:\DemoProject\PRemoteM\PRM.Core\Model\GlobalData.cs:line 79 at PRM.ViewModel.VmServerEditorPage.<get_CmdSave>b__34_0(Object o) in D:\DemoProject\PRemoteM\PRemoteM\ViewModel\VmServerEditorPage.cs:line 127 at Shawn.Utils.RelayCommand.Execute(Object parameter) in D:\DemoProject\PRemoteM\PRM.Core\Utils\RelayCommand.cs:line 48 at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated) at System.Windows.Controls.Primitives.ButtonBase.OnClick() at System.Windows.Controls.Button.OnClick() at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e) at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e) at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent) at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e) at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args) at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args) at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted) at System.Windows.Input.InputManager.ProcessStagingArea() at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input) at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport) at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel) at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) ``` ## Recent Log ``` 2021-03-25T14:08:27.3939595+01:00[ThreadId:0000000004] Debug Check update. 2021-03-25T14:10:26.0435749+01:00[ThreadId:0000000001] Debug OrderServerList: GroupNameDesc 2021-03-25T14:10:35.6678715+01:00[ThreadId:0000000004] Debug Check update. 2021-03-25T14:14:09.1593349+01:00[ThreadId:0000000001] Debug OrderServerList: GroupNameDesc 2021-03-25T14:14:16.9064325+01:00[ThreadId:0000000001] Debug Call shortcut to invoke quick window. 2021-03-25T14:14:16.9474376+01:00[ThreadId:0000000001] Debug OrderServerList: GroupNameDesc 2021-03-25T14:14:18.7737629+01:00[ThreadId:0000000004] Debug Check update. 2021-03-25T14:14:32.9179333+01:00[ThreadId:0000000001] Fatal code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error no such column: UpdatedToken at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) at System.Data.SQLite.SQLiteCommand.BuildNextCommand() at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2813 at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 572 at PRM.Core.DB.Dapper.DapperDb.UpdateServer(ProtocolServerBase server) in D:\DemoProject\PRemoteM\PRM.Core\DB\Dapper\DapperDb.cs:line 120 at PRM.Core.Model.DbOperator.DbUpdateServer(ProtocolServerBase org) in D:\DemoProject\PRemoteM\PRM.Core\Model\DbOperator.cs:line 296 at PRM.Core.Model.GlobalData.ServerListUpdate(ProtocolServerBase protocolServer) in D:\DemoProject\PRemoteM\PRM.Core\Model\GlobalData.cs:line 79 at PRM.ViewModel.VmServerEditorPage.<get_CmdSave>b__34_0(Object o) in D:\DemoProject\PRemoteM\PRemoteM\ViewModel\VmServerEditorPage.cs:line 127 at Shawn.Utils.RelayCommand.Execute(Object parameter) in D:\DemoProject\PRemoteM\PRM.Core\Utils\RelayCommand.cs:line 48 at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated) at System.Windows.Controls.Primitives.ButtonBase.OnClick() at System.Windows.Controls.Button.OnClick() at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e) at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e) at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent) at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e) at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args) at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args) at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted) at System.Windows.Input.InputManager.ProcessStagingArea() at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input) at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport) at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel) at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) at System.Data.SQLite.SQLiteCommand.BuildNextCommand() at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2813 at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 572 at PRM.Core.DB.Dapper.DapperDb.UpdateServer(ProtocolServerBase server) in D:\DemoProject\PRemoteM\PRM.Core\DB\Dapper\DapperDb.cs:line 120 at PRM.Core.Model.DbOperator.DbUpdateServer(ProtocolServerBase org) in D:\DemoProject\PRemoteM\PRM.Core\Model\DbOperator.cs:line 296 at PRM.Core.Model.GlobalData.ServerListUpdate(ProtocolServerBase protocolServer) in D:\DemoProject\PRemoteM\PRM.Core\Model\GlobalData.cs:line 79 at PRM.ViewModel.VmServerEditorPage.<get_CmdSave>b__34_0(Object o) in D:\DemoProject\PRemoteM\PRemoteM\ViewModel\VmServerEditorPage.cs:line 127 at Shawn.Utils.RelayCommand.Execute(Object parameter) in D:\DemoProject\PRemoteM\PRM.Core\Utils\RelayCommand.cs:line 48 at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated) at System.Windows.Controls.Primitives.ButtonBase.OnClick() at System.Windows.Controls.Button.OnClick() at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e) at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e) at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent) at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e) at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args) at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args) at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted) at System.Windows.Input.InputManager.ProcessStagingArea() at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input) at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport) at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel) at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) ``` </details>
kerem 2026-02-28 12:00:57 +03:00
kerem commented 2026-02-28 12:00:58 +03:00
Author
Owner
Copy link

@VShawn commented on GitHub (Mar 25, 2021):

forgot about that Dapper not support code first.

Try this one :
0.5.10beta.zip

<!-- gh-comment-id:806872269 --> @VShawn commented on GitHub (Mar 25, 2021): forgot about that Dapper not support code first. Try this one : [0.5.10beta.zip](https://github.com/VShawn/PRemoteM/files/6205521/0.5.10beta.zip)
kerem commented 2026-02-28 12:00:58 +03:00
Author
Owner
Copy link

@majkinetor commented on GitHub (Mar 25, 2021):

That works.

<!-- gh-comment-id:806878590 --> @majkinetor commented on GitHub (Mar 25, 2021): That works.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
revert-1084-1080-fix-by-itagagaki
main_1.2.1
Branch_1.1.1-store_only
Branch_1.1.2-store_only
RDP_based_on_winform
dev_PRemoteM_Achieved
Doc
1.2.1
1.2.0
1.1.1
1.1.0
1.0.0
0.7.2.8
0.7.2.7
0.7.2.6
0.7.2.3
0.7.2.2
0.7.2.1
Nightly
0.7.2
0.7.1.7
0.7.1.6
0.7.1.5
0.7.0
0.7.0-pre-release-3
0.7.0-pre-release-2
0.7.0-pre-release
0.6.2.1
0.6.2
0.6.1.1
0.6.1
0.6.0
0.6.0-beta
0.5.11.2
0.5.11
0.5.11-beta
0.5.10.2
0.5.10.1
0.5.10
0.5.9.2102191952
0.5.8.2101161513
0.5.7.2012240828
0.5.5.2012131811
0.5.5.2012072119
0.5.3.2012012220
0.5.2.2011271900
0.5.1.2011192133
0.5.1.2011110905
0.5.0.2010171729
0.4.8.2008150945
0.4.8.2008141135
0.4.7.2007161608
V0.2.5
Labels
Clear labels   
area-configuration

   
area-ct-app

   
area-ct-rdp

   
area-ct-remoteapp

   
area-ct-ssh

   
area-ct-vnc

   
area-launcher

   
area-list

   
area-tags

   
area-teamwork

   
bug

   
chore

   
dependencies

   
general-build/ci

   
general-performance

   
general-refactor

   
general-security

   
general-supportive

   
general-ux

   
meta-documentation

   
meta-enhancement

   
meta-enhancement

   
meta-feature

   
meta-help-wanted

   
meta-unknown-error

   
priority-hi

   
priority-low

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
resolution-duplicate

   
resolution-invalid

   
resolution-wontfix

   
stale

   
task-put-off

   
task-still-considering

   
task-working-in-progress
No labels
area-configuration
area-ct-app
area-ct-rdp
area-ct-remoteapp
area-ct-ssh
area-ct-vnc
area-launcher
area-list
area-tags
area-teamwork
bug
chore
dependencies
general-build/ci
general-performance
general-refactor
general-security
general-supportive
general-ux
meta-documentation
meta-enhancement
meta-enhancement
meta-feature
meta-help-wanted
meta-unknown-error
priority-hi
priority-low
pull-request
question
resolution-duplicate
resolution-invalid
resolution-wontfix
stale
task-put-off
task-still-considering
task-working-in-progress
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/1Remote#1042
No description provided.