Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: Phil D - Thursday, 7 March 2024 11:58:57
[b]"A valid database needs to exist on your SQL Server with proper permissions set so that YAF can access it. When you run YAF for the first time it will detect that the database is empty (or needs upgrading) and will automatically run you through the process required to create the SQL database structures needed."[/b] OK - So I'm now trying to set the Database up for the first time on a Test Azure Server, I have created an empty SQL Server Database and my connection string from the Code that I am running in Visual Studio 2022 is pointing at that DB and has the Correct permissions. I have this all working locally with SQL Express and it initially created the DB fine with the Wizard. I get the following error like the code is expecting the DB to already have the Tables created? - Please Help SqlException: Invalid object name 'yaf_AspNetUsers'. ServiceStack.OrmLite.OrmLiteExecFilter.ExecIDbConnection dbConn, Func> filter) in OrmLiteExecFilter.cs + throw e; YAF.Core.Data.DbAccessBase.ExecuteAsyncFunc> execFunc) in DbAccessBase.cs + var result = await execFunc(connection); Microsoft.AspNetCore.Identity.SignInManager.ValidateSecurityStampAsync(ClaimsPrincipal principal) Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidateAsync(CookieValidatePrincipalContext context) Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler.HandleAuthenticateAsync() Microsoft.AspNetCore.Authentication.AuthenticationHandler.AuthenticateAsync() Microsoft.AspNetCore.Authentication.AuthenticationService.AuthenticateAsync(HttpContext context, string scheme) Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context) YAF.Core.Middleware.CheckBannedUserAgents.InvokeAsync(HttpContext context) in CheckBannedUserAgents.cs + await this.requestDelegate(context); YAF.Core.Middleware.CheckBannedIps.InvokeAsync(HttpContext context) in CheckBannedIps.cs + await this.requestDelegate(context); YAF.Core.Middleware.InitializeDb.InvokeAsync(HttpContext context) in InitializeDb.cs + await this.requestDelegate(context); Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) YAF.Core.Middleware.AntiXssMiddleware.InvokeAsync(HttpContext context) in AntiXssMiddleware.cs + await this.next(context).ConfigureAwait(false); Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context)

Posted by: Phil D - Thursday, 7 March 2024 11:58:57

[b]"A valid database needs to exist on your SQL Server with proper permissions set so that YAF can access it. When you run YAF for the first time it will detect that the database is empty (or needs upgrading) and will automatically run you through the process required to create the SQL database structures needed."[/b] OK - So I'm now trying to set the Database up for the first time on a Test Azure Server, I have created an empty SQL Server Database and my connection string from the Code that I am running in Visual Studio 2022 is pointing at that DB and has the Correct permissions. I have this all working locally with SQL Express and it initially created the DB fine with the Wizard. I get the following error like the code is expecting the DB to already have the Tables created? - Please Help SqlException: Invalid object name 'yaf_AspNetUsers'. ServiceStack.OrmLite.OrmLiteExecFilter.ExecIDbConnection dbConn, Func> filter) in OrmLiteExecFilter.cs + throw e; YAF.Core.Data.DbAccessBase.ExecuteAsyncFunc> execFunc) in DbAccessBase.cs + var result = await execFunc(connection); Microsoft.AspNetCore.Identity.SignInManager.ValidateSecurityStampAsync(ClaimsPrincipal principal) Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidateAsync(CookieValidatePrincipalContext context) Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler.HandleAuthenticateAsync() Microsoft.AspNetCore.Authentication.AuthenticationHandler.AuthenticateAsync() Microsoft.AspNetCore.Authentication.AuthenticationService.AuthenticateAsync(HttpContext context, string scheme) Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context) YAF.Core.Middleware.CheckBannedUserAgents.InvokeAsync(HttpContext context) in CheckBannedUserAgents.cs + await this.requestDelegate(context); YAF.Core.Middleware.CheckBannedIps.InvokeAsync(HttpContext context) in CheckBannedIps.cs + await this.requestDelegate(context); YAF.Core.Middleware.InitializeDb.InvokeAsync(HttpContext context) in InitializeDb.cs + await this.requestDelegate(context); Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) YAF.Core.Middleware.AntiXssMiddleware.InvokeAsync(HttpContext context) in AntiXssMiddleware.cs + await this.next(context).ConfigureAwait(false); Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context)

Posted by: tha_watcha - Thursday, 7 March 2024 12:16:06
Are you running the YAF BETA or is that a modified version? This exception should not occur on a new install

Posted by: Phil D - Thursday, 7 March 2024 12:55:37
YAFNET v3.2.2 is the version

Posted by: tha_watcha - Thursday, 7 March 2024 13:12:19
[quote=Phil D;74045]YAFNET v3.2.2 is the version[/quote] The error message clearly shows that you are using YAF 4 and not 3.2.2 You need to decide first which version you want to use YAF 3 for.net framework 4.8.1 or YAF 4 for.net 8.

Posted by: Phil D - Thursday, 7 March 2024 16:01:14
Thanks for that - I've sorted the version and I have now got a DB installed on azure - however when I click on any of the links in the forum I get another browser window with the following browser error displayed; This page contains the following errors: error on line 1 at column 2: StartTag: invalid element name Below is a rendering of the page up to the first error.

Posted by: tha_watcha - Friday, 8 March 2024 02:05:18
And which version are you using now? If i understand correctly the Install Wizard was completed? Did you make any modifications to yaf? Can you make a screenshot of the page?

Posted by: Phil D - Friday, 8 March 2024 10:50:07
YAFNET v3.2.2 from the Downloads page The database has deployed and the forum is up it just displays a blank page with this message in this page contains the following errors: error on line 1 at column 2: StartTag: invalid element name Below is a rendering of the page up to the first error.

Posted by: tha_watcha - Friday, 8 March 2024 10:55:48
[quote=Phil D;74059]YAFNET v3.2.2 from the Downloads page The database has deployed and the forum is up it just displays a blank page with this message in this page contains the following errors: error on line 1 at column 2: StartTag: invalid element name Below is a rendering of the page up to the first error.[/quote] Is the folder where you uploaded the file correctly set as application in iis?

Posted by: Phil D - Friday, 8 March 2024 18:05:57
I am running the app in Visual Studio 2022 using IIS Express. Everytime I click on a link it goes to the correct area in the forum but launches another Browser window with Default.aspx with the text below This page contains the following errors: error on line 1 at column 2: StartTag: invalid element name Below is a rendering of the page up to the first error.

Posted by: tha_watcha - Friday, 8 March 2024 20:07:54
Okay, and what browser are you using?

Posted by: Phil D - Saturday, 9 March 2024 08:42:58
Chrome currently

Posted by: tha_watcha - Saturday, 9 March 2024 09:34:47
Well at this point i dont have any more ideas. It tried to reproduce the issue 1. Download YAF 3.2.2 source 2. Run Solution via F5 in debugger 3. Links working One more question you are using the recommend.web.config right?

Important Information: