Hunt's Photo & Video
Model #, Item Name

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
 
The error occurred in C:/WEB/HPhoto/cfc/eretail_vendorresult.cfc: line 176
Called from C:/WEB/HPhoto/iphone/category.cfm: line 199
Called from C:/WEB/HPhoto/iphone/category.cfm: line 39
Called from C:/WEB/HPhoto/iphone/category.cfm: line 1
Called from C:/WEB/HPhoto/cfc/eretail_vendorresult.cfc: line 176
Called from C:/WEB/HPhoto/iphone/category.cfm: line 199
Called from C:/WEB/HPhoto/iphone/category.cfm: line 39
Called from C:/WEB/HPhoto/iphone/category.cfm: line 1
 
174 :                  order by navigation_2018.headerid
175 :             </cfif>
176 : 			Limit #start#,#disp#;
177 : 			</cfquery>
178 :
SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   eretail
VENDORERRORCODE   1041
SQL   Select retail_products.id, retail_products.productid, retail_products.unique_prodid, retail_products.Manufacturer, retail_products.retail_price, retail_products.hide, retail_products.MAP, retail_products.ProductName, retail_products.description2, retail_products.specifications, retail_products.store_exclusive, retail_products.Fronttext, retail_products.description1, retail_products.longdescription, retail_products.graphic, retail_products.firstsaledate, retail_products.Weight, retail_products.BundleInclude, retail_products.preorder, retail_products.upc, retail_products.date as livedate, 1override.LongDescription_Add, 1override.dropship, 1override.special_order, 1override.keywords as override_keywords, 1override.Compatible as override_Compatible, 1override.longdescription as override_longdescription, 1override.specifications as override_specifications, 1override.BundleInclude as override_BundleInclude, 1override.graphic as override_graphic, 1override.Fronttext as override_Fronttext, 1override.Weight as override_Weight, 1override.call_for_price, 1override.Discount_In_Cart, 1override.Discount_In_Email, 1override.Frontpage, 1override.description as override_productname, 1override.price as override_price, 1override.memberprice as override_memberprice, 1override.longdescription_add as override_longdescription_add, 1override.Preorder as override_preorder, 1inventory.weight, 1retailer_noshow.productid, 1retailer_noshow.storeSKU, navigation_2018.classID, navigation_2018.CatSubID, navigation_2018.headerID, 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, IF(1inventory.qty_force='In',5,IF(1inventory.qty_force='Out',0,1inventory.whse1_qty)) as Total_qty FROM retail_products INNER 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 HAVING retail_products.hide is NULL AND 1retailer_noshow.productid IS NULL AND 1retailer_noshow.storeSKU IS NULL AND ((retail_products.store_exclusive is NULL) or (retail_products.store_exclusive = 1)) and navigation_2018.headerID = (param 1) and navigation_2018.catmainid IN ( (param 2) ) and navigation_2018.catsubid IN ( (param 3) ) order by navigation_2018.headerid Limit 0,10;
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.146.65.212
Referrer   http://www.huntsphotoandvideo.com/iphone/category.cfm?box=1&cid=8&category=bags%20and%20cases
Date/Time   24-Apr-24 08:54 PM
Stack Trace
at cferetail_vendorresult2ecfc164534590$funcGET.runFunction(C:/WEB/HPhoto/cfc/eretail_vendorresult.cfc:176) at cfcategory2ecfm1328512866._factor9(C:/WEB/HPhoto/iphone/category.cfm:199) at cfcategory2ecfm1328512866._factor22(C:/WEB/HPhoto/iphone/category.cfm:39) at cfcategory2ecfm1328512866.runPage(C:/WEB/HPhoto/iphone/category.cfm:1) at cferetail_vendorresult2ecfc164534590$funcGET.runFunction(C:/WEB/HPhoto/cfc/eretail_vendorresult.cfc:176) at cfcategory2ecfm1328512866._factor9(C:/WEB/HPhoto/iphone/category.cfm:199) at cfcategory2ecfm1328512866._factor22(C:/WEB/HPhoto/iphone/category.cfm:39) at cfcategory2ecfm1328512866.runPage(C:/WEB/HPhoto/iphone/category.cfm:1) 

java.sql.SQLException: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1658)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cferetail_vendorresult2ecfc164534590$funcGET.runFunction(C:\WEB\HPhoto\cfc\eretail_vendorresult.cfc:176)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:687)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4053)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4017)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472)
	at cfcategory2ecfm1328512866._factor9(C:\WEB\HPhoto\iphone\category.cfm:199)
	at cfcategory2ecfm1328512866._factor22(C:\WEB\HPhoto\iphone\category.cfm:39)
	at cfcategory2ecfm1328512866.runPage(C:\WEB\HPhoto\iphone\category.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256)
	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:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	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:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:446)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:833)