Error Executing Database Query.
|
Data source rejected establishment of connection, message from server: "Too many connections"
|
|
The error occurred in C:/WEB/HPhoto/responsive/listing.cfm: line 281
|
279 : <cfelse>
280 : <!---- This keeps the order the same as the results in CFSearch ----->
281 : ORDER BY FIND_IN_SET(retail_products.UNIQUE_PRODID, '#listremoveduplicates(valuelist(getresults1.key))#')
282 : </cfif>
283 : </cfquery>
|
|
SQLSTATE |
08004 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
eretail |
VENDORERRORCODE |
1040 |
SQL |
Select distinct retail_products.unique_ProdID as newkey, retail_products.ID, retail_products.unique_prodID, CONCAT(retail_products.manufacturer, ' ', retail_products.productname) as title,
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 custom1,
retail_products.graphic as custom3, retail_products.manufacturer as custom4, retail_products.firstsaledate as fsd_s, navigation_2018.catmainid, navigation_2018.headerid, navigation_2018.catsubid, navigation_2018.classid, retail_products.fronttext as ftext_s, 1override.description as over_pname_s, 1cat_main_2017.maincategory,
1override.Fronttext as over_front_s, 1override.graphic as over_graphic_s, 1override.Preorder as over_pre_s, retail_products.front_bullet_list as lis_s, cat_sub_2017.category,
retail_products.productid as pid_s, 1override.call_for_price as cpf_s, IF(1inventory.qty_force='In',5,IF(1inventory.qty_force='Out',0,1inventory.whse1_qty + 1inventory.whse2_qty + 1inventory.whse3_qty + 1inventory.whse4_qty + 1inventory.whse5_qty + 1inventory.whse6_qty +
1inventory.whse7_qty +
1inventory.whse8_qty +
1inventory.whse9_qty)) as qty_s,
1override.discount_in_cart as dic_s, 1override.discount_in_email as die_s,
1override.description as ovp_s
FROM retail_products
LEFT join 1override on retail_products.Unique_ProdID = 1override.productid
LEFT JOIN 1inventory on retail_products.unique_prodid = 1inventory.productid
LEFT JOIN navigation_2018 on retail_products.unique_prodID = navigation_2018.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
WHERE retail_products.unique_prodid in ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) , (param 45) , (param 46) , (param 47) , (param 48) , (param 49) , (param 50) , (param 51) , (param 52) , (param 53) , (param 54) , (param 55) , (param 56) , (param 57) , (param 58) , (param 59) , (param 60) , (param 61) , (param 62) , (param 63) , (param 64) , (param 65) , (param 66) , (param 67) , (param 68) , (param 69) , (param 70) , (param 71) , (param 72) , (param 73) , (param 74) , (param 75) , (param 76) , (param 77) , (param 78) , (param 79) , (param 80) , (param 81) , (param 82) , (param 83) , (param 84) , (param 85) , (param 86) , (param 87) , (param 88) , (param 89) , (param 90) , (param 91) , (param 92) , (param 93) , (param 94) , (param 95) , (param 96) , (param 97) , (param 98) , (param 99) , (param 100) , (param 101) , (param 102) , (param 103) , (param 104) , (param 105) , (param 106) , (param 107) , (param 108) , (param 109) , (param 110) , (param 111) , (param 112) , (param 113) , (param 114) , (param 115) , (param 116) , (param 117) , (param 118) , (param 119) , (param 120) , (param 121) , (param 122) , (param 123) , (param 124) , (param 125) , (param 126) , (param 127) , (param 128) , (param 129) , (param 130) , (param 131) )
AND retail_products.discontinued = 0
AND ((retail_products.store_exclusive is NULL) or (retail_products.store_exclusive = 1))
AND retail_products.unique_prodid not in (select productid from 1retailer_noshow)
and cat_sub_2017.category in ( (param 132) )
ORDER BY FIND_IN_SET(retail_products.UNIQUE_PRODID, 'DelkDCFXP256R54,AngeATOMXMINI1000PK,SandSDSDXXD256GANC,SandSDSDUNB128GAN6,DelkDCFXBB650,LexaLCXEXSL256GRNE,LexaLSD2000256GBNN,PromPRO2579,LexaLCXEXPR128GRNE,AngeAVP1T0CFXA,LexaLCXEXSL512GRNE,DelkDCFXBP650G4,DelkDCFXBP512G4,DelkDCFXBP325G4,DelkDCFXBP2TBG4,DelkDCFXBP256G4,DelkDCFXBP1TBG4,DelkDCFXBP165G4,DelkDCFXBP128G4,DelkDCFXBP13TG4,SanDSDSDUNB064GAN6,SanDSDSDXVT032GANC,DelkDCFXB150R56,SonySFG128TT1,DelkDCFXP128R56,SanDSDSDXXU064GANC,SanDSDSDXXD128GANC,SanDSDCFE256GANCNN,SonyCEAG640T,SonyCEAG320T,Niko27228,LexaLSD180006GB2NN,LexaLSD1800256GB2N,LexaLSD1800128GB2N,PromPRo6834,DelkDCFXBBLK75,DelkDCFXBBLK150,LexaLSD1800064GBNN,LexaLSD1800256GBNN,LexaLSD1800128GBNN,DelkDCFXBBLK650,DelkDCFXBBLK325,DelkDCFXAPWR160,DelkDCFXABLK160,SanDSDCFE064GANCNN,DelkDDSDW6331TB,SonyQDG64FJ,DelkDCFX12TB,SanDSDSQUNI256GAN6,SanDSDSDXDK032GANC,SanDSDSQUA4032GAN6,SanDSDSDXDK128GANC,Tenb636639,Tenb636638,Tenb636637,Tenb636636,Tenb636635,Tenb636634,PromPRO2514,PromPRO3807,PromPRO3810,DelkDJUGBM2TB,SanDSDSQUA4064GAN6,SANDSDSDXDK064GANC,SanDSDSDUN4032GAN6,LexaLSD256CBNA1667,SonyMRWG1T1,SanDSDCFE512GANCNN,HoodCFEX512,SonyMRWG2,SanDSDSDUNR256GAN6,PromPRO7962,HoodH15XSD264,HoodHS64GBSD2,SonyCEAG80T,SonyCEAG160T,DelkDCFX11TB,HoodCFEXR,DelkDDSDG2000256,DelkDSDBV90256,SonyCEBG512J,SonyCEBG256J,SonyCEBG128J,sandSDCFE128GANCNN,HoodCFEX256,HoodCFEX128,LEXALSD128CBNA1667,DelkDSDBV90128BX,LexaLSD64GCBNA1667,Thin740217T,DelkDSDBV9032,SONYQDG240FJ,SONYQDG120FJ,SanDSDSQXA2064GAN6,DelkDDSDW633512G,DelkDDCFST560512,DelkDDXQD120GB,DelkDDMSDBLK32GB,DelkDDSDG200064G,DelkDDMSDW66032G,DelkDDSDR16332GB,DelkDDSDBLK256GB,DelkDDSDW63332GB,DelkDDSDW63364GB,DelkDDSDW633256G,DelkDDSDW633128G,DelkDDSDB1900128,PromPRO4976,PromPRO4969,PromPRO4962,dELKDDSDG2000128,DelkDDSDB190064G,SanDSDSDXSF016GANC,SanDSDSQXVF032GAN6,DelkDDCFST560256,Gepe3864GEPE,Gepe3863,PromPRO9798,SanDSDSDUNC016GAN6,SanDSDSSDXPS480GG2,DELKDDSDBLK128GB,SanDSDCFXS032GA46,SanDSDCFXS064GA46,SanDSDCFXS128GA46,SanDSDCFXPS256GA46,SanDSDCFXPS064GA46,SanDSDCFXPS032GA46,SanDSDCFXPS128GA46,Gepe3861E,Gepe3856E,Gepe386103') |
|
Resources:
|
Browser |
claudebot |
Remote Address |
3.145.206.169 |
Referrer |
https://www.huntsphotoandvideo.com/listing.cfm?hid=1&cid=12&category=193 |
Date/Time |
18-Apr-24 05:22 PM |
|
Stack Trace
|
at cflisting2ecfm641092179._factor37(C:/WEB/HPhoto/responsive/listing.cfm:281) at cflisting2ecfm641092179.runPage(C:/WEB/HPhoto/responsive/listing.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)
|
|