GTE Emulator Exception error [ PHX ]

11/17/2014 8:19:25 PM: 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) in c:\Users\Jack\Desktop\GTE 3\Gold Tree Emulator 3.0\Storage\DatabaseClient.cs:line 33
at GoldTree.Communication.Messages.Messenger.AcceptBuddyMessageEvent.Handle(GameClient Session, ClientMessage Event) in c:\Users\gageyragey\Desktop\GTE 3\Gold Tree Emulator 3.0\Communication\Messages\Messenger\AcceptBuddyMessageEvent.cs:line 43
at GoldTree.HabboHotel.GameClients.GameClient.ParsePacket(Byte[]& bytes) in c:\Users\gageyragey\Desktop\GTE 3\Gold Tree Emulator 3.0\HabboHotel\GameClients\GameClient.cs:line 577

I use illumina CMS and use gte and when I have friendstream enabled for user I get this.

It's something to-do with the gender column on your users table.... as the error clearly shows. Either get another database or use a different CMS, it's obvious it doesn't match up.

Actually it's to do with truncated data. You just need to turn strict (innoDB) mode off on your database then reimport your database, and it shouldn't occur after such.

Quote:

---

Originally Posted by Terrum

Actually it's to do with truncated data. You just need to turn strict (innoDB) mode off on your database then reimport your database, and it shouldn't occur after such.

---

That's just disabling the errors from showing, it isn't really 'fixing' his problem isit.

It actually disables the feature, not just the errors. Disabling InnoDB will stop truncation.