BrainCMS 1.8 - PlusEmu - Room Settings Error

U

uttmmmm5

Member
May 18, 2016
110
5
Hey there,
I use the BrainCMS v1.8 with the Plus Emulator.
I have one fatal error at all.
If I create a room, restarting the emulator and go back to the client - everything is well.
BUT....
If I create a room, change one or more things in the room settings, restarting the emulator and go back to the client a error pop up at the Emu and I stuck at 76%...
And now - if another user search for this room on the navigator then the navigator loads unlimited and don't show any rooms.
the problem can only be fixed if i delete the room with the changed room settings in my database and restart the emulator.

This error is showing up if I try go back in the client after restarting emulator:

System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.Convert.ToInt32(String value)
at Plus.HabboHotel.Rooms.RoomData.Fill(DataRow Row) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\RoomData.cs:line 87
at Plus.HabboHotel.Rooms.RoomManager.FetchRoomData(Int32 RoomId, DataRow dRow) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\RoomManager.cs:line 400
at Plus.HabboHotel.Users.UserData.UserDataFactory.GetUserData(String SessionTicket, Byte& errorCode) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Users\UserData\UserDataFactory.cs:line 158
at Plus.HabboHotel.GameClients.GameClient.TryAuthenticate(String AuthTicket) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\GameClients\GameClient.cs:line 100


and this error is showing up if another user try to search this room in the navigator:

System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.Convert.ToInt32(String value)
at Plus.HabboHotel.Rooms.RoomData.Fill(DataRow Row) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\RoomData.cs:line 87
at Plus.HabboHotel.Rooms.RoomManager.FetchRoomData(Int32 RoomId, DataRow dRow) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\RoomManager.cs:line 400
at Plus.HabboHotel.Navigator.NavigatorHandler.Search(ServerPacket Message, SearchResultList SearchResult, String SearchData, GameClient Session, Int32 FetchLimit) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Navigator\NavigatorHandler.cs:line 107
at Plus.Communication.Packets.Outgoing.Navigator.New.NavigatorSearchResultSetComposer..ctor(String Category, String Data, ICollection`1 SearchResultLists, GameClient Session, Int32 GoBack, Int32 FetchLimit) in C:\Users\Sledmore\Desktop\PlusEMU\Communication\Packets\Outgoing\Navigator\New\NavigatorSearchResultSetComposer.cs:line 25
at Plus.Communication.Packets.Incoming.Navigator.NavigatorSearchEvent.Parse(GameClient session, ClientPacket packet) in C:\Users\Sledmore\Desktop\PlusEMU\Communication\Packets\Incoming\Navigator\NavigatorSearchEvent.cs:line 39
at Plus.Communication.Packets.PacketManager.TryExecutePacket(GameClient Session, ClientPacket Packet) in C:\Users\Sledmore\Desktop\PlusEMU\Communication\Packets\PacketManager.cs:line 154
at Plus.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientPacket Message) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\GameClients\GameClient.cs:line 65



Can someone tell me how i can fix this issue ?
 
Sort by date Sort by votes
U

uttmmmm5

Member
May 18, 2016
110
5
JynX said:
Could you maybe tell us what's on line 25 of NavigatorSearchResultSetComposer?
Click to expand...
NavigatorHandler.Search(this, SearchResult, Data, Session, FetchLimit);

Berk said:
Change your decimal to a dot and refer to
You must be registered for see links
.
Click to expand...
You must be registered for see links
-
You must be registered for see links

I tried this already , i get the same error.
 
EDIT: After I restart my Windows-Server it seems that everything is working perfect BUT THEN i saw another error in the Emulator which is the reason why I can go in the client after I change the Room Settings ... The Room Settings do not update now!

Code: 
Error in query:
UPDATE `rooms` SET `caption` = @caption, `description` = @description, `password` = @password, `category` = @categoryId, `state` = @state, `tags` = @tags, `users_max` = @maxUsers, `allow_pets` = @allowPets, `allow_pets_eat` = @allowPetsEat, `room_blocking_disabled` = @roomBlockingDisabled, `allow_hidewall` = @allowHidewall, `floorthick` = @floorThick, `wallthick` = @wallThick, `mute_settings` = @muteSettings, `kick_settings` = @kickSettings, `ban_settings` = @banSettings, `chat_mode` = @chatMode, `chat_size` = @chatSize, `chat_speed` = @chatSpeed, `chat_extra_flood` = @extraFlood, `chat_hearing_distance` = @chatDistance, `trade_settings` = @tradeSettings WHERE `id` = @roomId LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'allow_pets' 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Sledmore\Desktop\PlusEMU\Database\Adapter\QueryAdapter.cs:line 167

Any Ideas ? :)
I think that this error comes because i change the internet time from "time.windows.com" to "time.nist.gov" but how i can fix this "Error in query" ?
 
Upvote 0 Downvote
B

Berk

berkibap#4233
Developer
Oct 17, 2015
863
190
uttmmmm5 said:
NavigatorHandler.Search(this, SearchResult, Data, Session, FetchLimit);


You must be registered for see links
-
You must be registered for see links

I tried this already , i get the same error.
 
EDIT: After I restart my Windows-Server it seems that everything is working perfect BUT THEN i saw another error in the Emulator which is the reason why I can go in the client after I change the Room Settings ... The Room Settings do not update now!

Code: 
Error in query:
UPDATE `rooms` SET `caption` = @caption, `description` = @description, `password` = @password, `category` = @categoryId, `state` = @state, `tags` = @tags, `users_max` = @maxUsers, `allow_pets` = @allowPets, `allow_pets_eat` = @allowPetsEat, `room_blocking_disabled` = @roomBlockingDisabled, `allow_hidewall` = @allowHidewall, `floorthick` = @floorThick, `wallthick` = @wallThick, `mute_settings` = @muteSettings, `kick_settings` = @kickSettings, `ban_settings` = @banSettings, `chat_mode` = @chatMode, `chat_size` = @chatSize, `chat_speed` = @chatSpeed, `chat_extra_flood` = @extraFlood, `chat_hearing_distance` = @chatDistance, `trade_settings` = @tradeSettings WHERE `id` = @roomId LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'allow_pets' 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Sledmore\Desktop\PlusEMU\Database\Adapter\QueryAdapter.cs:line 167

Any Ideas ? :)
I think that this error comes because i change the internet time from "time.windows.com" to "time.nist.gov" but how i can fix this "Error in query" ?
Click to expand...
It's not because of time.nist.gov. It's about your rooms table.
Change allow_pets to variable 255 amd if you get another again, do it for the given column in error. (hoping that makes sense )
 
Upvote 0 Downvote
U

uttmmmm5

Member
May 18, 2016
110
5
Berk said:
It's not because of time.nist.gov. It's about your rooms table.
Change allow_pets to variable 255 amd if you get another again, do it for the given column in error. (hoping that makes sense )
Click to expand...

Ok wait, i don't know what you exactly mean.
Here are screenshots of the full "rooms-table"
Can you exactly tell me what i must change ?

You must be registered for see links
-
You must be registered for see links



PS: And if i type in this query: SET @@global.sql_mode = ''; - then i got the same error like before (at the beginning)
 
Upvote 0 Downvote
B

Berk

berkibap#4233
Developer
Oct 17, 2015
863
190
uttmmmm5 said:
Ok wait, i don't know what you exactly mean.
Here are screenshots of the full "rooms-table"
Can you exactly tell me what i must change ?

You must be registered for see links
-
You must be registered for see links



PS: And if i type in this query: SET @@global.sql_mode = ''; - then i got the same error like before (at the beginning)
Click to expand...
You need to change allow_pets enum to varchar 255
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top