YAFLogo

Phil D
  • Phil D
  • 70.6% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 4
a month ago
"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."

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)
Sponsor

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
a month ago
Are you running the YAF BETA or is that a modified version? This exception should not occur on a new install
Phil D
  • Phil D
  • 70.6% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 4
a month ago
YAFNET v3.2.2 is the version
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
a month ago
Originally Posted by: Phil D 

YAFNET v3.2.2 is the version



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.
Phil D
  • Phil D
  • 70.6% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 4
a month ago
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.
 
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
a month ago
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?
Phil D
  • Phil D
  • 70.6% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 4
a month ago
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.
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
a month ago
Originally Posted by: Phil D 

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.



Is the folder where you uploaded the file correctly set as application in iis?
Phil D
  • Phil D
  • 70.6% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 4
a month ago
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.
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
a month ago
Okay, and what browser are you using?
Phil D
  • Phil D
  • 70.6% (Friendly)
  • YAF Forumling Topic Starter YAF Version: 4
a month ago
Chrome currently
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
a month ago
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?
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button