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)='A' 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: 53
Raw Trace: org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:53)
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

 
 
JOIN OUR MAILING LIST
 

Oil Region Alliance - Downtown Oil City Pennsylvania City of Oil City - Downtown Oil City Pennsylvania Elizabeth S. Black, PNC Trustee and Edith S. Black, PNC Trustee Pennsylvania Downtown - Downtown Oil City Pennsylvania

Terms of Use
This website is intended to share information about the Oil City Main Street Program and the Oil City Main Street District. Businesses listed are only those within the Main Street designated area of downtown. Many other businesses exist beyond the Main Street District in downtown Oil City. Users agree not to use this website or its services to post, use or transmit content that you do not have the right to post or use, for example, using photos without the consent of the photographer, copying content or information within the website or using any of the images or content in an inappropriate way such as spamming businesses or individuals listed within the website. See the complete Terms and Photo Credits here.