SaiGonSoftware / Awesome-CMS-Core

Awesome CMS Core is an open source CMS built using ASP.Net Core & ReactJS with module seperation concern in mind and provide lastest trend of technology like .Net Core, React, Webpack, SASS, Background Job, Message Queue.
https://awesomecmscore.azurewebsites.net/
Apache License 2.0
416 stars 137 forks source link

Unable to run application due #376

Open PeterJD opened 5 years ago

PeterJD commented 5 years ago

Unable to run application due to duplicate key being entered into AspNetUsers if I delete data still error appears

if I then disable the code not to add record still fails

ngohungphuc commented 5 years ago

How can it be. Because the SeedData.cs contain unique entity. Can you try to truncate the data from your database and run application again to have a seed data

PeterJD commented 5 years ago

Have you got the script to build the database CMSCore this appears to be the problem

One of the many errors:- System.AggregateException HResult=0x80131500 Message=One or more errors occurred. (An error occurred while updating the entries. See the inner exception for details.) Source=System.Private.CoreLib StackTrace: at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) at System.Threading.Tasks.Task.Wait() at AwesomeCMSCore.Program.Main(String[] args) in C:\Users\Awesome-CMS-Core-master\src\AwesomeCMSCore\AwesomeCMSCore\Program.cs:line 23

Inner Exception 1: DbUpdateException: An error occurred while updating the entries. See the inner exception for details.

Inner Exception 2: SqlException: Cannot insert the value NULL into column 'IsDeleted', table 'CMSCore.dbo.Posts'; column does not allow nulls. INSERT fails. The statement has been terminated.

System.AggregateException HResult=0x80131500 Message=One or more errors occurred. (An error occurred while updating the entries. See the inner exception for details.) Source=System.Private.CoreLib StackTrace: at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) at System.Threading.Tasks.Task.Wait() at AwesomeCMSCore.Program.Main(String[] args) in C:\Users\Awesome-CMS-Core-master\src\AwesomeCMSCore\AwesomeCMSCore\Program.cs:line 23

Inner Exception 1: DbUpdateException: An error occurred while updating the entries. See the inner exception for details.

Inner Exception 2: SqlException: Invalid object name 'Comments'.

PeterJD commented 5 years ago

nlog-all-2019-04-12.log nlog-own-2019-04-11.log nlog-own-2019-04-12.log

PeterJD commented 5 years ago

Well shorted the DB out, but still having issues running the program, I follow your instruction which seem a little peace meal (not detailed enough) Are you in the position to give me more detailed instruction?

ngohungphuc commented 5 years ago

Do you have skype so I can make a call