room_models, inventory and catalogue

[Dan3212]

I'm currently using BrainCMS and got hotel up but a few errors have reached the surface.

Ok, error #1 = Floor plan editor, when used it displays room as black and this error displays on emu:

Date/Time: 2017-05-06 17:05:58,240
Thread: 35
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

That's all that pops up for that one.


now I have errors when buying FURNI from catalogue and loading my inventory; fix?

 

[Joe]

Field 'public_items' doesn't have a default value - there's your issue.

Also, when you buy furniture what actually happens? Have you recently updated your SWF's?

 

[Dan3212]

Field 'public_items' doesn't have a default value - there's your issue.

Also, when you buy furniture what actually happens? Have you recently updated your SWF's?

ive just set it up, PRODUCTION-201701242205-837386173

when i buy furni it just dc's me and directs me to /me

 

[Joe]

ive just set it up, PRODUCTION-201701242205-837386173

when i buy furni it just dc's me and directs me to /me

Is there any logs in the emulator/error log files?

 

[Dan3212]

Is there any logs in the emulator/error log files?

yes what I posted
 
this

Date/Time: 2017-05-06 17:05:15,084
Thread: 32
Exception:
System.NullReferenceException: Object reference not set to an instance of an object.
at Plus.HabboHotel.Rooms.Gamemap.GenerateMaps(Boolean checkLines) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\GameMap.cs:line 223
at Plus.HabboHotel.Rooms.Room..ctor(RoomData Data) in C:\Users\Sledmore\Desktop\PlusEMU\HabboHotel\Rooms\Room.cs:line 162
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

 

[Joe]

Use these SWF's

You must be registered for see links

Use Build 1

You must be registered for see links

 

[Dan3212]

Use these SWF's

You must be registered for see links

Use Build 1

You must be registered for see links

Ill give it a try and i'll let you know how it goes.

 

[Joe]

Ill give it a try and i'll let you know how it goes.

Remember to set MySQL mode to not strict.

 

[Brad]

Either run this

SET @@global.sql_mode= '';

or disable strict mode by going to your my.ini, then find this

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Replace with this

sql_mode=""

Then restart your MySQL service.

 

[Dan3212]

Either run this

SET @@global.sql_mode= '';

or disable strict mode by going to your my.ini, then find this

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Replace with this

sql_mode=""

Then restart your MySQL service.

Works just fine, thank you.