Catalogue Error

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

This is the saved exception:

Code:

---

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.

I think there are still some rows with an empty height_adjustable

Quote:

---

Originally Posted by Disguised

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

This is the saved exception:

Code:

---

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

Quote:

---

Originally Posted by Vaulient

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

---

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

Quote:

---

Originally Posted by Disguised

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.

Quote:

---

Originally Posted by Vaulient

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.

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

UPDATE furniture SET height_adjustable = 0;