Phoenix error on my VPS and not on my pc

[Andre96]

Hello,

I use GTE phoenix edit and when I acept a friend request when the friend stream is open I get a error on my VPS but not on my pc with the same db and emu. This is the error I got:
5/3/2014 01:01:15: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'expire' at row 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 GoldTree.Storage.DatabaseClient.ExecuteQuery(String sQuery, Int32 timeout)
at GoldTree.HabboHotel.Support.ModerationBanManager.BanUser(GameClient Session, String string_0, Double length, String reason, Boolean banIp)
at GoldTree.HabboHotel.Support.ModerationTool.method_17(GameClient Session, UInt32 uint_0, Int32 int_0, String string_0)
at GoldTree.Communication.Messages.Help.ModBanMessageEvent.Handle(GameClient Session, ClientMessage Event)
at GoldTree.HabboHotel.GameClients.GameClient.ParsePacket(Byte[]& bytes)

3-5-2014 01:08:33: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'gender' at row 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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 GoldTree.Storage.DatabaseClient.ExecuteQuery(String sQuery, Int32 timeout)
at GoldTree.Communication.Messages.Messenger.AcceptBuddyMessageEvent.Handle(GameClient Session, ClientMessage Event)
at GoldTree.HabboHotel.GameClients.GameClient.ParsePacket(Byte[]& bytes)
What can i do to solve this?

[MentaL]

[Bifi2000]

Fix your database

[Andre96]

I use the same db on my pc without any problems only than on xammp and on my VPS on IIS

[NOC]

What cms are you using ?

[Andre96]

Revcms

[NOC]

Do you have strict mode mysql enabled ?

[Andre96]

Do you have strict mode mysql enabled ?

I have nothing done but maybe how could I turn it off?

[NOC]

hey

there are 2 ways,

first is query

SET @@global.sql_mode= '';

or you can

open your my.ini that is found in your mysql installation directory and look for something like this :

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

put a # in front of it, save it and restart mysql in services.

[Andre96]

hey

there are 2 ways,

first is query

SET @@global.sql_mode= '';

or you can

open your my.ini that is found in your mysql installation directory and look for something like this :

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

put a # in front of it, save it and restart mysql in services.

Thank you for the fix it works:)