500 - Internal server error.

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

Craig Childs - About The Author
Craig Childs - House of Rain
home about audio books writings wish list

contact

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][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The specified field 'SortNumber' could refer to more than one table listed in the FROM clause of your SQL statement.
 
The error occurred in D:/Inetpub/houseofrain/theauthor.cfm: line 131
Called from D:/Inetpub/houseofrain/theauthor.cfm: line 115
Called from D:/Inetpub/houseofrain/theauthor.cfm: line 1
Called from D:/Inetpub/houseofrain/theauthor.cfm: line 131
Called from D:/Inetpub/houseofrain/theauthor.cfm: line 115
Called from D:/Inetpub/houseofrain/theauthor.cfm: line 1
129 : 	SELECT 	i.ImageID, i.ImageName, i.SmallImage, gi.SortNumber, g.GalleryName
130 : 	FROM 	images i, galleriesimages gi, booksgalleries g
131 : 	WHERE	gi.GalleryID = '#getGallery.GalleryID#'
132 : 	AND		gi.ImageID = i.ImageID
133 : 	AND 	g.GalleryID = gi.GalleryID

VENDORERRORCODE   -3007
SQLSTATE   HY000
SQL    SELECT i.ImageID, i.ImageName, i.SmallImage, gi.SortNumber, g.GalleryName FROM images i, galleriesimages gi, booksgalleries g WHERE gi.GalleryID = '1169696254687' AND gi.ImageID = i.ImageID AND g.GalleryID = gi.GalleryID ORDER BY SortNumber
DATASOURCE   houseofrain
Resources:

Browser   claudebot
Remote Address   52.90.181.205
Referrer  
Date/Time   18-Mar-24 10:53 PM
Stack Trace
at cftheauthor2ecfm1040322304._factor2(D:/Inetpub/houseofrain/theauthor.cfm:131) at cftheauthor2ecfm1040322304._factor20(D:/Inetpub/houseofrain/theauthor.cfm:115) at cftheauthor2ecfm1040322304.runPage(D:/Inetpub/houseofrain/theauthor.cfm:1) at cftheauthor2ecfm1040322304._factor2(D:/Inetpub/houseofrain/theauthor.cfm:131) at cftheauthor2ecfm1040322304._factor20(D:/Inetpub/houseofrain/theauthor.cfm:115) at cftheauthor2ecfm1040322304.runPage(D:/Inetpub/houseofrain/theauthor.cfm:1)

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The specified field 'SortNumber' could refer to more than one table listed in the FROM clause of your SQL statement.
	at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
	at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decode(Unknown Source)
	at macromedia.sequelink.ssp.Chain.send(Unknown Source)
	at macromedia.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown Source)
	at macromedia.jdbc.sequelink.SequeLinkImplStatement.execute(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:254)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1298)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1051)
	at coldfusion.sql.Executive.executeQuery(Executive.java:982)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533)
	at cftheauthor2ecfm1040322304._factor2(D:\Inetpub\houseofrain\theauthor.cfm:131)
	at cftheauthor2ecfm1040322304._factor20(D:\Inetpub\houseofrain\theauthor.cfm:115)
	at cftheauthor2ecfm1040322304.runPage(D:\Inetpub\houseofrain\theauthor.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:369)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
	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:53)
	at coldfusion.CfmServlet.service(CfmServlet.java:201)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:428)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.d(FusionReactorFilter.java:262)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:171)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	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 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)