© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•2y ago•
3 replies
morry329#

MySqlException: Field 'CreatedOnUtc' doesn't have a default value

So I have been creating a very simple ASP.NET Core application lately with a simple mariaDB configuration and nginx

Once the dotnet run has been typed, a web app pops up on Chrome prompting me to enter login credentials. As the combination of root-root (for both of username and password) is not allowed there, I opted to create a new user.

The web app now prompted me to create brand new credentials (email, password, username). Once those have been entered and the submit button has been hit, the following error got triggered

https://pastebin.com/GrcSaHQZ

I tried to find that field in question:
MySqlException: Field 'CreatedOnUtc' doesn't have a default value
MySqlException: Field 'CreatedOnUtc' doesn't have a default value


ChatGPT gave me this collection of potential fixes https://pastebin.com/nUDiybVk but none of them could not find that field/column
CreatedOnUtc
CreatedOnUtc


Would it be a good idea to create that column on my db with the default value? Do you have any other idea how to fix this error??
Pastebin
An unhandled exception occurred while processing the request.MySqlE...
Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
Pastebin
To find out which table in your database has the CreatedOnUtc field...
Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

MySqlException: Table 'searchhome.aspnetusers' doesn't exist
C#CC# / help
2y ago
✅ Binding array with default value doesn't work
C#CC# / help
3y ago
❔ Anyone knows how to have a "default value" in a ComboBox?
C#CC# / help
3y ago
Setting a Default Value for Migrations
C#CC# / help
16mo ago