Catalogue Error

[Disguised]

Hi, i have recently changed my catalogue & when i buy furni from it i get disconnected.

This is the saved exception:

8/26/2015 7:59:08 AM: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'height_adjustable' doesn't have a default value
   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 d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\Storage\DatabaseClient.cs:line 33
   at GoldTree.HabboHotel.Users.Inventory.InventoryComponent.method_11(UInt32 uint_1, UInt32 uint_2, String string_0, Boolean bool_0) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\HabboHotel\Users\Inventory\InventoryComponent.cs:line 296
   at GoldTree.HabboHotel.Catalogs.Catalog.method_9(GameClient Session, Item Item, Int32 int_0, String string_0, Boolean bool_0, UInt32 uint_1) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\HabboHotel\Catalogs\Catalog.cs:line 615
   at GoldTree.HabboHotel.Catalogs.Catalog.method_6(GameClient Session, Int32 int_0, UInt32 uint_1, String string_0, Boolean bool_0, String string_1, String string_2, Boolean bool_1) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\HabboHotel\Catalogs\Catalog.cs:line 446
   at GoldTree.Communication.Messages.Catalog.PurchaseFromCatalogEvent.Handle(GameClient Session, ClientMessage Event) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\Communication\Messages\Catalog\PurchaseFromCatalogEvent.cs:line 30
   at GoldTree.HabboHotel.GameClients.GameClient.ParsePacket(Byte[]& bytes) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\HabboHotel\GameClients\GameClient.cs:line 577

Before you say give height_adjustable a default value, trust me i have & it still did not work.

Please Help.

Thanks.

[MentaL]

[Boraida]

I think there are still some rows with an empty height_adjustable

[Vaulient]

Hi, i have recently changed my catalogue & when i buy furni from it i get disconnected.

This is the saved exception:

8/26/2015 7:59:08 AM: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'height_adjustable' doesn't have a default value
   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 d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\Storage\DatabaseClient.cs:line 33
   at GoldTree.HabboHotel.Users.Inventory.InventoryComponent.method_11(UInt32 uint_1, UInt32 uint_2, String string_0, Boolean bool_0) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\HabboHotel\Users\Inventory\InventoryComponent.cs:line 296
   at GoldTree.HabboHotel.Catalogs.Catalog.method_9(GameClient Session, Item Item, Int32 int_0, String string_0, Boolean bool_0, UInt32 uint_1) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\HabboHotel\Catalogs\Catalog.cs:line 615
   at GoldTree.HabboHotel.Catalogs.Catalog.method_6(GameClient Session, Int32 int_0, UInt32 uint_1, String string_0, Boolean bool_0, String string_1, String string_2, Boolean bool_1) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\HabboHotel\Catalogs\Catalog.cs:line 446
   at GoldTree.Communication.Messages.Catalog.PurchaseFromCatalogEvent.Handle(GameClient Session, ClientMessage Event) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\Communication\Messages\Catalog\PurchaseFromCatalogEvent.cs:line 30
   at GoldTree.HabboHotel.GameClients.GameClient.ParsePacket(Byte[]& bytes) in d:\Game\ZrQ\project 1\ZRQ EMU\Gold Tree Emulator 3.0\HabboHotel\GameClients\GameClient.cs:line 577

Before you say give height_adjustable a default value, trust me i have & it still did not work.

Please Help.

Thanks.

lol , search height-adjustable in your table, and set it to null

[Disguised]

lol , search height-adjustable in your table, and set it to null

I have also tried that before posting, it did not work.

[Vaulient]

I have also tried that before posting, it did not work.

Are you sure? can you check again if it's ticked to null? try restarting your emulator after that.

[Disguised]

Are you sure? can you check again if it's ticked to null? try restarting your emulator after that.

I have checked & it is NULL but now i am getting another error it says something like, the string may only be one character long?

I am about to go to bed, i will get back to you tommorow.

[NOC]

Set the default to 0 the height_adjustable field via design view of your furniture table

UPDATE furniture SET height_adjustable = 0;