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) , (param 132) , (param 133) , (param 134) , (param 135) , (param 136) , (param 137) , (param 138) , (param 139) , (param 140) , (param 141) , (param 142) , (param 143) , (param 144) , (param 145) , (param 146) , (param 147) , (param 148) , (param 149) , (param 150) , (param 151) , (param 152) , (param 153) , (param 154) , (param 155) , (param 156) , (param 157) , (param 158) , (param 159) , (param 160) , (param 161) , (param 162) , (param 163) , (param 164) , (param 165) , (param 166) , (param 167) , (param 168) , (param 169) , (param 170) , (param 171) , (param 172) , (param 173) , (param 174) , (param 175) , (param 176) , (param 177) , (param 178) , (param 179) , (param 180) , (param 181) , (param 182) , (param 183) , (param 184) , (param 185) , (param 186) , (param 187) , (param 188) , (param 189) , (param 190) , (param 191) , (param 192) , (param 193) , (param 194) , (param 195) , (param 196) , (param 197) , (param 198) , (param 199) , (param 200) , (param 201) , (param 202) , (param 203) , (param 204) , (param 205) , (param 206) , (param 207) , (param 208) , (param 209) , (param 210) , (param 211) , (param 212) , (param 213) , (param 214) , (param 215) , (param 216) , (param 217) , (param 218) , (param 219) , (param 220) , (param 221) , (param 222) , (param 223) , (param 224) , (param 225) , (param 226) , (param 227) , (param 228) , (param 229) , (param 230) , (param 231) , (param 232) , (param 233) , (param 234) , (param 235) , (param 236) , (param 237) , (param 238) , (param 239) , (param 240) , (param 241) , (param 242) , (param 243) , (param 244) , (param 245) , (param 246) , (param 247) , (param 248) , (param 249) , (param 250) , (param 251) , (param 252) , (param 253) , (param 254) , (param 255) , (param 256) , (param 257) , (param 258) , (param 259) , (param 260) , (param 261) , (param 262) , (param 263) , (param 264) , (param 265) , (param 266) , (param 267) , (param 268) , (param 269) , (param 270) , (param 271) , (param 272) , (param 273) , (param 274) , (param 275) , (param 276) , (param 277) , (param 278) , (param 279) , (param 280) , (param 281) , (param 282) , (param 283) , (param 284) , (param 285) , (param 286) , (param 287) , (param 288) , (param 289) , (param 290) , (param 291) , (param 292) , (param 293) , (param 294) , (param 295) , (param 296) , (param 297) , (param 298) , (param 299) , (param 300) , (param 301) , (param 302) , (param 303) , (param 304) , (param 305) , (param 306) , (param 307) , (param 308) , (param 309) , (param 310) , (param 311) , (param 312) , (param 313) , (param 314) , (param 315) , (param 316) , (param 317) , (param 318) , (param 319) , (param 320) , (param 321) , (param 322) , (param 323) , (param 324) , (param 325) , (param 326) , (param 327) , (param 328) , (param 329) , (param 330) , (param 331) , (param 332) , (param 333) , (param 334) , (param 335) , (param 336) , (param 337) , (param 338) , (param 339) , (param 340) , (param 341) , (param 342) , (param 343) , (param 344) , (param 345) , (param 346) , (param 347) , (param 348) , (param 349) , (param 350) , (param 351) , (param 352) , (param 353) , (param 354) , (param 355) , (param 356) , (param 357) , (param 358) , (param 359) , (param 360) , (param 361) , (param 362) , (param 363) , (param 364) , (param 365) , (param 366) , (param 367) , (param 368) , (param 369) , (param 370) , (param 371) , (param 372) , (param 373) , (param 374) , (param 375) , (param 376) , (param 377) , (param 378) , (param 379) , (param 380) , (param 381) , (param 382) , (param 383) , (param 384) , (param 385) , (param 386) , (param 387) , (param 388) , (param 389) , (param 390) , (param 391) , (param 392) , (param 393) , (param 394) , (param 395) , (param 396) , (param 397) , (param 398) , (param 399) , (param 400) , (param 401) , (param 402) , (param 403) , (param 404) , (param 405) , (param 406) , (param 407) , (param 408) , (param 409) , (param 410) , (param 411) , (param 412) , (param 413) , (param 414) , (param 415) , (param 416) , (param 417) , (param 418) , (param 419) , (param 420) , (param 421) , (param 422) , (param 423) , (param 424) , (param 425) , (param 426) , (param 427) , (param 428) , (param 429) , (param 430) , (param 431) , (param 432) , (param 433) , (param 434) , (param 435) , (param 436) , (param 437) , (param 438) , (param 439) , (param 440) , (param 441) , (param 442) , (param 443) , (param 444) , (param 445) , (param 446) , (param 447) , (param 448) , (param 449) , (param 450) , (param 451) , (param 452) , (param 453) , (param 454) , (param 455) , (param 456) , (param 457) , (param 458) , (param 459) , (param 460) , (param 461) , (param 462) , (param 463) , (param 464) , (param 465) , (param 466) , (param 467) , (param 468) , (param 469) , (param 470) , (param 471) , (param 472) , (param 473) , (param 474) , (param 475) , (param 476) , (param 477) , (param 478) , (param 479) , (param 480) , (param 481) , (param 482) , (param 483) , (param 484) , (param 485) , (param 486) , (param 487) , (param 488) , (param 489) , (param 490) , (param 491) , (param 492) , (param 493) , (param 494) , (param 495) , (param 496) , (param 497) , (param 498) , (param 499) , (param 500) , (param 501) , (param 502) , (param 503) , (param 504) , (param 505) , (param 506) , (param 507) , (param 508) , (param 509) , (param 510) , (param 511) , (param 512) , (param 513) , (param 514) , (param 515) )
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)
ORDER BY FIND_IN_SET(retail_products.UNIQUE_PRODID, 'GodoS2,KupoKG087111,KupoKG087211,KupoKG087311,KupoKG087411,West4663WEST,West4662WEST,PromPRO3815,GoDoXPROIIS,GoDoXPROIIP,GoDoXPROIIO,GoDoXPROIIN,GoDoXPROIIF,GoDoXPROIIC,NanlPT15C4KIT,West4732WEST,West4733WEST,West4713MWEST,West4712SWEST,West4773SWEST,West4772SWEST,West4771SWEST,West4785WEST,West4782WEST,PromPRO5742,West4752WEST,West4749WEST,West4917WEST,West4933WEST,GodoMFAR,GodoMF11T,GodoMF11C,GoDoLB02,GoDoLB01,GoDoARRKIT,ExpoRRFKIT1,ExpoRRFKIT2,ExpoRRFGELCC,LumeLCSCUP11,AvenE250,AvenE200,AvenA2033LCB,AvenA2030DKIT,AputAPK0179A80,AputAPQ0148A30,AputAPD0126A2C,MagMMMSHOE02,MagMMMRING02,MagMSHADP1420,MagMMMGRIPR02,MagMMMGRIDR02,nanlPJFMMLENS36,NanlPJFZ60LENS19,NANLASGBFMMSET1,LastLLLS2701,LastLLLR8824,GodoWB100,AvenF825,AvenF800,AvenE700,AvenA2030DCBKIT,LastLLLB1120,LastLLLA8446,GodoTT685IIO,West4745WEST,West4743WEST,West4742WEST,West2544WEST,West2543WEST,NANLASGBFMMSET2,nanlPJFMMAI,nanlPJFMM19,NanlBTVBC148V26V,NanlBDMPII11C,GeekC1S,GeekC1N,GeekC1C,Cano4944C001,ManfMBLBAG110,ManfMBLBAG90,LumoLP729,SavaTGAFFERW,SavaTGAFFERG,SavaSC100,PromPRO1036,West5633WEST,West5634WEST,ExpoROGUEGELCCV3,ElinEL19338,Seko401333,West578SKWEST,LitrLITRASBA,NanlBHFZ60V,NANLASBAFMM,Prof101128,Prof101127,Prof101052,Prof101051,Prof101050,Prof101049,Prof101048,Prof101047,Prof101046,Prof101045,Prof101044,Prof101043,Prof101042,Prof101041,Prof101040,NanlFL20G,NanlHDT122BHG,PhotPH88218,RotoRLNEOBD,PromPRO6845,PromPRO6733,Manf5002BL,ManfMS0490C,Pock13369SONY,NanLRC1,West7570WEST,West2080WEST,West4710WEST,West4709WEST,West4708WEST,West4711WEST,West4702WEST,NanLCN18X,Thin730532T,Prof901314,Prof901318,Prof901316,Prof901312,Prof901310,GodoXPROC,Prof100498,GodoX1RN,GodoX1RC,OLYMV327150BW000,OLYMV327140BW000,West5231WEST,Seko401626,PromPRO2630,NissNDMG10KC,NissNDMG10KS,NissNDMG10KKN,NissNDMG10KFT,NissNDMG10KFJ,DotLRS0452,DOTLRS0450,CustCBDIGITALT,CustCBDIGITALS,GodoVB18,GodoWB87,GodoX1RS,West2523WEST,West2522WEST,West2521WEST,Prof100440,ManfMBPLLW992,ElinEL19371,MiopMIOPSMDS2,MiopMIOPSMDS1,MiopMIOPSMDSA1,MiopMIOPSMDP1,MiopMIOPSMDO1,MiopMIOPSMDN3,MiopMIOPSMDN2,MiopMIOPSMDN1,MiopMIOPSMDF1,MiopMIOPSMDC2,MiopMIOPSMDC1,ManfM035VRUS,Prof901016,Prof901017,Prof901013,Prof901027,PromPRO8644,PromPRO8630,PromPRO5151,SonyFARG1,SonyFAEBA1,MagMMMTRBND3PK,MagMMMSTGEL02,MagMMMSNOOT01,MagMMMGRID02,MagMMMGELWALL02,MagMMMARGEL02,NissNDA10SS,NissNDA10SN,NissNDA10SFT,NissNDA10SFJ,NissNDA10SC,PromPRO4234,PromPRO1154,PromPRO6305,LastLLLB1121,LastLLLS2601,LastLLLS2603,LastLLLS2604,PromPRO5493,ElinEL19369,ElinEL19368,BoweBW7697,BoweBW7698,PhotPH89069,PhotPH89067,PhotPH89072,SonyVMCMM1,SonyFAWRR1,SonyFAWRC1M,BOWEBW3967,Sava601212,RadiJR2RC,Radi890112,Radi890115,RadiPXT,PromPRO3270,PromPRO6476,Chim6010Chimera,Chim2800OP,GaryGFLSCSMWE,GaryGFSSNOOT,GaryGFLSCMP,GaryGFLSCSMFC,GaryGFCOLRFKIT,GaryGFLSCSM,ManfMLFILTERCOL,ManfMLFILTERCLS,ManfMLBALL,Manf244ADPT58,LumiLQ122S,LumiLQ121A,LumiLQ108S,LumiLQ107S,LumiLQ101S,TethRS713,PromPRO5132,YongYN622NKIT,YongYN622CKIT,ExpoROGUEGRID2,Manf1052BAC3,Cano0588C001,Cano0587C001,Rosc110126120001,EXPOROGUEGELG,EXPOROGUEGELU,West7413WEST,KupoKG701511,KupoKG100211,CameCCCC001,West301p,WEST2223WEST,DINK3266DINKUM,DINK3211DINKUM,PhotION,PromPRO4218,PromPRO4211,Rosc1010RFHLLKIT,GaryGFPUFPLUSWS,GaryGFPUFPLUS,GaryGFPUFPLUSSONY,GaryGFPUFPLSC,west268WEST,EXPOROGUESAFARI,GaryLSUHALF,GaryLSUCloud,PhotPH87520,PromPRO9433,PhotPH15653,TethTTA1MBLK,LensFLASHBAND,VisuGT4567,VisuGT1111,VisuGT1123,GaryGFLSDOM2,GaryGFLSCSNOOTG,GaryGFLSCSNOOT,Hild4001,Niko4979,Hild3001,Hild1001,PromPRO2003,Hass3053393,LastLLLR7228,LastLLLS2462,LastLLLS2471L,StofOMET,Cano5743B002,Niko27046,LastLLLA2457JM,Pock9357700178,Niko3616,PromPRO9279,StofOMEU,StofOC700GL,PromPRO9188,PromPRO9202,PromPRO9195,PromPRO9181,PromPRO9167,PromPRO9174,PromPRO6332,PromPRO9657,GaryPUFSONY,Esse9815900228,Esse9815900229,Esse9815900225,QuanMKZ9,PromPRO7928,PromPRO7956,PromPRO7921,PromPRO7704,PromPRO8306,PromPRO7697,PromPRO7676,StofOM700,PromPRO7991,GaryLSUBASIC,QuanSD7,CustCBFOLDINGT,CustCBFOLDINGS,PromPRO6339,DotLRSHCSET,StofOMMZ80,QuanT3US,QuanCZ2,QuanCKE2,InteSTR128,QuanCM5,PromPRO4708,PromPRO4666,PromPRO4673,PromPRO8960,InteSTR111,HONLHONLFILTER5,HONLHONLFILTER4,HONLHONLFILTER1,SigmF30S26,LastLLLA2430,Boot5538825,NovoFLASHGRIFF,StofOMHV58,Cano2387A001,Cano3563B001,GaryGFLSUPS,GaryLSUSTART,StofOMEV,Manf026,HONLHONLFILTER3,HONLHONLFILTER2,HONLHONLSS,HONLHONLGRID8,HONLHONLGRID4,HONLHONLGOBO,PromPRO2167,LoweE127,KirkFB8A,KirkFB8,KirkFB6,QuanQF63B,QuanQF61B,QuanQF60B,QuanCCQ8,WimbF2MACRO,StofOM900,BescX672,Manf262,Manf038,Manf034,Manf033,Manf032,Manf018,Manf016,Manf330B,Manf2909,Manf272B,Manf195,Manf173B,Manf172,Manf158,Manf152,Manf146CS,Manf143N,Manf142CS,Manf142ABS,Manf122B,Manf120DF,Manf098SHB,Manf085BSL,Manf032BASEB,Manf032BASE,Manf025TM,Manf425B,Manf241S,Manf153,Manf146B,Manf143S,Manf143A,Manf142B,Manf111BSU,Manf099B,Manf098B,Manf094,Manf091MCR,Manf077,Manf066,Manf061RA,Manf061,Manf039,Manf03614,Manf034B,Manf033B,Manf032SPL,Manf032B,Manf027,Manf023,Manf01438,LastLLLB8858,BoweBW1790,GaryINVDOM,LensLCFKSN,LensLCFKM4,LensLCFKFG,LensLCFKBK,LensLCBKSN,LensLCBKM4,LensLCBKFG,LensLCBKBK,DotLRS3997,PhotSCB9060SPR,StofOMF1,QuanTSC,QuanNX,QuanQF62BS,QuanCD30,Manf2880,CustCMP,Phot8050B6,DotLRS4012C,DotLRS0412N,DotLRS0410N,DotLRS0410C,MattB350580,StofOM400,GaryCHRDOM,GaryAMD25,WimbM8,QuanFW25,SamiCSA843,StofOCEYGR,StofOC600SET,StofOCEWGR,StofOCCBGL,StofOMEW,VisuFX4,VisuFX3,Niko4765,Niko4766,StofTWUNI,StofTW285,StofOMUNI,StofOMSB5,Sto-OMSB16,StofOMPZ8,StofOMPZ4,StofOMMZ6,StofOMMZ3,StofOMEZ,StofOMEY,StofOMEX,StofOMCT60,StofOMCT45,StofOMC,StofOMB,StofOM600,StofOM522,StofOM300T,StofOCSBGL,StofOCEYGL,StofOCEXGL,Seko401624,QuanYDC6,QuanYDC30,QuanXG2,QuanXDC4,QuanXDC2,QuanXB5,QuanQF67A,QuanQF66,QuanQF64,QuanQF62BG,QuanQF32UV,QuanQF30,QuanQF19,QuanQB26,QuanMZ2,QuanMKZ3,QuanFW89,QuanFW7Q,PROF100607,Pock804301,PhotPL1250SC,PhotFVSL500,PhotFVSL1000,InteINT411,Niko4731,LumiLQ051D,Cano2829A001,Manf143BKT,AvenD220,AvenD200B,Stro300100,Sunp0440N,Sunp040N,Sunp040C') |
|
Resources:
|
Browser |
claudebot |
Remote Address |
3.135.202.224 |
Referrer |
https://www.huntsphotoandvideo.com/listing.cfm?sortby=HTL&startrow=1&hid=3&cid=8&manufacturer=RadioPopper |
Date/Time |
18-Apr-24 05:21 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)
|
|