Error Executing Database Query.
|
|
Data source rejected establishment of connection, message from server: "Too many connections"
|
| |
The error occurred in C:/WEB/HPhoto/CFC/eretail_productprice.cfc: line 151
Called from C:/WEB/HPhoto/detail_page.cfm: line 123
Called from C:/WEB/HPhoto/detail_page.cfm: line 1
|
149 : <cfif IsDefined('toshow')>AND retail_products.discontinued = <cfqueryparam cfsqltype="cf_sql_varchar" value="#toshow#" maxlength="1"></cfif>
150 : <cfif IsDefined('onlymember')>AND #request.app.companyid#override.memberprice > 0</cfif>
151 : <cfif IsDefined('compatible')>AND retail_products.compatible LIKE <cfqueryparam cfsqltype="cf_sql_longvarchar" value="%#compatible#%"></cfif>
152 : order by retail_products.retail_price, retail_products.manufacturer, retail_products.productname;
153 : </cfquery>
|
|
| SQLSTATE |
08004 |
| EXCEPTIONS |
<small><i>not set</i></small> |
| DATASOURCE |
eretail |
| VENDORERRORCODE |
1040 |
| SQL |
Select
retail_products.productid, retail_products.Manufacturer, retail_products.retail_price, retail_products.MAP,
IF(1override.description is NULL, retail_products.ProductName, 1override.description) as ProductName,
1override.description as override_Productname, retail_products.description2, retail_products.specifications,
retail_products.Fronttext, retail_products.description1, retail_products.longdescription, retail_products.compatible, retail_products.graphic, retail_products.Weight, retail_products.BundleInclude, retail_products.hide,
retail_products.preorder, retail_products.unique_prodid, retail_products.firstsaledate,
IF(1override.eta is NULL, retail_products.eta,1override.eta) as ETA,
1retailer_noshow.productid,
1retailer_noshow.storesku,
1override.call_for_price,
1override.dropship,
1override.special_order,
1override.keywords as override_keywords,
1override.Compatible as override_Compatible,
1override.graphic as override_graphic,
1override.longdescription as override_longdescription,
1override.specifications as override_specifications,
1override.BundleInclude as override_BundleInclude,
1override.Fronttext as override_Fronttext,
1override.Weight as override_Weight,
1override.LongDescription_Add,
1override.Discount_In_Cart,
1override.coming_soon,
1override.Discount_In_Email,
1override.Frontpage,
1override.price as override_price,
1override.memberprice as override_memberprice,
1override.longdescription_add as override_longdescription_add,
1override.Preorder as override_preorder,
1override.remove_notify_me,
1override.remove_call_for_price,
1cat_main_2017.maincategory,
1inventory.whse1_qty,
1inventory.whse2_qty as Boston,
1inventory.whse3_qty as Cambridge,
1inventory.whse4_qty as Hanover,
1inventory.whse5_qty as Holyoke,
1inventory.whse6_qty as Manchester,
1inventory.whse7_qty as Melrose,
1inventory.whse8_qty as Providence,
1inventory.whse9_qty as Portland,
1inventory.whse10_qty as Waltham,
1inventory.weight, navigation_2018.HeaderID, navigation_2018.classID, navigation_2018.CatSubID, navigation_2018.CatMainID AS categoryid, class_2017.class, cat_sub_2017.category as category,
1cat_main_2017.maincategory, IF(1override.price > 0,1override.price, IF(retail_products.MAP > 0, retail_products.map,
IF(retail_products.retail_price > 0, retail_products.retail_price, 0))) as sell_price, qty_force,
IF(1inventory.qty_force='In',5,IF(1inventory.qty_force='Out',0,1inventory.whse1_qty)) as Total_qty,
IF(retail_products.upc is NULL, retail_products.productid, retail_products.upc) as retailer_sku
FROM retail_products
LEFT JOIN navigation_2018 ON retail_products.unique_prodid = navigation_2018.productid
LEFT JOIN 1override on retail_products.unique_prodid = 1override.productid
LEFT JOIN 1inventory on retail_products.unique_prodid = 1inventory.productid
LEFT JOIN 1cat_main_2017 ON navigation_2018.catMainID = 1cat_main_2017.CatMainID
LEFT JOIN cat_sub_2017 ON navigation_2018.catsubid = cat_sub_2017.CatSubID
LEFT JOIN class_2017 on navigation_2018.classid = class_2017.classid
LEFT JOIN 1retailer_noshow ON 1retailer_noshow.productid=retail_products.unique_prodid
Where retail_products.hide is NULL
AND ((store_exclusive is NULL) or (store_exclusive = (param 1) ))
AND retail_products.productid = (param 2) AND retail_products.manufacturer= (param 3)
AND 1retailer_noshow.productid IS NULL AND 1retailer_noshow.storeSKU IS NULL
order by retail_products.retail_price, retail_products.manufacturer, retail_products.productname; |
|
|
Resources:
|
| Browser |
claudebot |
| Remote Address |
3.144.113.30 |
| Referrer |
|
| Date/Time |
18-Apr-24 05:22 PM |
|
|
Stack Trace
|
at cferetail_productprice2ecfc70405866$funcGET.runFunction(C:/WEB/HPhoto/CFC/eretail_productprice.cfc:151) at cfdetail_page2ecfm1631066725._factor25(C:/WEB/HPhoto/detail_page.cfm:123) at cfdetail_page2ecfm1631066725.runPage(C:/WEB/HPhoto/detail_page.cfm:1)
java.sql.SQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections"
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:815)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:438)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:189)
at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:667)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.base/java.lang.Thread.run(Thread.java:833)
|
|