Error Executing Database Query.
|
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 ')
ORDER BY
p.txt_Title, s.txt_FileName, o.txt_LastName, o' at line 14
|
|
The error occurred in D:/Inetpub/steadishots/tags/shots_get.cfm: line 30
Called from D:/Inetpub/vhosts/steadishots.org/httpdocs/shots_detail.cfm: line 31
Called from D:/Inetpub/vhosts/steadishots.org/httpdocs/shots_detail.cfm: line 1
Called from D:/Inetpub/steadishots/tags/shots_get.cfm: line 30
Called from D:/Inetpub/vhosts/steadishots.org/httpdocs/shots_detail.cfm: line 31
Called from D:/Inetpub/vhosts/steadishots.org/httpdocs/shots_detail.cfm: line 1
|
28 : <cfif isDefined("attributes.sort")>
29 : #attributes.sort#
30 : <cfelse>
31 : p.txt_Title, s.txt_FileName, o.txt_LastName, o.txt_FirstName
32 : </cfif>
|
|
VENDORERRORCODE |
1064 |
SQLSTATE |
42000 |
SQL |
SELECT
s.pk_ShotID, s.int_ProductionID, s.int_OperatorID, s.int_AltOperatorID, s.txt_ShortDescription, s.mem_Description, s.mem_Comments, s.mem_Equipment, s.mem_Elements,
s.txt_FileName, s.int_FileTypeID, s.txt_Length, s.int_FileHeight, s.int_FileWidth, s.txt_FileSize, s.mem_EmbedCode, s.txt_Episode, s.txt_EpisodeDirector, s.txt_EpisodeDP,
s.cdts, s.yn_BTS, s.yn_Special, s.yn_External, s.int_Views, s.yn_Verified, s.txt_SubmittedBy, s.txt_SubmittedEmail, s.int_NumRatings, s.int_AvgRating, s.int_TrueRating,
p.pk_ProductionID, p.int_ProductionSourceID, p.txt_Title, p.int_Year, p.txt_Director, p.txt_DP, p.txt_Studio, p.txt_IMDBID, p.txt_WebSite, p.txt_AmazonLink,
o.pk_OperatorID, o.txt_LastName, o.txt_FirstName, o.txt_opIMDB,
ps.pk_SourceID, ps.txt_SourceName, ps.txt_SourceNickname
FROM tbl_LU_Shots s, tbl_KEY_Productions p, tbl_KEY_Operators o, tbl_KEY_ProductionSources ps
WHERE
s.int_ProductionID = p.pk_ProductionID
AND s.int_OperatorID = o.pk_OperatorID
AND p.int_ProductionSourceID = ps.pk_SourceID
AND s.pk_ShotID IN ()
ORDER BY
p.txt_Title, s.txt_FileName, o.txt_LastName, o.txt_FirstName
|
DATASOURCE |
steadishotsQ |
|
Resources:
|
Browser |
claudebot |
Remote Address |
3.239.13.1 |
Referrer |
|
Date/Time |
29-Mar-24 08:42 AM |
|
Stack Trace
|
at cfshots_get2ecfm1120450550.runPage(D:/Inetpub/steadishots/tags/shots_get.cfm:30)
at cfshots_detail2ecfm1146171969._factor6(D:/Inetpub/vhosts/steadishots.org/httpdocs/shots_detail.cfm:31)
at cfshots_detail2ecfm1146171969.runPage(D:/Inetpub/vhosts/steadishots.org/httpdocs/shots_detail.cfm:1)
at cfshots_get2ecfm1120450550.runPage(D:/Inetpub/steadishots/tags/shots_get.cfm:30)
at cfshots_detail2ecfm1146171969._factor6(D:/Inetpub/vhosts/steadishots.org/httpdocs/shots_detail.cfm:31)
at cfshots_detail2ecfm1146171969.runPage(D:/Inetpub/vhosts/steadishots.org/httpdocs/shots_detail.cfm:1)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ')
ORDER BY
p.txt_Title, s.txt_FileName, o.txt_LastName, o' at line 14
at sun.reflect.GeneratedConstructorAccessor9181.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:838)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
at coldfusion.sql.Executive.executeQuery(Executive.java:1288)
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 cfshots_get2ecfm1120450550.runPage(D:\Inetpub\steadishots\tags\shots_get.cfm:30)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
at cfshots_detail2ecfm1146171969._factor6(D:\Inetpub\vhosts\steadishots.org\httpdocs\shots_detail.cfm:31)
at cfshots_detail2ecfm1146171969.runPage(D:\Inetpub\vhosts\steadishots.org\httpdocs\shots_detail.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)
|
|