BCStorm client login error

[asic]

Hi. I have got a problem with BCStorm.
When I try to enter any room with items in it, the client doesnt load the room and stay black.
This is what I get in packeterror:

Error in packet [1650] BODY: [0]?[0][0]????: 
TokenID: 0System.IndexOutOfRangeException: Cannot find column 8.
   at System.Data.DataColumnCollection.get_Item(Int32 index)
   at System.Data.DataRow.get_Item(Int32 columnIndex)
   at Butterfly.HabboHotel.Rooms.RoomItemHandling.LoadFurniture() in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\RoomItemHandling.cs:line 235
   at Butterfly.HabboHotel.Rooms.Room.Initialize(UInt32 Id, String Name, String Description, String Type, String Owner, Int32 OwnerId, Int32 Category, Int32 State, Int32 UsersMax, String ModelName, String CCTs, Int32 Score, List`1 pTags, Boolean AllowPets, Boolean AllowPetsEating, Boolean AllowWalkthrough, Boolean Hidewall, RoomIcon Icon, String Password, String Wallpaper, String Floor, String Landscape, RoomData RoomData, Boolean RightOverride, Int32 walltickness, Int32 floorthickness, Int32 groupid) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 637
   at Butterfly.HabboHotel.Rooms.Room.InitializeFromRoomData(RoomData Data) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 659
   at Butterfly.HabboHotel.Rooms.Room..ctor(RoomData Data) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 109
   at Butterfly.HabboHotel.Rooms.RoomManager.LoadRoom(UInt32 Id) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\RoomManager.cs:line 297
   at Butterfly.Messages.GameClientMessageHandler.PrepareRoomForUser(UInt32 Id, String Password) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 5442
   at Butterfly.Messages.GameClientMessageHandler.enterOnRoom() in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 1761
   at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.enterOnRoom(GameClientMessageHandler handler) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 217
   at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
   at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 3089
   at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136

I could pay for assistance, if you are interested please PM. (Paypal)
If you are a nice dude and will help without payments please respond here.

[MentaL]

[asic]

Anyone? :(

[iConnor]

I wouldnt recommend using a r63a database with a r63b as they are different builds. I think your best bet is to just a clean database.

[asic]

I wouldnt recommend using a r63a database with a r63b as they are different builds. I think your best bet is to just a clean database.

I need to save all my users.
It is a r63b database where I imported my old users, but they cant login.
New registered users on the same db can login though..

[asic]

Bump :D

[ThePhone]

I need to save all my users.
It is a r63b database where I imported my old users, but they cant login.
New registered users on the same db can login though..

What exactly do you mean? If you're switching from R63A to R63B then you HAVE to make a new database, as connor said they are 2 different builds.

[KeineChance]

clear the table "items"

[ThePhone]

clear the table "items"

How does the table " items " relate to this issue in any way shape or forum, it's a users issue, I believe it would be under the users table if any table was to be corrupted in this situation, but otherwise flash0r would need to just get a whole clean new table. You cannot convert R63A > R63B. 2 Different Builds.

:Even if you did try and emptying the items table, bcstorm has whole different structures then phoenix does. Just needed to mention that.

[asic]

What exactly do you mean? If you're switching from R63A to R63B then you HAVE to make a new database, as connor said they are 2 different builds.

Yes, the bcstorm database is new but I imported data from the phoenix r63a database.
It does work, I edited the r63a before importing. As said, it work for new users.

clear the table "items"

I can't do that since all my users' furni is in there.. :/

How does the table " items " relate to this issue in any way shape or forum, it's a users issue, I believe it would be under the users table if any table was to be corrupted in this situation, but otherwise flash0r would need to just get a whole clean new table. You cannot convert R63A > R63B. 2 Different Builds.

:Even if you did try and emptying the items table, bcstorm has whole different structures then phoenix does. Just needed to mention that.

It is a bcstorm database.
I do believe it has something with items to do since new users (with same users data as old) can play just fine

[ThePhone]

Yes, the bcstorm database is new but I imported data from the phoenix r63a database.
It does work, I edited the r63a before importing. As said, it work for new users.



I can't do that since all my users' furni is in there.. :/


It is a bcstorm database.
I do believe it has something with items to do since new users (with same users data as old) can play just fine

Empty that users table then. Make them make new accounts, all hotels have their ups and downs, and no item's are certain but in their room, yeah, it may effect their account, but not in any way of logging in, I would think entering that room would be more of an error.. Good luck otherwise.

[asic]

Empty that users table then. Make them make new accounts, all hotels have their ups and downs, and no item's are certain but in their room, yeah, it may effect their account, but not in any way of logging in, I would think entering that room would be more of an error.. Good luck otherwise.

I have over 100 000 users and I think it would be wiser to just close the hotel then haha.
Thanks.

[ThePhone]

Those " 100,000 " users, probably would re-make their account if the hotel fits there needing. Catalogue, economy, users, etc.. closing your hotel would be a stupid option if you had that many registered, haha, but only probably 10-20 of those users play, right lol..

[asic]

Those " 100,000 " users, probably would re-make their account if the hotel fits there needing. Catalogue, economy, users, etc.. closing your hotel would be a stupid option if you had that many registered, haha, but only probably 10-20 of those users play, right lol..

As of 3 months ago 13 000 of them played. :D
I fixed this error, it was a bug in the database with the items_rooms table. Now, I have another items-related problem though. Does anybody know how to fix this?

Error in packet [1650] BODY: [0]?[0][0]????: 
TokenID: 0System.IndexOutOfRangeException: Cannot find column 8.
   at System.Data.DataColumnCollection.get_Item(Int32 index)
   at System.Data.DataRow.get_Item(Int32 columnIndex)
   at Butterfly.HabboHotel.Rooms.RoomItemHandling.LoadFurniture() in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\RoomItemHandling.cs:line 235
   at Butterfly.HabboHotel.Rooms.Room.Initialize(UInt32 Id, String Name, String Description, String Type, String Owner, Int32 OwnerId, Int32 Category, Int32 State, Int32 UsersMax, String ModelName, String CCTs, Int32 Score, List`1 pTags, Boolean AllowPets, Boolean AllowPetsEating, Boolean AllowWalkthrough, Boolean Hidewall, RoomIcon Icon, String Password, String Wallpaper, String Floor, String Landscape, RoomData RoomData, Boolean RightOverride, Int32 walltickness, Int32 floorthickness, Int32 groupid) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 637
   at Butterfly.HabboHotel.Rooms.Room.InitializeFromRoomData(RoomData Data) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 659
   at Butterfly.HabboHotel.Rooms.Room..ctor(RoomData Data) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 109
   at Butterfly.HabboHotel.Rooms.RoomManager.LoadRoom(UInt32 Id) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\RoomManager.cs:line 297
   at Butterfly.Messages.GameClientMessageHandler.PrepareRoomForUser(UInt32 Id, String Password) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 5442
   at Butterfly.Messages.GameClientMessageHandler.enterOnRoom() in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 1761
   at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.enterOnRoom(GameClientMessageHandler handler) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 217
   at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
   at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 3089
   at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136

[ThePhone]

As of 3 months ago 13 000 of them played. :D
I fixed this error, it was a bug in the database with the items_rooms table. Now, I have another items-related problem though. Does anybody know how to fix this?

Error in packet [1650] BODY: [0]?[0][0]????: 
TokenID: 0System.IndexOutOfRangeException: Cannot find column 8.
   at System.Data.DataColumnCollection.get_Item(Int32 index)
   at System.Data.DataRow.get_Item(Int32 columnIndex)
   at Butterfly.HabboHotel.Rooms.RoomItemHandling.LoadFurniture() in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\RoomItemHandling.cs:line 235
   at Butterfly.HabboHotel.Rooms.Room.Initialize(UInt32 Id, String Name, String Description, String Type, String Owner, Int32 OwnerId, Int32 Category, Int32 State, Int32 UsersMax, String ModelName, String CCTs, Int32 Score, List`1 pTags, Boolean AllowPets, Boolean AllowPetsEating, Boolean AllowWalkthrough, Boolean Hidewall, RoomIcon Icon, String Password, String Wallpaper, String Floor, String Landscape, RoomData RoomData, Boolean RightOverride, Int32 walltickness, Int32 floorthickness, Int32 groupid) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 637
   at Butterfly.HabboHotel.Rooms.Room.InitializeFromRoomData(RoomData Data) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 659
   at Butterfly.HabboHotel.Rooms.Room..ctor(RoomData Data) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\Room.cs:line 109
   at Butterfly.HabboHotel.Rooms.RoomManager.LoadRoom(UInt32 Id) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\Rooms\RoomManager.cs:line 297
   at Butterfly.Messages.GameClientMessageHandler.PrepareRoomForUser(UInt32 Id, String Password) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 5442
   at Butterfly.Messages.GameClientMessageHandler.enterOnRoom() in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 1761
   at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.enterOnRoom(GameClientMessageHandler handler) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 217
   at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
   at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 3089
   at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in C:\Users\Administrator\Desktop\BCStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136

You're just making it more difficult, why not just a clean database.

[asic]

Fixed, mod can close thread. :D