Catalogue Error

Results 1 to 7 of 7
  1. #1
    lol Disguised is offline
    Grand MasterRank
    Jan 2011 Join Date
    521Posts

    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.


  2. #2
    Elite Member Boraida is offline
    Member +Rank
    May 2011 Join Date
    The NetherlandsLocation
    161Posts

    Re: Catalogue Error

    I think there are still some rows with an empty height_adjustable

  3. #3
    Loyalty Vaulient is offline
    Grand MasterRank
    May 2012 Join Date
    MalaysiaLocation
    1,796Posts

    Re: Catalogue Error

    Quote Originally Posted by Disguised View Post
    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

  4. #4
    lol Disguised is offline
    Grand MasterRank
    Jan 2011 Join Date
    521Posts

    Re: Catalogue Error

    Quote Originally Posted by Vaulient View Post
    lol , search height-adjustable in your table, and set it to null
    I have also tried that before posting, it did not work.

  5. #5
    Loyalty Vaulient is offline
    Grand MasterRank
    May 2012 Join Date
    MalaysiaLocation
    1,796Posts

    Re: Catalogue Error

    Quote Originally Posted by Disguised View Post
    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.

  6. #6
    lol Disguised is offline
    Grand MasterRank
    Jan 2011 Join Date
    521Posts

    Re: Catalogue Error

    Quote Originally Posted by Vaulient View Post
    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.

  7. #7
    Mr VPS - Cheap VPS Server NOC is offline
    Grand MasterRank
    Sep 2011 Join Date
    Liverpool, UKLocation
    844Posts

    Re: Catalogue Error

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

    UPDATE furniture SET height_adjustable = 0;



Advertisement