Create a solution with SQLite but fail to start the webite due to SQLite error

[raine93]

Is there an existing issue for this?

• I have searched the existing issues

Description

I created a solution with Blazor server and tried to run the website. It throw me the error: no such table AbpSettings. I have tried rebuild the solution and regenerate the migration, it will still return the same error.

SqliteException: SQLite Error 1: 'no such table: AbpSettings'.
Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(int rc, sqlite3 db)
Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable<T>+AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable<T>+AsyncEnumerator.MoveNextAsync()
System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable<TResult>+ConfiguredValueTaskAwaiter.GetResult()
Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync<TSource>(IQueryable<TSource> source, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync<TSource>(IQueryable<TSource> source, CancellationToken cancellationToken)
Volo.Abp.SettingManagement.EntityFrameworkCore.EfCoreSettingRepository.GetListAsync(string providerName, string providerKey, CancellationToken cancellationToken)
Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous<TResult>(IInvocation invocation, IInvocationProceedInfo proceedInfo)
Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue<TResult>.ProceedAsync()
Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter<TInterceptor>.InterceptAsync<TResult>(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func<IInvocation, IInvocationProceedInfo, Task<TResult>> proceed)
Volo.Abp.SettingManagement.SettingManagementStore.SetCacheItemsAsync(string providerName, string providerKey, string currentName, SettingCacheItem currentCacheItem)
Volo.Abp.SettingManagement.SettingManagementStore.GetCacheItemAsync(string name, string providerName, string providerKey)
Volo.Abp.SettingManagement.SettingManagementStore.GetOrNullAsync(string name, string providerName, string providerKey)
Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous<TResult>(IInvocation invocation, IInvocationProceedInfo proceedInfo)
Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue<TResult>.ProceedAsync()
Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter<TInterceptor>.InterceptAsync<TResult>(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func<IInvocation, IInvocationProceedInfo, Task<TResult>> proceed)
Volo.Abp.Settings.TenantSettingValueProvider.GetOrNullAsync(SettingDefinition setting)
Volo.Abp.Settings.SettingProvider.GetOrNullValueFromProvidersAsync(IEnumerable<ISettingValueProvider> providers, SettingDefinition setting)
Volo.Abp.Settings.SettingProvider.GetOrNullAsync(string name)
Microsoft.AspNetCore.RequestLocalization.DefaultAbpRequestLocalizationOptionsProvider.GetLocalizationOptionsAsync()
Microsoft.AspNetCore.RequestLocalization.AbpRequestLocalizationMiddleware.InvokeAsync(HttpContext context, RequestDelegate next)
Microsoft.AspNetCore.Builder.UseMiddlewareExtensions+InterfaceMiddlewareBinder+<>c__DisplayClass2_0+<<CreateMiddleware>b__0>d.MoveNext()
Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context)

Version

0.9.21

Operation System

Windows (Default)

Solution Configuration

No response

Other information

No response

[maliming]

What are the full steps to reproduce this error?

[raine93]

Steps:

1. New solution
2. Application (Layered) solution template
3. Enter solution name
4. Blazor server for UI framework (tried MVC/Razor Pages too, also have the same error)
5. Entity framework core, tick Create Initial Migration & Run database migrator
6. Select SQLite as database management system and tested connection succeeded
7. Untick "Enable Multi-Tenancy"
8. Select Basic UI Theme
9. None for mobile framework
10. Tick Additional Options: Sample CRUD Page & Include Tests

I am using community edition license for ABP Studio

What are the full steps to reproduce this error?

[maliming]

You can use a new SQLite database name in the connection string of all appsettings.json files and run the DbMigrator to migrate the database.

Re-run the projects again to see if this works for you.

[raine93]

I have modified database name in connection string in appsettings.json files under Blazor and DbMigrator folders and run the DbMigrator but it still have the same error

You can use a new SQLite database name in the connection string of all appsettings.json files and run the DbMigrator to migrate the database.

Re-run the projects again to see if this works for you.

[maliming]

Can you share a test project?

[raine93]

I just sent you the invitation email for the test project

Can you share a test project?

[maliming]

It works for me. You can try your project on another computer.

[raine93]

I have tried on another computer ,it still does not work. Build is succeeded, is just that the error comes out when starting the application

It works for me. You can try your project on another computer.