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
ChatGPT gave me this collection of potential fixes https://pastebin.com/nUDiybVk but none of them could not find that field/column 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.
2 Replies