500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
 
The error occurred in D:/Websites/StellarAviation/stellarinternational.com/SpecTemplates/classic/Printable/PrintableSpec.cfm: line 25
23 : WHERE 		EngineTypes.EngineTypeID=UniqueEngines.EngineTypeID
24 : 			AND	
25 : 			UniqueEngines.UniqueAircraftID=#URL.AircraftID#
26 : 			AND	
27 : 			EngineTypes.EngineManufacturerID=EngineManufacturers.EngineManufacturerID

VENDORERRORCODE   1033
SQLSTATE   HY000
SQL    SELECT * FROM (SELECT * FROM UniqueEngines LEFT OUTER JOIN (SELECT * FROM UniqueEngineItems, AviationGlossary WHERE UniqueEngineItems.AviationGlossaryID=AviationGlossary.AviationGlossaryID ORDER BY Priority,GlossaryTerm) AS Items ON UniqueEngines.UniqueEngineID = Items.UniqueEngineID ) AS EngineItems, EngineTypes, EngineModels, EngineManufacturers WHERE EngineTypes.EngineTypeID=UniqueEngines.EngineTypeID AND UniqueEngines.UniqueAircraftID=117 AND EngineTypes.EngineManufacturerID=EngineManufacturers.EngineManufacturerID AND EngineTypes.EngineModelID=EngineModels.EngineModelID ORDER BY EngineNumber, EngineManufacturerName, EngineModel, Priority, GlossaryTerm
DATASOURCE   JSAStellar
Resources:

Browser   claudebot
Remote Address   3.237.91.98
Referrer  
Date/Time   28-Mar-24 11:49 AM
Stack Trace
at cfPrintableSpec2ecfm1310103515.runPage(D:/Websites/StellarAviation/stellarinternational.com/SpecTemplates/classic/Printable/PrintableSpec.cfm:25) at cfPrintableSpec2ecfm1310103515.runPage(D:/Websites/StellarAviation/stellarinternational.com/SpecTemplates/classic/Printable/PrintableSpec.cfm:25)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
	at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1420)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfPrintableSpec2ecfm1310103515.runPage(D:\Websites\StellarAviation\stellarinternational.com\SpecTemplates\classic\Printable\PrintableSpec.cfm:25)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:201)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at com.seefusion.SeeFusion.doFilter(SeeFusion.java)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)