Severity: Warning
Message: Undefined array key 0
Filename: controllers/Frontend.php
Line Number: 102
Backtrace:
File: /home/fixmix/public_html/service/application/controllers/Frontend.php
Line: 102
Function: _error_handler
File: /home/fixmix/public_html/service/index.php
Line: 315
Function: require_once
Severity: Warning
Message: Attempt to read property "Serv_ID" on null
Filename: controllers/Frontend.php
Line Number: 102
Backtrace:
File: /home/fixmix/public_html/service/application/controllers/Frontend.php
Line: 102
Function: _error_handler
File: /home/fixmix/public_html/service/index.php
Line: 315
Function: require_once
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/fixmix/public_html/service/system/core/Exceptions.php:271)
Filename: core/Common.php
Line Number: 570
Backtrace:
File: /home/fixmix/public_html/service/application/models/Frontend_Model.php
Line: 114
Function: query
File: /home/fixmix/public_html/service/application/controllers/Frontend.php
Line: 102
Function: getSpecificPlaceProfessionals
File: /home/fixmix/public_html/service/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 'GROUP BY Prof_ID ORDER BY `AVGRTNG` DESC, `RVWCNT` DESC' at line 8
SELECT PD.Prof_ID, PD.Name, PD.Email_ID, PD.Mobile, PD.Mobile_Alternate, PD.Address, PD.Company_Name, PD.Logo, PD.About, PD.In_Biz, PD.Visit_Charges, PS.Serv_ID, SM.Serv_Name, SM.Serv_Say, CM.Location_Name, CM.City_Name, COUNT(DISTINCT PR.PR_ID) AS RVWCNT, AVG(PR.Rating) AS AVGRTNG, SEC_TO_TIME(AVG(TIME_TO_SEC(PBH.Opening_Hour))) as OPNGHR, SEC_TO_TIME(AVG(TIME_TO_SEC(PBH.Closing_Hour))) as CLNGHR FROM Prof_Details PD LEFT JOIN Prof_Services PS ON PD.Prof_ID = PS.Prof_ID LEFT JOIN Prof_Biz_Hours PBH ON PD.Prof_ID = PBH.Prof_ID AND PBH.Is_Closed != 1 LEFT JOIN Prof_Reviews PR ON PD.Prof_ID = PR.Prof_ID LEFT JOIN Service_Master SM ON PS.Serv_ID = SM.Serv_ID LEFT JOIN City_Master CM ON PD.Location_ID = CM.Location_ID WHERE CM.Location_ID = 10 AND PS.Serv_ID = GROUP BY Prof_ID ORDER BY `AVGRTNG` DESC, `RVWCNT` DESC
Filename: models/Frontend_Model.php
Line Number: 114