"The data is NULL at ordinal 1" crash a short while after starting up Launchbox

[Benjc]

I've just started getting the following error every time 20 seconds after starting up Launchbox. Then it crashes.

Don't know if it's related but I was messing around with my screen resolution shortly before this started happening.

Any ideas how to resolve this?

 

The data is NULL at ordinal 1. This method can't be called on NULL values. Check using IsDBNull before calling.

App:     LaunchBox
Version: 13.21
Theme:   Default
Type:    System.InvalidOperationException
Site:    System.String GetString(Int32)
Source:  Microsoft.Data.Sqlite

   at Microsoft.Data.Sqlite.SqliteDataReader.GetString(Int32 ordinal)
   at lambda_method224(Closure, QueryContext, DbDataReader, ResultContext, SingleQueryResultCoordinator)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Unbroken.LaunchBox.LocalDb.GamesDb.GetAllPlatformsAsync(Nullable`1 cancelToken)
   at Unbroken.LaunchBox.LocalDb.GamesDb.GetAllPlatformsAsync(Nullable`1 cancelToken)
   at Unbroken.LaunchBox.Windows.Monitoring.GameDirectoryMonitor.StartWatching()
   at Unbroken.LaunchBox.Windows.Desktop.ViewModels.MainViewModel.PatchAutowireSchema(Object)
   at Unbroken.LaunchBox.Windows.Desktop.ViewModels.MainViewModel.QueryTypeGetter()
   at Unbroken.LaunchBox.Windows.Threading.<>c__DisplayClass4_0.PushFocusProducer(Object)
   at Unbroken.LaunchBox.Windows.Threading.<>c__DisplayClass4_0.PrepareMetaMock()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)

Recent Log:

   20:58:08 Exception

[C-Beats]

11 minutes ago, Benjc said:

I've just started getting the following error every time 20 seconds after starting up Launchbox. Then it crashes.

Don't know if it's related but I was messing around with my screen resolution shortly before this started happening.

Any ideas how to resolve this?

 

The data is NULL at ordinal 1. This method can't be called on NULL values. Check using IsDBNull before calling.

App:     LaunchBox
Version: 13.21
Theme:   Default
Type:    System.InvalidOperationException
Site:    System.String GetString(Int32)
Source:  Microsoft.Data.Sqlite

   at Microsoft.Data.Sqlite.SqliteDataReader.GetString(Int32 ordinal)
   at lambda_method224(Closure, QueryContext, DbDataReader, ResultContext, SingleQueryResultCoordinator)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Unbroken.LaunchBox.LocalDb.GamesDb.GetAllPlatformsAsync(Nullable`1 cancelToken)
   at Unbroken.LaunchBox.LocalDb.GamesDb.GetAllPlatformsAsync(Nullable`1 cancelToken)
   at Unbroken.LaunchBox.Windows.Monitoring.GameDirectoryMonitor.StartWatching()
   at Unbroken.LaunchBox.Windows.Desktop.ViewModels.MainViewModel.PatchAutowireSchema(Object)
   at Unbroken.LaunchBox.Windows.Desktop.ViewModels.MainViewModel.QueryTypeGetter()
   at Unbroken.LaunchBox.Windows.Threading.<>c__DisplayClass4_0.PushFocusProducer(Object)
   at Unbroken.LaunchBox.Windows.Threading.<>c__DisplayClass4_0.PrepareMetaMock()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)

Recent Log:

   20:58:08 Exception

We had a data error in the DB file caused by one of the new platforms added to the DB. It's since been corrected. Go to Tools > Download > Force Download Games Database to correct

[Benjc]

Nope- it errors again long before the download completes. I left the download to finish anyway and once I dismissed the error the UI crashes. Does the same again upon restarting

[C-Beats]

4 hours ago, Benjc said:

Nope- it errors again long before the download completes. I left the download to finish anyway and once I dismissed the error the UI crashes. Does the same again upon restarting

Yeah, it looks like the process didn't finish quiet correctly and the same bad file is being downloaded. I'm getting the file refreshed right now. Should be good to go in the next 30m or so.

[C-Beats]

Process is done and I confirmed the download now has the corrections. Apologies for the hassle

[Benjc]

Brilliant- that seems to have sorted it now. Thanks so much👍