500 Error

Datasource: oilcitydb2013

SQL: Select D.Business_Id,COALESCE(T.Business_Category_Name,'z') Category_Name,T.Business_Category_Id,D.Business_Name,D.Business_Address,D.Business_Address2,D.Business_City,D.Business_State,D.Business_Zip,D.Business_Phone,D.Business_Url from Business_Directory D inner join Business_Category_to_Directory C on D.Business_Id=C.Business_Id left join Business_Category T on C.Business_Sub_Category_Id=T.Business_Category_Id where Left(D.Business_Name,1)='W' group by D.Business_Id order by COALESCE(T.Business_Category_Name,'z')

Code: 0

Type: 0

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Oil_City_Main_Street.T.Business_Category_Name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

---

Column: 0
ID: ??
Line: 110
Raw Trace: org.lucee.cfml.base_cfc$cf.udfCall1(/org/lucee/cfml/Base.cfc:110)
Template: /org/lucee/cfml/Base.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 35
Raw Trace: org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:35)
Template: /org/lucee/cfml/Query.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 69
Raw Trace: oilcity.includes.display_objects.custom.dsp_oc_business_directory_search_cfm$cf.call(/muraWRM/oilcity/includes/display_objects/custom/dsp_oc_business_directory_search.cfm:69)
Template: /var/www/Mura/oilcity/includes/display_objects/custom/dsp_oc_business_directory_search.cfm
Type: cfml

---

Column: 0
ID: ??
Line: 129
Raw Trace: oilcity.includes.contentrenderer_cfc$cf.udfCall(/muraWRM/oilcity/includes/contentRenderer.cfc:129)
Template: /var/www/Mura/oilcity/includes/contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 111
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:111)
Template: /var/www/Mura/requirements/mura/MuraScope.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 2254
Raw Trace: content.contentrenderer_cfc$cf.udfCallb(/mura/content/contentRenderer.cfc:2254)
Template: /var/www/Mura/requirements/mura/content/contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 91
Raw Trace: content.contentrendererutility_cfc$cf.udfCall1(/mura/content/contentRendererUtility.cfc:91)
Template: /var/www/Mura/requirements/mura/content/contentRendererUtility.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 2669
Raw Trace: content.contentrenderer_cfc$cf.udfCalld(/mura/content/contentRenderer.cfc:2669)
Template: /var/www/Mura/requirements/mura/content/contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 1510
Raw Trace: content.contentrenderer_cfc$cf.udfCall6(/mura/content/contentRenderer.cfc:1510)
Template: /var/www/Mura/requirements/mura/content/contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 111
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:111)
Template: /var/www/Mura/requirements/mura/MuraScope.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 26
Raw Trace: oilcity.includes.themes.oilcity.templates.directory_cfm$cf.call(/muraWRM/oilcity/includes/themes/oilcity/templates/directory.cfm:26)
Template: /var/www/Mura/oilcity/includes/themes/oilcity/templates/directory.cfm
Type: cfml

---

Column: 0
ID: ??
Line: 94
Raw Trace: translator.standardhtmltranslator_cfc$cf.udfCall(/mura/Translator/standardHTMLTranslator.cfc:94)
Template: /var/www/Mura/requirements/mura/Translator/standardHTMLTranslator.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 133
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:133)
Template: /var/www/Mura/requirements/mura/plugin/pluginStandardEventWrapper.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 87
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall1(/mura/Handler/standardEventsHandler.cfc:87)
Template: /var/www/Mura/requirements/mura/Handler/standardEventsHandler.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 89
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:89)
Template: /var/www/Mura/requirements/mura/plugin/pluginStandardEventWrapper.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 413
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall3(/mura/Handler/standardEventsHandler.cfc:413)
Template: /var/www/Mura/requirements/mura/Handler/standardEventsHandler.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 89
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:89)
Template: /var/www/Mura/requirements/mura/plugin/pluginStandardEventWrapper.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 788
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:788)
Template: /var/www/Mura/requirements/mura/content/contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 260
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:260)
Template: /var/www/Mura/requirements/mura/content/contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 310
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:310)
Template: /var/www/Mura/requirements/mura/content/contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 656
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:656)
Template: /var/www/Mura/requirements/mura/content/contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 46
Raw Trace: index_cfm$cf.call(/index.cfm:46)
Template: /var/www/Mura/index.cfm
Type: cfml