Desktop app crashing after first run

Anyone else see this where it goes in the system tray but when you try to open it it immediately closes? Started happening months ago and I’ve reinstalled all the way to the latest version and still see this in the windows app logs:

Exception Info: System.AggregateException: One or more errors occurred. (An error occured while executing a database query: GetUserQuery. Check inner exception for more details.)
—> Toggl.Storage.Exceptions.DatabaseQueryException: An error occured while executing a database query: GetUserQuery. Check inner exception for more details.
—> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: ‘no such column: w.Admin’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)

If anyone else figured out how to get passed this I’d appreciate it. Thx.

Hey there! Can you share what version of the app you have installed, as well as the version of Windows you’re currently running?

Toggl: 9.5.0
image

Win 11: 10.0.26100 build 26100
image

I just tried to download and reinstall again and this time made sure everything else was deleted. It opened and showed a login screen. I closed it without logging in and when I reopened the login screen shows for a minute and it still closes by itself.

Thanks for that! And just to make sure: this happens even after fully logging in?

Yes, it was happening when I was logged in too, but now I can’t log in because it closes before I can type anything in.

Most recent event viewer log:

Application: TogglTrack.exe
CoreCLR Version: 8.0.23.53103
.NET Version: 8.0.0
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AggregateException: One or more errors occurred. (An error occured while executing a database query: GetUserQuery. Check inner exception for more details.)
—> Toggl.Storage.Exceptions.DatabaseQueryException: An error occured while executing a database query: GetUserQuery. Check inner exception for more details.
—> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: ‘no such column: w.Admin’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.Enumerator.InitializeReader(Enumerator enumerator) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.Enumerator.<>c.b__21_0(DbContext _, Enumerator enumerator)
at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.Enumerator.MoveNext() at System.Linq.Enumerable.TryGetSingle[TSource](IEnumerable1 source, Boolean& found)
at lambda_method223(Closure, QueryContext)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression)
at Toggl.Storage.EntityFramework.Queries.GetUserQuery.ExecuteQuery()
at Toggl.Storage.EntityFramework.Queries.DbQuery`1.<>c__DisplayClass3_0.b__0()
— End of inner exception stack trace —
at Toggl.Core.Login.UserAccessManager.LoginWithSavedCredentials()
— End of inner exception stack trace —
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.Wait()
at Toggl.WPF.App.getMostAccessibleViewModel(DependencyContainer dependencyContainer, MainWindow mainWindow)
at Toggl.WPF.App.activateMainWindow(String argument, SingleInstanceAppManager appInstance, WpfDependencyContainer dependencyContainer)
at Toggl.WPF.App.OnStartup(StartupEventArgs e)
at System.Windows.Application.<.ctor>b__1_0(Object unused)

Thanks for that! Lemme check on this with our team.

Thanks for the wait! Our team has informed me that the database may indeed be corrupted. To address this, they recommend that you uninstall the app, then when the dialog appears saying “Would you like to retain your application data on this device?” , you should click No, and then try reinstalling the app from:

that fixed it. I never thought to check the box to remove everything. probably should have. thx!

1 Like

Glad we got it sorted :slight_smile: Thanks!