Severity: Notice
Message: Undefined index: q
Filename: controllers/Home.php
Line Number: 23
Backtrace:
File: /home/dougca/public_html/application/modules/projects/controllers/Home.php
Line: 23
Function: _error_handler
File: /home/dougca/public_html/index.php
Line: 315
Function: require_once
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/dougca/public_html/system/core/Exceptions.php:271)
Filename: core/Common.php
Line Number: 564
Backtrace:
File: /home/dougca/public_html/application/modules/projects/models/Projects_m.php
Line: 56
Function: get
File: /home/dougca/public_html/application/modules/projects/controllers/Home.php
Line: 25
Function: search_projects
File: /home/dougca/public_html/index.php
Line: 315
Function: require_once
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 '.`id`, `projects`.`date_completed`, `projects`.`science_contribution`, `projects' at line 1
SELECT `project_sliders`.`project_id`, MIN(project_sliders.image_id) as image_id, MAX(project_slide_images.file_name) as file_name, `-- Aggregating file_name` `projects`.`id`, `projects`.`date_completed`, `projects`.`science_contribution`, `projects`.`es_title` as `title`, `projects`.`es_description` as `description` FROM `project_sliders` JOIN `project_slide_images` ON `project_sliders`.`image_id` = `project_slide_images`.`id` JOIN `projects` ON `project_sliders`.`project_id` = `projects`.`id` WHERE `projects`.`es_title` LIKE '%%' ESCAPE '!' OR `projects`.`es_description` LIKE '%%' ESCAPE '!' OR `projects`.`es_title` LIKE '%%' ESCAPE '!' OR `projects`.`es_description` LIKE '%%' ESCAPE '!' GROUP BY `project_sliders`.`project_id`, `projects`.`id`, `projects`.`date_completed`, `projects`.`science_contribution`, `projects`.`es_title`, `projects`.`es_description` ORDER BY `projects`.`date_completed` DESC
Filename: modules/projects/models/Projects_m.php
Line Number: 56