C#•16mo ago

MySqlException: Column 'Age' cannot be null

So this error occured in the following scenario: I have created a simple ASP.NET Core web app with some simple db configurations. On running dotnet run from Rider, the browser displayed my web app (a login form). I have click "register a new user". Then I was redirected to a register form page with three textfields , email, password and repeat password. I filled in all of them and hit register. Now I was bugged with this bunch of exception texts https://pastebin.com/7DqbUai5

I don't understand this error Column 'Age' cannot be null. I made extra sure that my DB has the column Age with non-null values like this:

mysql> SELECT * FROM PortalUsers;
+---------------+------+-------------+-------------------------------------------------+
| Name          | Age  | Location    | DisplayInfo                                     |
+---------------+------+-------------+-------------------------------------------------+
| Alice Smith   | 30   | New York    | Name: Alice Smith Age: 30 Location: New York    |
| Bob Johnson   | 25   | Los Angeles | Name: Bob Johnson Age: 25 Location: Los Angeles |
| Charlie Brown | 35   | Chicago     | Name: Charlie Brown Age: 35 Location: Chicago   |
+---------------+------+-------------+-------------------------------------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM PortalUsers;
+---------------+------+-------------+-------------------------------------------------+
| Name          | Age  | Location    | DisplayInfo                                     |
+---------------+------+-------------+-------------------------------------------------+
| Alice Smith   | 30   | New York    | Name: Alice Smith Age: 30 Location: New York    |
| Bob Johnson   | 25   | Los Angeles | Name: Bob Johnson Age: 25 Location: Los Angeles |
| Charlie Brown | 35   | Chicago     | Name: Charlie Brown Age: 35 Location: Chicago   |
+---------------+------+-------------+-------------------------------------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM PortalUsers;
+---------------+------+-------------+-------------------------------------------------+
| Name          | Age  | Location    | DisplayInfo                                     |
+---------------+------+-------------+-------------------------------------------------+
| Alice Smith   | 30   | New York    | Name: Alice Smith Age: 30 Location: New York    |
| Bob Johnson   | 25   | Los Angeles | Name: Bob Johnson Age: 25 Location: Los Angeles |
| Charlie Brown | 35   | Chicago     | Name: Charlie Brown Age: 35 Location: Chicago   |
+---------------+------+-------------+-------------------------------------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM PortalUsers;
+---------------+------+-------------+-------------------------------------------------+
| Name          | Age  | Location    | DisplayInfo                                     |
+---------------+------+-------------+-------------------------------------------------+
| Alice Smith   | 30   | New York    | Name: Alice Smith Age: 30 Location: New York    |
| Bob Johnson   | 25   | Los Angeles | Name: Bob Johnson Age: 25 Location: Los Angeles |
| Charlie Brown | 35   | Chicago     | Name: Charlie Brown Age: 35 Location: Chicago   |
+---------------+------+-------------+-------------------------------------------------+
3 rows in set (0.00 sec)

`

For your reference this is the link to the codes https://pastebin.com/k88fKn7r

Could anyone point me in the right direction?
I want to solve this error but I need another set of eyes

PS: I am just thinking that this error may refer to the column Age which belongs to another table from another DB. The output displayed here came from the table PortalUser in the searchhome DB, but I may have another PortalUser table in my second DB. If that is the case will this error point to that another PortalUser which may have no column values? Hope all this makes sense.

Pastebin

fail: Microsoft.EntityFrameworkCore.Database.Command[20102] Fa...

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

//Model class with the columns like 'Age'using Microsoft.AspNetCore...

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.

MySqlException: Column 'Age' cannot be null

Similar Threads

Similar Threads

Similar Threads