| struct | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DataSource | store | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Detail | Subquery returns more than 1 row | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ErrorCode | 21000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Exceptions |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Message | Error Executing Database Query. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| NativeErrorCode | 1242 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| RootCause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQLState | 21000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sql | SELECT product.product_id, product.product_name,product.is_active, product.date_created,product.old_id,product.cloud_map , man.man_id, man.man_name, man.MAN_TITLE ,man.auth_dealer,Product_detail.weight, Product_detail.dim_weight, Product_detail.X, Product_detail.Y, Product_detail.Z, Product_detail.MAP, Product_detail.use_map, Product_detail.qty_in_stock, Product_detail.eta, Product_detail.days_till_ship, product_detail.ARcust_code ,Product_detail.UPC, Product_detail.SKU, Product_detail.use_ALOC ,Product_detail.Has_image, Product_detail.Product_note, Product_detail.sale_price,Product_detail.Offer_Tradein, Product_detail.Pre_Sale_QTY,Product_detail.POP_Discount,Product_detail.POP_Discount_backUP,Product_detail.List_Price,Product_detail.man_Warranty,product.is_active, Product_detail.qty_in_stock as ONHAND, (select product_name from product p where product_id=Product_detail.Free_product) as Free_product_name, (select product_kit_name from product p where product_id=Product_detail.Free_product) as Free_kit_name, Product_detail.Free_product as Free_product_id,Product_detail.Block_Search, Product_detail.Demo_URL, Product_detail.PDF_URL, Product_detail.Product_note_start, Product_detail.Product_note_end, Product_detail.fk_Warranty_id, Product_detail.show_Ship_USA_only, Product_detail.ship_ground_only,Product_detail.show_please_call, Product_detail.Block_cart ,stock_type.stock_type_id, stock_type.stock_type_name, stock_type.stock_type_color, stock_type.stock_type_name_internal, product_condition.product_condition_id, product_condition.product_condition_name, Product_rebate.Product_rebate_id, Product_rebate.rebate_url, Product_rebate.rebate_text, Product_rebate.rebate_amount, Product_rebate.from_date, Product_rebate.to_date, Product_description.features, Product_description.spec, Product_description.spec_Mobile, Product_description.bulletpoint1,Product_description.bulletpoint2,Product_description.bulletpoint3,Product_description.bulletpoint4,Product_description.bulletpoint5, Product_description.caption, Product_to_cat_sub.fk_Cat_sub_id, Product_detail.alt_item, Product_description.meta_title, Product_description.meta_Description, Product_description.meta_Keywords, Cat_sub.Cat_sub_id, Cat_sub.sub_name, Cat_Category.Cat_Category_id, Cat_Category.Category_name, Cat_department.Cat_department_id, Cat_department.Department_name, (SELECT shipping_type.shipmentDesc FROM product_shipping INNER JOIN shipping_type ON product_shipping.fk_shipping_type = shipping_type.shipping_type_id WHERE (shipping_type.stateCode IS NOT NULL) AND (shipping_type.countryCode = 'US') AND (product_shipping.fk_product_id = product.product_id) ORDER BY shipping_type.shipping_type_id DESC limit 1 ) AS shipping, case (SELECT shipping_type.shipmentDesc FROM product_shipping INNER JOIN shipping_type ON product_shipping.fk_shipping_type = shipping_type.shipping_type_id WHERE (shipping_type.stateCode IS NOT NULL) AND (shipping_type.countryCode = 'US') AND (product_shipping.fk_product_id = product.product_id) and shipping_type_id =10 ) when 'Ground, UPS' then 0 else (SELECT (perWeightToAdd*product_detail.dim_weight)+(priceToAdd) FROM shipping_type where shipping_type_id =10)*1.1 end AS shipping_price, product_store.Price, product_store.fk_store_id, '' as SG_URL , (SELECT fk_product_id FROM feature_value inner join product_to_feature on feature_value.feature_value_id = product_to_feature.fk_feature_value_id WHERE feature_value_id = 6 and fk_product_id=product.product_id LIMIT 1) as made_in_usa , (SELECT HTML_page from man_store WHERE FK_MAN_ID=man.MAN_ID and fk_store_id =product_store.fk_store_id) AS HTML_page , (SELECT ALOC FROM arinv99 where ITEM = left(product_detail.ARcust_code,50) limit 1) as ALOC, page_rank.rank,'0' as jquery FROM product INNER JOIN Product_detail ON Product_detail.fk_product_id = product.product_id INNER JOIN Product_description ON product.product_id = Product_description.fk_product_id INNER JOIN product_condition ON Product_detail.fk_product_condition_id = product_condition.product_condition_id INNER JOIN stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id inner join product_store ON product_store.fk_product_id = product.product_id LEFT OUTER JOIN Cat_sub LEFT OUTER JOIN Product_to_cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id LEFT OUTER JOIN Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id LEFT OUTER JOIN Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id ON product.product_id = Product_to_cat_sub.fk_product_id LEFT OUTER JOIN Product_rebate ON product.product_id = Product_rebate.fk_product_id LEFT OUTER JOIN man ON product.fk_man_id = man.man_id left outer join page_rank on product.product_id = page_rank.fk_product_id WHERE (product_store.fk_store_id = 17) AND product.product_id = 64109 AND product.FK_MAN_ID <> 224 AND product.FK_MAN_ID <> 85 AND product.FK_MAN_ID <> 262 and Product_detail.Block_cart <> 3 AND (product.is_active = 1) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| StackTrace | coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfqry_product2ecfm333286336._factor6(E:\inetpub\Websites\global\qry\qry_product.cfm:79) at cfqry_product2ecfm333286336.runPage(E:\inetpub\Websites\global\qry\qry_product.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfindex2ecfm1814390410.runPage(E:\inetpub\Websites\itinscales.com\product\index.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) 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:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:762) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: java.sql.SQLException: Subquery returns more than 1 row at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:781) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) ... 50 more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Suppressed |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| TagContext |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Type | Database | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| queryError | Subquery returns more than 1 row | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| where | [empty string] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||