error?

[Stevee]

whenever I register I keep getting this error...

Field 'Weights' doesn't have a default value



I've never seen that before, any idea how to fix?

 

[Lirinya]

When ever you register to your own retro or somebody elses or what..that's really not too specific.

 

[Stevee]

When ever you register to your own retro or somebody elses or what..that's really not too specific.

Whenever I register to my own retro....

 

[Lirinya]

Is it the first time you're setting it up or have you just changed something?
Weights isn't a table I've seen but I would assume it means you've set something up incorrectly.

 

[Find]

try giving it a default value

 

[Stevee]

try giving it a default value

like what value should I give it?

 

[Find]

like what value should I give it?

0

 

[Stevee]

0

okay, I did that and I get two MySQL errors.

Error in query: 
UPDATE users SET users.online = '0', users.points_online = '49', users.last_online = '2/6/2013 6:49:23 PM', activity_points = 10400, activity_points_lastupdate = '1360201435', credits = 10120, achievement_points = 110, crystals = '0' WHERE id = 31 ;
MySql.Data.MySqlClient.MySqlException (0x80004005): Out of range value for column 'activity_points_lastupdate' at row 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()


Error in query: 
UPDATE users SET users.online = '0', users.points_online = '2', users.last_online = '2/6/2013 7:56:56 PM', activity_points = 10100, activity_points_lastupdate = '1360205774', credits = 8100, achievement_points = 10, crystals = '0' WHERE id = 36 ;
MySql.Data.MySqlClient.MySqlException (0x80004005): Out of range value for column 'activity_points_lastupdate' at row 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()

 

[Find]

Well that's nothing to do with the column you touched so idk why thats coming up

 

[Stevee]

Well that's nothing to do with the column you touched so idk why thats coming up

oh, after that column I had to set a value for couple different columns as well.