I have also tried to if any fix here (https://github.com/aspnetboilerplate/aspnetboilerplate/issues/5272) so i tried adding to the typeroots,do you know the correct way to do this? if this is the fix.
"typeRoots": [ "../node_modules/@types", "..abp-web-resources/", "...index.d.ts"
Thanks
Hi
Downloaded latest and i have this issue, do you know a fix for it.
error - cannot find name 'abp'
export function getRecaptchaLanguage(): string { return new LocaleMappingService().map('recaptcha', abp.localization.currentLanguage.name); }
Thanks
Hi, any find on fix from my suggested change?
I dropboxed the zip
sure i will do.
Doesnt look like its changed.
public class User : AbpUser<User> {
public virtual Guid? ProfilePictureId { get; set; }
public virtual bool ShouldChangePasswordOnNextLogin { get; set; }
public DateTime? SignInTokenExpireTimeUtc { get; set; }
public string SignInToken { get; set; }
public string GoogleAuthenticatorKey { get; set; }
public List<UserOrganizationUnit> OrganizationUnits { get; set; }
//Can add application specific user properties here
public User()
{
IsLockoutEnabled = true;
IsTwoFactorEnabled = true;
}
public static User CreateTenantAdminUser(int tenantId, string emailAddress)
{
var user = new User
{
TenantId = tenantId,
UserName = AdminUserName,
Name = AdminUserName,
Surname = AdminUserName,
EmailAddress = emailAddress,
Roles = new List<UserRole>(),
OrganizationUnits = new List<UserOrganizationUnit>()
};
user.SetNormalizedNames();
return user;
}
public override void SetNewPasswordResetCode()
{
/* This reset code is intentionally kept short.
* It should be short and easy to enter in a mobile application, where user can not click a link.
*/
PasswordResetCode = Guid.NewGuid().ToString("N").Truncate(10).ToUpperInvariant();
}
public void Unlock()
{
AccessFailedCount = 0;
LockoutEndDateUtc = null;
}
public void SetSignInToken()
{
SignInToken = Guid.NewGuid().ToString();
SignInTokenExpireTimeUtc = Clock.Now.AddMinutes(1).ToUniversalTime();
}
}
in fact all those column names of abpusers in invalid.
'IsDeleted'. Invalid column name 'Id'. Invalid column name 'CreationTime'. Invalid column name 'CreatorUserId'. Invalid column name 'DeleterUserId'. Invalid column name 'DeletionTime'. Invalid column name 'IsDeleted'. Invalid column name 'LastModificationTime'. Invalid column name 'LastModifierUserId'. Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. Invalid column name 'Id'. Invalid column name 'CreationTime'. Invalid column name 'CreatorUserId'. Invalid column name 'DeleterUserId'. Invalid column name 'DeletionTime'. Invalid column name 'IsDeleted'. Invalid column name 'LastModificationTime'. Invalid column name 'LastModifierUserId'.
Hi
Yes i see this in relation to the abpusers table for the isDeleted column.
INFO 2020-04-05 08:47:43,013 [37 ] c.Infrastructure.ControllerActionInvoker - Route matched with {area = "app", action = "GetCurrentUserProfileForEdit", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task1[EZNow.Authorization.Users.Profile.Dto.CurrentUserProfileEditDto] GetCurrentUserProfileForEdit() on controller EZNow.Authorization.Users.Profile.ProfileAppService (EZNow.Application). ERROR 2020-04-05 08:47:43,647 [29 ] Mvc.ExceptionHandling.AbpExceptionFilter - Invalid column name 'IsDeleted'. Invalid column name 'Id'. Invalid column name 'CreationTime'. Invalid column name 'CreatorUserId'. Invalid column name 'DeleterUserId'. Invalid column name 'DeletionTime'. Invalid column name 'IsDeleted'. Invalid column name 'LastModificationTime'. Invalid column name 'LastModifierUserId'. Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsDeleted'. Invalid column name 'Id'. Invalid column name 'CreationTime'. Invalid column name 'CreatorUserId'. Invalid column name 'DeleterUserId'. Invalid column name 'DeletionTime'. Invalid column name 'IsDeleted'. Invalid column name 'LastModificationTime'. Invalid column name 'LastModifierUserId'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext()
at System.Linq.Enumerable.Single[TSource](IEnumerable1 source) at lambda_method(Closure , QueryContext ) at System.Linq.Queryable.Single[TSource](IQueryable1 source)
at EZNow.Authorization.Users.Profile.ProfileAppService.GetCurrentUserProfileForEdit() in E:\Projects\EZNow\EZNow-API\src\EZNow.Application\Authorization\Users\Profile\ProfileAppService.cs:line 99
at lambda_method(Closure , Object )
at Microsoft.Extensions.Internal.ObjectMethodExecutorAwaitable.Awaiter.GetResult()
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
Hi
If my query for the joins are not working, would it be best to extend the zero user table and add all the new columns into that table so i dont need to use the join? If i did extend existing table is this likely to cause other dependencies to break?
Or can you tell me why this query and code does not work?
Thanks.
Its the query code its this that causes the 500 and debug doesnt get to my breakpoint for the query.