question regarding bcstorm.

[Stevee]

so im using bcstorm with revCMS, what happens is it loads and everything like it says the little welcome message and the hotelview. it also says "Connection received, lets do this." then it disconnects and says "Error in query caught"...

You must be registered for see links

- This is what its showing and it disconnects after that every time.


any suggestions?

 

[KyleVonnie]

Post the error that is show in exceptions?

 

[Stevee]

Post the error that is show in exceptions?

its a mySQL issue

Error in query:
UPDATE users SET users.online = '0', users.points_online = '0', users.last_online = '2/4/2013 6:27:43 PM', activity_points = 10100, activity_points_lastupdate = '1360027659', credits = 8100, achievement_points = 5, crystals = '0' WHERE id = 353 ;
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()

 

[KyleVonnie]

Try to use a new DB and a new SQL file instead?

 

[Stevee]

Try to use a new DB and a new SQL file instead?

I don't think it's a database thing because I've used this before earlier, I've never had this error though.