search

blogifierdotnet / Blogifier

Blogifier is an open-source publishing platform Written in ASP.NET and Blazor WebAssembly. With Blogifier make a personal blog or a website.
https://blogifier.net
MIT License
1.28k stars 518 forks source link

Cannot Access Newsletter Page #191

Closed Xaninho closed 4 years ago

Xaninho commented 4 years ago

Hey everyone! First of all, as this is my first issue here, thank you for making this repository available for everyone, it's a pretty cool resource to help learning the ASP.NET Core framework 😅

I've cloned this repository, and changed the appsettings.json to use SqlServer. When I run the project, the database is succesfully created. However, as I'm exploring the project, when I click the "Newsletter" tab in the Admin Dashboard, I get this error:

imagem

imagem

Any thoughts on what happened? The only changes I've made is in the appsettings.json file, and the database appeared to be created succesfully.

rxtur commented 4 years ago

Actually, scratch below - seems like issue with different database behaviors, works for SQLite but not for SQL Server: "Cannot specify a column width on data type text". I'll check out why SQL Server is not happy.

First, check if you need to update Blogifier.Core nuget package - there should be migration adding columns to newsletters table. Blogifier checks for migrations in the program.cs on app start and runs migrations automatically, so you can check with debugger if it finds any new migrations and if there any issues executing them.

rxtur commented 4 years ago

Fix been applied with latest update, newsletter migration script should work with SQL Server now.

Xaninho commented 4 years ago

That does it. Thank you for the quick support! 😊