Field 'gotw_points' doesn't have a default value

[KermitLABZ]

Field 'gotw_points' doesn't have a default value

 

[0AK]

You need to add the gotw_points column in your users table.

 

[JayC]

Is it not obvious? You need to add the gotw_points column in your users table.

1) The error message says that it doesn't have a default value, which means its in his table and hes trying to insert a query that is going to try to assign "gotw_points" NO VALUE. His Database doesn't allow that.

2) He never said "gotw_points" was in his users table so don't just assume it is, and it is ALREADY in his table that he is trying to add.

Ignore this moron who thinks he knows what he is doing. The correct way to fix this error is to open your database in design view, go down to the column and you can do one of two things:
1) You can make it so that gotw_points can have no value by allowing Null. While this can be useful, it could also be bad depending on what gotw_points does so I would rather do option 2:
2) You can set a default value, not sure what gotw_points does but I would set the default value = 0.