Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'UNION'.
|
| |
The error occurred in C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog_info_cata.cfm: line 49
Called from C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog.cfm: line 169
Called from C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog_info_cata.cfm: line 49
Called from C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog.cfm: line 169
|
47 : where CC.type = 1
48 : ) as row_num_table
49 : WHERE row_num BETWEEN (#results_per_page# * (#page_num# - 1) + 1) AND (#results_per_page# * #page_num#)<!---throws this error here -- why? "Error","ajp-nio-8018-exec-7","09/21/19","07:53:10",aso,"Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'UNION'. The specific sequence of files included or processed is: C:\inetpub\wwwroot\beta.artsuppliesonline.com\site\catalog.cfm, line: 49 "
50 :
51 : at cfcatalog_info_cata2ecfm1520010967.runPage(C:\inetpub\wwwroot\beta.artsuppliesonline.com\site\catalog_info_cata.cfm:49)
|
|
| SQLSTATE |
HY000 |
| DATASOURCE |
ASO_P |
| VENDORERRORCODE |
156 |
| SQL |
with cte_catas ( id, type, name )
AS (select
id, type, name
from [ASO_P].[dbo].[cata] AS P
where is_online = 1 and parent_id =
UNION ALL
SELECT
P.id,
P.type,
p.name
FROM cte_catas C
INNER JOIN [ASO_P].[dbo].[cata] AS P ON C.id = P.parent_id
where P.is_online = 1 and P.parent_id <> 0
)
SELECT row_num, id, description, price, item_category, color_hex
from (SELECT ROW_NUMBER() OVER(ORDER BY (select NULL as noorder)) as row_num, I.id as id, I.description as description, I.price as price, I.cata_fid as item_category, i.color_hex as color_hex
FROM cte_catas CC
JOIN items I on I.cata_fid = CC.id
where CC.type = 1
) as row_num_table
WHERE row_num BETWEEN (100 * (1 - 1) + 1) AND (100 * 1)
|
|
|
Resources:
|
| Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
| Remote Address |
34.232.63.94 |
| Referrer |
|
| Date/Time |
29-Mar-23 05:09 AM |
|
|
Stack Trace
|
at cfcatalog_info_cata2ecfm1520010967.runPage(C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog_info_cata.cfm:49) at cfcatalog2ecfm1855366439.runPage(C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog.cfm:169)
at cfcatalog_info_cata2ecfm1520010967.runPage(C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog_info_cata.cfm:49) at cfcatalog2ecfm1855366439.runPage(C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog.cfm:169)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'UNION'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.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.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
at cfcatalog_info_cata2ecfm1520010967.runPage(C:\inetpub\wwwroot\beta.artsuppliesonline.com\site\catalog_info_cata.cfm:49)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
at cfcatalog2ecfm1855366439.runPage(C:\inetpub\wwwroot\beta.artsuppliesonline.com\site\catalog.cfm:169)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
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:96)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
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:226)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
|
|
