classroombooking software - error accessing booking view

[aidwiz]

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.

[webman]

Hi aidwiz, classroombookings author here!

 

It looks like you might be running MySQL 8, which introduces stricter requirements on certain database queries.

 

You can either modify your MySQL server settings to disable the "ONLY_FULL_GROUP_BY" option (docs here) or you can modify the classroombookings code to change the query.

 

If you want to change the classroombookings code, edit application/models/Dates_model.php, and make Line 93 look like this:

 

$this->db->select('MAX(pc.period_count) AS period_count', FALSE);

 

Hopefully that works!

 

Craig.

[aidwiz]

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