Hi there, we cant create users atm on version 12.3.0
Error: Service: UserAppService Action: CreateOrUpdateUser
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'TargetNotifiers'.
at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__208_0(Task1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke()
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)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable1 source, CancellationToken cancellationToken)
at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.GetAllListAsync(Expression1 predicate)
at Ab...
TargetNotifiers is missing on AbpNotificationSubscriptions
according to ...DbContextModelSnapshot I should have a TargetNotifiers but I don't have a migration for it
I tried to add a new migration, its was empty and did not add TargetNotifiers :(
note that TargetNotifiers does exist on AbpNotifications and AbpUserNotifications (there is migrations for those 2) but nothing for AbpNotificationSubscriptions
all my ABP NuGet package versions are 8.3.1
4 Answer(s)
-
0
Hi @portsyn
Is it possible to access your project's source code somehow ? It would be easier to find the problem in that way. Please send an email to [email protected] if that is possible.
Thanks,
-
0
Code sent to [email protected].
-
0
more information, i checked out a fresh copy of 12.3.0 and run on brand new data base (I run all the migrations)
Applying migration '20170406083347_Initial_Migration'. Applying migration '20170623075109_AspNetZero_V4_1_Changes'. Applying migration '20170704084731_Added_GoogleAuthenticatorKey_Column'. Applying migration '20170714081027_Added_Relation_Between_Edition_And_SubscriptionPayment'. Applying migration '20170724142223_Upgraded_To_Abp_V2_2'. Applying migration '20170913133916_Added_SharedMessageId_To_ChatMessage'. Applying migration '20170914070123_Added_ReceiverReadState_To_ChatMessage'. Applying migration '20170914084815_Invoice_Changes'. Applying migration '20170914121022_TypeChange_SharedMessageId_String_Guid'. Applying migration '20180118065703_Added_Entity_History'. Applying migration '20180320065710_Upgraded_To_Abp_V3_5'. Applying migration '20180718081610_Abp_v3_7_Changes'. Applying migration '20180726063233_Upgraded_ABP_v3.8.0'. Applying migration '20180731052649_Upgrade_ABP_v3.8.1'. Applying migration '20180807062930_Upgrade_ABP_v3.8.2'. Applying migration '20181012141151_Upgraded_To_Abp_v3_9_0'. Applying migration '20190103081952_Recurring_Payment_Changes'. Applying migration '20190208083524_Upgraded_To_Abp_v4_2_0'. Applying migration '20190304131651_Added_User_OrganizationUnits'. Applying migration '20190501074213_Changed_Billing_Setting_Names'. Applying migration '20190722073429_Upgrated_To_ABP_4_8_0'. Applying migration '20190801133107_Updated_SubscribableEdition'. Applying migration '20191015062846_Add_Subscription_Payment_Extension_Data'. Applying migration '20191120123128_Add-EditionPaymentType-To-SubscriptionPayment'. Applying migration '20191213093244_Upgraded_To_ABP_5_1'. Applying migration '20200117141413_Upgraded_To_ABP_5_2_0'. Applying migration '20200305082815_Upgraded_To_Abp_5_3'. Applying migration '20200315101156_Added_UserDelegations_Entity'. Applying migration '20200317114116_Add_Dynamic_Entity_Parameters'. Applying migration '20200406060103_Remove_OrganizationUnit_Unique_Index'. Applying migration '20200805083139_Upgraded_To_Abp_5_11'. Applying migration '20200928121432_Add_Description_To_Binary_Object'. Applying migration '20201020131501_Upgraded_To_IdentityServer_v4'. Applying migration '20201111120911_Upgraded_To_Abp_6_0'. Applying migration '20201217075257_Upgrade_To_ABP_6_1'. Applying migration '20210224123746_Upgraded_To_Abp_6_3'. Applying migration '20210622135427_Upgraded_To_Abp_6_4_0'. Applying migration '20220118115029_Added_User_Recent_Passwords'. Applying migration '20220516051930_Fix_Index_On_Subscription_Payment_Extension_Data'. Applying migration '20220607073405_Add_Mass_Notifications'. Applying migration '20221014130904_Upgraded_To_Abp_7_4'. Applying migration '20221024112751_Seperate_Tenant_Dark_And_Light_Logo'. Applying migration '20221120214337_Add_Authenticator_Recovery_Code'. Applying migration '20230418082608_Removed_IdentityServer4'. Applying migration '20230517094454_Added_OpenIddict_Entities'. Applying migration '20230720123224_Add_Minimal_Logo'. Done.
then try run the API. I get the same error:
Microsoft.EntityFrameworkCore.DbUpdateException: 'An error occurred while saving the entity changes. See the inner exception for details.' SqlException: Invalid column name 'TargetNotifiers'. Invalid column name 'TargetNotifiers'. this is at startup as xxx.Migrations.Seed.Host.CreateHostRoleAndUsers -> context.SaveChanges();
-
0
I saw that there is a version 12.3.1 under generate on asp net zero that added the mission migration
I upgraded to 12.3.1 and it fixed the issue, thanks.
please also update the release notes to let the rest of the world know that there is a 12.3.1 https://docs.aspnetzero.com/en/common/latest/Change-Logs
Thanks
