Phoenix Emulator

[Gajeel]

So dumb to post this help thread but the error is so rare for me.

Here what pops up on the emulator:

MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 's
tamp' at row 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& i
nsertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affected
Rows, 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.ExecuteScalar()
   at Phoenix.Storage.xc133500a5775b79b.xa266202b32508032(String xe6ac21f3fcfe83
72)
   at Phoenix.HabboHotel.xa0380078f0b6cbb7.x7c4c586a5dfbb11d(xc133500a5775b79b x
75c179ac3e2d46ae)
   at Phoenix.HabboHotel.xa0380078f0b6cbb7..ctor(Int32 conns)
   at Phoenix.xcf610c81231340bb.x20aee281977480cf()
   at Phoenix.x867eb3246b182488.xc447809891322395(String[] xce8d8c7e3c2c2426)

And here is my server_status table:

Nothing is wrong with the stamp column, it is a Unix timestamp right?

 

[Sledmore]

Edit the field size of 'stamp', click ctrl + c, go to it and edit the size.

 

[Gajeel]

This is now solved. Thanks for the joke Craig, I got it. You want me to visually adjust the size of the column.

To have this error gone, run this query on your database:

SET @@global.sql_mode= '';

There you have it.

 

[Thom]

This is now solved. Thanks for the joke Craig, I got it. You want me to visually adjust the size of the column.

To have this error gone, run this query on your database:

SET @@global.sql_mode= '';

There you have it.

Aha yes, MySQL Strict mode.
Thread closed, problem solved.

 

[Sledmore]

I know this is closed, but what joke? I was being serious.. lol

I meant length, but same thing? -

You must be registered for see links