Ads_background error | Sledmore PlusEMU

[Woiah]

Hello! When im importing a new floor plan the room just shows black and this shows up in the emulator?

2017-07-27 16:31:42,378 ERROR - MySQL >> Error in query:
INSERT INTO `room_models` (`id`,`door_x`,`door_y`, `door_z`, `door_dir`,`heightmap`,`custom`,`wall_height`) VALUES (@ModelName, @DoorX, @DoorY, @DoorZ, @DoorDirection, @Map,'1',@WallHeight)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'public_items' 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Sledmore\Desktop\PlusEMU\Database\Adapter\QueryAdapter.cs:line 167


2017-07-27 16:31:42,611 ERROR - Exception >> Exception:
System.NullReferenceException: Object reference not set to an instance of an object.
   at Plus.HabboHotel.Rooms.Gamemap.ValidTile(Int32 X, Int32 Y) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\GameMap.cs:line 1262
   at Plus.HabboHotel.Rooms.RoomItemHandling.LoadFurniture() in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\RoomItemHandling.cs:line 155
   at Plus.HabboHotel.Rooms.Room..ctor(RoomData Data) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\Room.cs:line 161
   at Plus.HabboHotel.Rooms.RoomManager.LoadRoom(Int32 Id) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\RoomManager.cs:line 419
   at Plus.HabboHotel.Users.Habbo.PrepareRoom(Int32 Id, String Password) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Users\Habbo.cs:line 1175
   at Plus.Communication.Packets.Incoming.Rooms.Connection.OpenFlatConnectionEvent.Parse(GameClient Session, ClientPacket Packet) in C:\Users\Sledmore\Desktop\PlusEMU\Communication\Packets\Incoming\Rooms\Connection\OpenFlatConnectionEvent.cs:line 18
   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

 

[Central]

Try disabling the MySQL Strict Mode Permanently instead of doing it through Navicat where you will have to re-do it once MySQL is restarted (or if VPS was restarted).

Step 1: Go to C Drive, Program Files (Not Program Files x86), enter MySQL folder, then MySQL Server 5.5 (or whatever version) and there you see a file named my.ini enter it and change the following:

# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

to

# Set the SQL mode to strict
sql-mode=""

You're not finished yet. Save the document before you do this next step.

Click Start and right click "Command Prompt" and click "Open as Administrator", type the following into the cmd

net stop MySQL

Once stopped, you'll have to start it, so type this:

net start MySQL

There you go.

 

[Woiah]

After i run the CMD command this shows up "The service name is invalid"

 

[Joe]

Pretty sure it's MySQL strict mode, but the actual error is public_items doesn't have a default value.

Edited: Just restart the service in your Task Manager or restart the VPS (should restart it).

 

[Woiah]

Pretty sure it's MySQL strict mode, but the actual error is public_items doesn't have a default value.

Edited: Just restart the service in your Task Manager or restart the VPS (should restart it).

Fixed the error! But the ads_background doesnt work! I pasted the correct path to the image but nothing is showing?

 

[Central]

Fixed the error! But the ads_background doesnt work! I pasted the correct path to the image but nothing is showing?

The path can only be the files that you host on server, and has to be saved on server.

If you saved an image named "test.png" in the c_images folder, then you type this in the image url on the background: /swf/c_images/test.png

If you had it has /test.png it means that it's in the same directory as the .htaccess or your web.config, in the wwwroot folder. anything from / is your whole directory listing, so /foldername/ and so many folders until you hit the actual directory where your image lies and there you type the image name and type so /app/tpl/skins/Habbo/images/logo.png

 

[Woiah]

I saw somewhere that the url must be https because the latest habbo.swf is SSL?

 

[Central]

No. you do not include your domain in it

 

[Woiah]

No. you do not include your domain in it

Works now! Thanks!