PLUS Emu | Error after changes

[Heisann]

So, I've been stupid and making a lot of changes without saving or taking backups lately. Some of them being editing text in the catalogue (in MySQL), editing some of the flash_texts, adding a badge.
I also did

You must be registered for see links

, to try to fix the Wired. That is the last ting I did before I restarted the Emulator, and thats when the problem appeared.

The error comes up when I'm loading the client, which stops at 76%.

Spoiler: Screenshot EMU

You must be registered for see images attach

I'm just checking to see if anyone has a fix to this, before I'm replacing the whole database.

 

[Pollak]

Send print of the code RoomData line 87

 

[Heisann]

Send print of the code RoomData line 87

Sure. The code is unchanged, though.


Line 87:

            AllowPets = Convert.ToInt32(Row["allow_pets"].ToString());

This is line 79-103 if needed.

            if (!string.IsNullOrEmpty(Row["users_now"].ToString()))
                UsersNow = Convert.ToInt32(Row["users_now"]);
            else
                UsersNow = 0;
            UsersMax = Convert.ToInt32(Row["users_max"]);
            ModelName = Convert.ToString(Row["model_name"]);
            Score = Convert.ToInt32(Row["score"]);
            Tags = new List<string>();
            AllowPets = Convert.ToInt32(Row["allow_pets"].ToString());
            AllowPetsEating = Convert.ToInt32(Row["allow_pets_eat"].ToString());
            RoomBlockingEnabled = Convert.ToInt32(Row["room_blocking_disabled"].ToString());
            Hidewall = Convert.ToInt32(Row["allow_hidewall"].ToString());
            Password = Convert.ToString(Row["password"]);
            Wallpaper = Convert.ToString(Row["wallpaper"]);
            Floor = Convert.ToString(Row["floor"]);
            Landscape = Convert.ToString(Row["landscape"]);
            FloorThickness = Convert.ToInt32(Row["floorthick"]);
            WallThickness = Convert.ToInt32(Row["wallthick"]);
            WhoCanMute = Convert.ToInt32(Row["mute_settings"]);
            WhoCanKick = Convert.ToInt32(Row["kick_settings"]);
            WhoCanBan = Convert.ToInt32(Row["ban_settings"]);
            chatMode = Convert.ToInt32(Row["chat_mode"]);
            chatSpeed = Convert.ToInt32(Row["chat_speed"]);
            chatSize = Convert.ToInt32(Row["chat_size"]);
            TradeSettings = Convert.ToInt32(Row["trade_settings"]);

Heres line 150-151 of UserDataFactory.cs

                    if (!requests.ContainsKey(senderID))
                        requests.Add(senderID, new MessengerRequest(UserId, senderID, requestUsername));

 

[Pollak]

Open database, table rooms and search allow_pets and send print the config

 

[Heisann]

No results on allow_pets. There's only one room in the database, and the field "allow_pets" is blank on that one.

 Showing rows 0 -  0 (1 total, Query took 0.0006 seconds.)

SELECT * FROM `rooms`



1    public    Infobussen    1        36    open    0    50    model_bus    0            0.0    0.0    0.0                    0    0    0                0    0    0    0    0    2    1    1    1    1    1    1    1

 

[Pollak]

No results on allow_pets. There's only one room in the database, and the field "allow_pets" is blank on that one.

Showing rows 0 -  0 (1 total, Query took 0.0006 seconds.)

SELECT * FROM `rooms`



1    public    Infobussen    1        36    open    0    50    model_bus    0            0.0    0.0    0.0                    0    0    0                0    0    0    0    0    2    1    1    1    1    1    1    1

You must be registered for see images attach

Send me print like this

 

[Heisann]

Send me print like this

You must be registered for see images attach

 

[Pollak]

You must be registered for see images attach

Its ok, i just can see the error in team viewer but njow im busy :/

 

[Heisann]

Its ok, i just can see the error in team viewer but njow im busy :/

Thanks, feel free to add my Disc if you'd ever feel to help further
Xx#1088

 

[JayC]

Option 1:
Press the Windows button
Type Region & Language settings
Press the option under "Related Settings" (Additional date, time & regional settings)
Press Region
Additional settings
and replace the comma with a period

Option 2:

ALTER TABLE `rooms` CHANGE `allow_pets` `allow_pets` INT(1) NOT NULL DEFAULT '0', CHANGE `allow_pets_eat` `allow_pets_eat` INT(1) NOT NULL DEFAULT '0', CHANGE `room_blocking_disabled` `room_blocking_disabled` INT(1) NOT NULL DEFAULT '0', CHANGE `allow_hidewall` `allow_hidewall` INT(1) NOT NULL DEFAULT '0', CHANGE `mute_settings` `mute_settings` INT(1) NOT NULL DEFAULT '1', CHANGE `ban_settings` `ban_settings` INT(1) NOT NULL DEFAULT '1', CHANGE `kick_settings` `kick_settings` INT(1) NOT NULL DEFAULT '1';

 

[Heisann]

Option 1:
Press the Windows button
Type Region & Language settings
Press the option under "Related Settings" (Additional date, time & regional settings)
Press Region
Additional settings
and replace the comma with a period

Option 2:

ALTER TABLE `rooms` CHANGE `allow_pets` `allow_pets` INT(1) NOT NULL DEFAULT '0', CHANGE `allow_pets_eat` `allow_pets_eat` INT(1) NOT NULL DEFAULT '0', CHANGE `room_blocking_disabled` `room_blocking_disabled` INT(1) NOT NULL DEFAULT '0', CHANGE `allow_hidewall` `allow_hidewall` INT(1) NOT NULL DEFAULT '0', CHANGE `mute_settings` `mute_settings` INT(1) NOT NULL DEFAULT '1', CHANGE `ban_settings` `ban_settings` INT(1) NOT NULL DEFAULT '1', CHANGE `kick_settings` `kick_settings` INT(1) NOT NULL DEFAULT '1';

Thanks alot man! Fixed it!

 

[JayC]

Thanks alot man! Fixed it!

No problem mark the post as best answer

 

[Joe]

The error has been posted at least a hundred times before, thanks for the answer again @JayCustom