Clarion Inn Branson
Nearby Restaurants

North America > United States > Ozarks > Branson > Directory > Lodging > Hotels > Clarion Inn Branson > Nearby Restaurants > Page 5/9

Clarion Inn Branson

N/A - No reviews Save Listing

Located at Branson, Missouri - 2820 W 76 Country Blvd - Branson, MO 65616
Main
Media & Events
Tools
Explore Nearby

Places to eat near Clarion Inn Branson - Page 5/9

There are 86 restaurants within a 2-mile radius of Clarion Inn Branson in Branson.

0.8 mi W
←

Andy's Frozen Custard

3415 W 76 Country Blvd - Branson, MO 65616, US

Indulge in a sweet treat at 'Andy's Frozen Custard' in Branson, where delicious frozen custard is the star of the show. Known for its creamy texture and rich flavor, Andy's serves up a variety of frozen custard creations, including cones, sundaes, concretes, and seasonal specialties. Each order is made fresh using high-quality i... Read more

Map
Reviews

0.7 mi WSW
↙

St. James Winery & Restaurant

405 MO-165 - Branson, MO 65616, US

St. James Winery & Restaurant in Branson, Missouri, offers an impressive selection of award-winning wines, juices, ciders, and beers. Known for its Branson Reserve label, the winery features unique blends like Blackberry Velvet and Velvet Berry. The venue provides a cozy, upscale atmosphere indoors and a delightful backyard pati... Read more

Map
Images
Reviews

0.8 mi W
←

Desia's Spicy Bites

3420 W 76 Country Blvd - Branson, MO 65616, US

Desia's Spicy Bites in Branson, Missouri, is a popular spot for those craving authentic Caribbean flavors. Located on W 76 Country Blvd, this restaurant offers a variety of delicious dishes such as Jamaican Jerk Chicken, curry goat, and steam veggies. Patrons appreciate the vibrant atmosphere and friendly service, making it a go... Read more

Map
Reviews

0.9 mi ENE
↗

Grand Country Buffet

Located at Grand Country Resort - 1945 W 76 Country Blvd - Branson, MO 65616

Grand Country Buffet in Branson, Missouri, is a well-loved dining destination that offers an extensive array of comfort foods in a family-friendly atmosphere. Located on West 76 Country Blvd, this buffet is known for its wide selection of breakfast, lunch, and dinner options. Guests can enjoy a variety of dishes, including count... Read more

Map
Images
Reviews

0.9 mi ENE
↗

Glenn's Frozen Custard

Located at Grand Country Resort - 1945 W 76 Country Blvd - Branson, MO 65616

Glenn's Frozen Custard in Branson, Missouri, located on W 76 Country Blvd, is a popular spot for enjoying a variety of creamy, flavorful custards. Known for its delicious sundaes, concretes, and cones, Glenn's offers a nostalgic treat with numerous toppings and mix-ins to customize your dessert. The venue provides a casual dinin... Read more

Map
Reviews

0.9 mi ENE
↗

Papa Grand's Pizza

Located at Grand Country Resort - 1945 W 76 Country Blvd - Branson, MO 65616

Papa Grand's Pizza in Branson, Missouri, is located at the Grand Country Resort and is known for its family-friendly atmosphere and extensive buffet. The restaurant offers an all-you-can-eat pizza and salad bar, featuring a variety of pizza options, including the popular cheesy Alfredo and spinach pizza. The buffet also includes... Read more

Map
Reviews

0.9 mi ENE
↗

Crazy Craig's Treehouse

1924 W 76 Country Blvd - Branson, MO 65616, US

Crazy Craig's Treehouse in Branson, Missouri, is a vibrant bar and grill known for its fun atmosphere and tropical-themed drinks. Located on West 76 Country Blvd, it offers a diverse menu featuring tasty items like treehouse nachos, Italian beef panini, and Reuben sandwiches. The bar is praised for its friendly bartenders and li... Read more

Map
Reviews

1 mi ENE
↗

Famous Dave's Bar-B-Que

1855 W 76 Country Blvd - Branson, MO 65616, US

Famous Dave's Bar-B-Que in Branson, Missouri, located on W 76 Country Blvd, is a popular barbecue restaurant known for its wood-smoked meats and hearty sides served in an American West-themed space. The menu includes a variety of barbecue classics such as ribs, brisket, and pulled pork, complemented by traditional sides like bak... Read more

Map
Reviews

0.9 mi ENE
↗

Outback Steak & Oyster Bar

1914 W 76 Country Blvd - Branson, MO 65616, US

Outback Steak & Oyster Bar in Branson, Missouri, offers a unique dining experience with a focus on Australian cuisine, including steaks, seafood, and other hearty dishes. Part of the Outback Roadhouse motel property, the restaurant provides a casual, low-key dining atmosphere. Known for its quality food and friendly service, it ... Read more

Map
Reviews

0.7 mi SW
↙

The Jerk Spot

607 Historic Hwy 165 Suite 6 - Branson, MO 65616, US

The Jerk Spot in Branson, Missouri, is a highly regarded restaurant known for its authentic Jamaican cuisine. Located conveniently along State Highway 165, this eatery offers a diverse menu that features classic Jamaican dishes such as Jerk Chicken, Oxtails, and Rasta Pasta. Patrons frequently praise the flavorful food and welco... Read more

Map
Reviews

An unexpected error occurred.

Please provide the following information to technical support:

Error Event: onRequest

Error details:

Form - struct [empty]
URL - struct
listing_id 394
page 5
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorCode 1064
Message 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:787) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1618) at coldfusion.sql.Executive.executeQuery(Executive.java:1360) at coldfusion.sql.Executive.executeQuery(Executive.java:1290) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:654) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:584) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:547) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:443) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:315) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor301.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 12
RAW_TRACE at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12)
TEMPLATE D:\wwwsites\traveldestinations.guide\udf\footer.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1406
RAW_TRACE at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 578
RAW_TRACE at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource traveldestinations
Detail 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
ErrorCode 42000
Exceptions
Error - array
1
Error - struct
class java.sql.SQLSyntaxErrorException
message 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
Message Error Executing Database Query.
NativeErrorCode 1064
RootCause
Error - struct
ErrorCode 1064
Message 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:787) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1618) at coldfusion.sql.Executive.executeQuery(Executive.java:1360) at coldfusion.sql.Executive.executeQuery(Executive.java:1290) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:654) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:584) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:547) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:443) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:315) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor301.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 12
RAW_TRACE at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12)
TEMPLATE D:\wwwsites\traveldestinations.guide\udf\footer.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1406
RAW_TRACE at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 578
RAW_TRACE at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42000
Sql SELECT destination_id, name, city, state, state_full, country, country_full, type, FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ( ) DESC, city ASC LIMIT 16
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:654) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:584) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:547) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:443) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:315) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor301.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLSyntaxErrorException: 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:787) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1618) at coldfusion.sql.Executive.executeQuery(Executive.java:1360) at coldfusion.sql.Executive.executeQuery(Executive.java:1290) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) ... 80 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 12
RAW_TRACE at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12)
TEMPLATE D:\wwwsites\traveldestinations.guide\udf\footer.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1406
RAW_TRACE at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 578
RAW_TRACE at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\application.cfc
TYPE CFML
Type Database
queryError 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
where [empty string]
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message Event handler exception.
RootCause
Error - struct
Cause
Error - struct
ErrorCode 1064
Message 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:787) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1618) at coldfusion.sql.Executive.executeQuery(Executive.java:1360) at coldfusion.sql.Executive.executeQuery(Executive.java:1290) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:654) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:584) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:547) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:443) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:315) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor301.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 12
RAW_TRACE at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12)
TEMPLATE D:\wwwsites\traveldestinations.guide\udf\footer.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1406
RAW_TRACE at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 578
RAW_TRACE at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource traveldestinations
Detail 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
ErrorCode 42000
Exceptions
Error - array
1
Error - struct
class java.sql.SQLSyntaxErrorException
message 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
Message Error Executing Database Query.
NativeErrorCode 1064
RootCause
Error - struct
ErrorCode 1064
Message 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:787) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1618) at coldfusion.sql.Executive.executeQuery(Executive.java:1360) at coldfusion.sql.Executive.executeQuery(Executive.java:1290) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:654) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:584) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:547) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:443) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:315) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor301.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 12
RAW_TRACE at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12)
TEMPLATE D:\wwwsites\traveldestinations.guide\udf\footer.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1406
RAW_TRACE at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 578
RAW_TRACE at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42000
Sql SELECT destination_id, name, city, state, state_full, country, country_full, type, FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ( ) DESC, city ASC LIMIT 16
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:654) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:584) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:547) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:443) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:315) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor301.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLSyntaxErrorException: 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:787) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1618) at coldfusion.sql.Executive.executeQuery(Executive.java:1360) at coldfusion.sql.Executive.executeQuery(Executive.java:1290) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) ... 80 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 12
RAW_TRACE at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12)
TEMPLATE D:\wwwsites\traveldestinations.guide\udf\footer.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1406
RAW_TRACE at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 578
RAW_TRACE at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\application.cfc
TYPE CFML
Type Database
queryError 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10
where [empty string]
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor301.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274) at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:654) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:584) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:547) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:470) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:443) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:315) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 56 more Caused by: java.sql.SQLSyntaxErrorException: 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 'FROM destinations WHERE enabled = 1 AND type = 'City' ORDER BY ' at line 10 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:787) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1618) at coldfusion.sql.Executive.executeQuery(Executive.java:1360) at coldfusion.sql.Executive.executeQuery(Executive.java:1290) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868) ... 80 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 12
RAW_TRACE at cffooter2ecfm1325263524.runPage(D:\wwwsites\traveldestinations.guide\udf\footer.cfm:12)
TEMPLATE D:\wwwsites\traveldestinations.guide\udf\footer.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1406
RAW_TRACE at cflisting_nearby_restaurants2ecfm1029066222.runPage(D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm:1406)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\listing_nearby_restaurants.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 578
RAW_TRACE at cfapplication2ecfc299637537$funcONREQUEST.runFunction(D:\wwwsites\traveldestinations.guide\www\application.cfc:578)
TEMPLATE D:\wwwsites\traveldestinations.guide\www\application.cfc
TYPE CFML
Type Database
name onRequest