aidwiz

hi, tried to google to no avail. for MRBS software, how do you prevent users from booking on the same day he / she wants to use the room? for example: Susan wants to use Room001 on Thursday; therefore so she must book the room before Thursday (24 hours before). is this possible with MRBS? thanks in advance.

i changed the settings in mysql as instructed above and it works. thanks craig!

hi, i passed all the software requirements, can access and setup all the settings inside classrooombooking software. the problem is that i have an error 500 page when clicking on the "Booking" software. (it shows a blank page). increase the error levels to obtain the following errors. ----------------------------------------------------------- ERROR - 2023-08-09 10:17:42 --> Query error: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pc.period_count' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT `dates`.*, pc.period_count AS period_countFROM `dates`LEFT JOIN (SELECT `weekday`, (IF(period_count IS NULL, 0, period_count)) AS period_count FROM (SELECT 1 AS weekday, SUM(IF(period_id IS NULL, 0, 1)) AS period_count FROM periods WHERE day_1 = 1 ----------------------------------------------------------- please advise. thanks.