PlusEmu R2 Error In Query

[RussianRoman]

Hey everyone.

I tried to look for an answer with previous errors but I can't find this specific one:

It's something to do with room settings, right? The thing is I'm not sure what it's causing though. Everything in the game seems to be working, but this is throwing me off.

Any ideas,
Roman

 

[Object]

Have you tried this query

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';

You might also want to disable strict mode by running this
(temporarily)
SET @@global.sql_mode= '';

or disable it permanently by editing your conf

 

[RussianRoman]

Have you tried this query

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';

You might also want to disable strict mode by running this
(temporarily)
SET @@global.sql_mode= '';

or disable it permanently by editing your conf

That query seems to have done the trick.

Thank you so much for your quick response time.