jberanek
commented
3 years ago It seems there may be a possible bug in MBRS. If I look in the DB table mrbs_room for the rooms that created the error, the column invalid_types contains the word 'null' instead of the null value. I changed the value of the field to the null value with the commands below and suddenly it works again.
UPDATE `mrbs`.`mrbs_room` SET `invalid_types` = NULL WHERE (`id` = '9');
UPDATE `mrbs`.`mrbs_room` SET `invalid_types` = NULL WHERE (`id` = '10');I am able to reproduce this behavior. When you create a room, the null value is inserted in the column. If later you update the room, the word null is entered instead of the null value.
In my configuration, I have the following settings related to this field:
unset($booking_types);
$prevent_invalid_types = true;Original comment by: stevekiss
Hi all,
MRBS suddenly stopped working this morning. Yesterday, I created a new area and added several rooms to it. It seemed to work fine. Today, I am not able to access the site. Below is the error log:
[Thu Dec 17 11:38:32.081213 2020] [:error] [pid 23028] [client 172.16.68.50:51142] \nE_WARNING in /var/www/mrbs/html/edit_room_handler.php at line 110\narray_intersect(): Argument #2 is not an array\nMRBS GET: Array\n(\n)\nMRBS POST: Array\n(\n [csrf_token] => 2b08ac8629ef3fed1c6fc1cf237af328781866b50e3faf1e0d314b12e27567b5\n [room] => 9\n [old_area] => 3\n [old_room_name] => Implant motors\n [new_area] => 3\n [room_name] => Implant motors\n [sort_key] => Implant motors\n [room_disabled] => 0\n [description] => \n [capacity] => 0\n [room_admin_email] => stevek@test.com\n)\nMRBS SESSION: Array\n(\n [csrf_token] => 2b08ac8629ef3fed1c6fc1cf237af328781866b50e3faf1e0d314b12e27567b5\n [user] => MRBS\User Object\n (\n [username] => stevek\n [display_name] => Steve Kiss\n [email] => stevek@test.com\n [level] => 2\n )\n\n)\n\n, referer: http://mrbs.test.com/edit_room.php?room=9 [Thu Dec 17 11:39:06.182532 2020] [:error] [pid 22464] [client 172.16.68.50:51163] \nE_WARNING in /var/www/mrbs/html/edit_room_handler.php at line 110\narray_intersect(): Argument #2 is not an array\nMRBS GET: Array\n(\n)\nMRBS POST: Array\n(\n [csrf_token] => 2b08ac8629ef3fed1c6fc1cf237af328781866b50e3faf1e0d314b12e27567b5\n [room] => 10\n [old_area] => 3\n [old_room_name] => Piezo machine\n [new_area] => 3\n [room_name] => Piezo machine\n [sort_key] => Piezo machine\n [room_disabled] => 0\n [description] => \n [capacity] => 0\n [room_admin_email] => stevek@test.com\n)\nMRBS SESSION: Array\n(\n [csrf_token] => 2b08ac8629ef3fed1c6fc1cf237af328781866b50e3faf1e0d314b12e27567b5\n [user] => MRBS\User Object\n (\n [username] => stevek\n [display_name] => Steve Kiss\n [email] => stevek@test.com\n [level] => 2\n )\n\n)\n\n, referer: http://mrbs.test.com/edit_room.php?room=10
Can anyone advise please?
Thank you.
Reported by: stevekiss
Original Ticket: mrbs/support-requests/2264