A PHP Error was encountered

Severity: Notice

Message: Undefined index: department_id

Filename: models/event_model.php

Line Number: 180

A PHP Error was encountered

Severity: Notice

Message: Undefined index: event_id

Filename: models/event_model.php

Line Number: 181

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/u/u5889739/www/system/libraries/Exceptions.php:166)

Filename: codeigniter/Common.php

Line Number: 356

Ett databasfel inträffade

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY `e`.`event_id` ORDER BY `s`.`show_date` desc' at line 6

SELECT *, COUNT(s.show_id) AS num_shows FROM (`events` e) JOIN `shows` s ON `s`.`show_event_id` = `e`.`event_id` WHERE `e`.`event_department_id` IS NULL AND `e`.`event_id` != GROUP BY `e`.`event_id` ORDER BY `s`.`show_date` desc