Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Ambiguous column name 'brand'.
|
| |
The error occurred in C:/websites/alamofiesta.com/queries/grandgetproducts.cfm: line 68
Called from C:/websites/alamofiesta.com/Application.cfm: line 297
Called from C:/websites/alamofiesta.com/queries/grandgetproducts.cfm: line 68
Called from C:/websites/alamofiesta.com/Application.cfm: line 297
|
66 : LEFT JOIN TB_SKU_LOOKUPS lk ON (B.sku_id = lk.sku_id and lk.prime='Y')
67 : WHERE
68 : c.store_id = #store#
69 :
70 : and
|
|
| SQLSTATE |
HY000 |
| DATASOURCE |
celerantsql |
| VENDORERRORCODE |
209 |
| SQL |
SELECT distinct
b.sku_id,
(d.styles_web_taxonomy_id) as styles_web_taxonomy_id
,max(a.style_id) as style_id
, max(a.picture_id)
,max(a.style) as style
, min(c.price) as min_price
, case when min(c.team_price) > 0 then min(c.team_price) else min(c.price) end as team_price
, max(c.price) as max_price
, max(c.first_price) as maxPrice
, max(a.date_entered) as date_entered
,max(qoh) as qoh
,c.store_id as store_id
, max(a.web_style) as web_style
, max(a.web_desc) as web_desc
, max(a.description) as description
, max(a.picture_id) as picture_id
, max(e.dept) as dept
, max(e.typ) as typ
, max(e.subtyp_1) as subtyp_1
, max(e.subtyp_2) as subtyp_2
, max(e.subtyp_3) as subtyp_3
, max(e.category_style) as category_style
, max(e.web_url) as web_url
, max(e.sort_position) as sort_position
,max(e.web_taxonomy_id) as web_taxonomy_id
, max(brand) as brand
, MAX(c.sugg_price) AS max_sugg_price
, max(date_entered) as date_entered
,max(of1) as of1
,max(of2) as of2
,max(of3) as of3
,max(of4) as of4
,max(of5) as of5
,max(of6) as of6
,max(of7) as of7
,max(of8) as of8
,sum(c.qoh) as qoh
,max(c.qs) as qs
,max(g.attr1) as attr1
,max(g.attr1_alias) as attr1_alias
,max(g.attr1_entry_id) as attr1_entry_id
,max(f.siz) as siz
,max(f.scale_entry_id) as scale_entry_id
,max(f.siz_alias) as siz_alias
,max(lk.lookup) as prime_barcode
,max(a.web_long_desc) as web_long_desc
FROM
tb_styles a WITH (NOLOCK)
INNER JOIN dbo.tb_skus b WITH (NOLOCK)
ON (a.style_id = b.style_id)
INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK)
ON (b.sku_id = c.sku_id)
INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK)
ON (a.style_id = d.style)
INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK)
ON (d.web_taxonomy_id = e.web_taxonomy_id)
left join tb_size_entries f on (f.scale_entry_id = b.scale_entry_id)
left join tb_attr1_entries g on (g.attr1_entry_id = b.attr1_entry_id)
LEFT JOIN TB_SKU_LOOKUPS lk ON (B.sku_id = lk.sku_id and lk.prime='Y')
WHERE
c.store_id = 3
and
a.web_product= 'Y'
GROUP BY
b.sku_id,d.styles_web_taxonomy_id, c.store_id
|
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
216.73.216.148 |
| Referrer |
|
| Date/Time |
17-Sep-25 05:06 PM |
|
|
Stack Trace
|
at cfgrandgetproducts2ecfm606481891.runPage(C:/websites/alamofiesta.com/queries/grandgetproducts.cfm:68) at cfApplication2ecfm788950548.runPage(C:/websites/alamofiesta.com/Application.cfm:297)
at cfgrandgetproducts2ecfm606481891.runPage(C:/websites/alamofiesta.com/queries/grandgetproducts.cfm:68) at cfApplication2ecfm788950548.runPage(C:/websites/alamofiesta.com/Application.cfm:297)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Ambiguous column name 'brand'.
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.dda3.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:1485)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1121)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:808)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfgrandgetproducts2ecfm606481891.runPage(C:\websites\alamofiesta.com\queries\grandgetproducts.cfm:68)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfApplication2ecfm788950548.runPage(C:\websites\alamofiesta.com\Application.cfm:297)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:391)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:58)
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:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
|
|