PlusEmu R2 Error In Query

Status
Not open for further replies.

RussianRoman

Member
Feb 19, 2017
44
10
Hey everyone.

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

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

?
Nov 10, 2017
430
352
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
 
Last edited:

RussianRoman

Member
Feb 19, 2017
44
10
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.
 
Status
Not open for further replies.

Users who are viewing this thread

Top