A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/Search.php

Line Number: 162

Backtrace:

File: /home/jolpie6/public_html/application/modules/search/controllers/Search.php
Line: 162
Function: _error_handler

File: /home/jolpie6/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/Search.php

Line Number: 181

Backtrace:

File: /home/jolpie6/public_html/application/modules/search/controllers/Search.php
Line: 181
Function: _error_handler

File: /home/jolpie6/public_html/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/jolpie6/public_html/system/core/Exceptions.php:271)

Filename: core/Common.php

Line Number: 564

Backtrace:

File: /home/jolpie6/public_html/application/modules/search/models/Search_model.php
Line: 115
Function: get

File: /home/jolpie6/public_html/application/modules/search/controllers/Search.php
Line: 182
Function: get_consult_doctor_category

File: /home/jolpie6/public_html/index.php
Line: 315
Function: require_once

Database Error

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY `doctor_package`.`doctor_id` LIMIT 20' at line 7

SELECT `reg`.`name`, `reg`.`profile_image`, `login`.`id` as `main_id`, `reg`.`name` as `doc_name`, `reg`.`avg_review` as `doc_review`, `doctor_details`.`specialist`, `login`.`username`, `doctor_designation_list`.`designation_name` FROM `doctor_package` JOIN `login` ON `login`.`id`=`doctor_package`.`doctor_id` JOIN `registration` `reg` ON `reg`.`login_id`=`login`.`id` LEFT JOIN `doctor_details` ON `doctor_details`.`doctor_id`=`login`.`id` LEFT JOIN `doctor_designation_list` ON `doctor_designation_list`.`id`=`doctor_details`.`designation` WHERE ((login.user_type = 3 OR `login`.`user_type` = 4 OR `login`.`user_type` = 5 OR `login`.`user_type` = 6 OR `login`.`user_type` = 7) AND `login`.`verify_status` = 1 AND `reg`.`is_subscribe` = 1 AND `doctor_package`.`status` = 1 AND `doctor_package`.`package_type` =0 AND `doctor_package`.`package_cat_id` =) GROUP BY `doctor_package`.`doctor_id` LIMIT 20

Filename: modules/search/models/Search_model.php

Line Number: 115