Melrose, MA  |  Cambridge, MA   |  Boston, MA  |  Holyoke, MA  |   Hanover, MA  |  Manchester, NH  |   S.Portland, ME  |  Providence, RI
Click to go back to Home Page
| My Account | Specials | Customer Service | Shopping Cart

Place Your Pre Order Today

This is your chance to get your hands on newly announced products as soon as they start to ship. A few times each year manufacturers announce new product that they plan to ship within a few weeks or a few months. As soon as new products are announced we will make them available for pre-order to help reduce the chance that tight product supplies leave you wanting.

When you place a pre-order your credit-card will not be charged. You are simply putting your name in our que. Your credit-card is required to hold your position, but we will only charge it when your order is shipped.

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/Templates/NewProducts/A_Preorder.cfm: line 56
Called from C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm: line 2
Called from C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm: line 1
Called from C:/WEB/HPhoto/pre_order.cfm: line 19
Called from C:/WEB/HPhoto/CFC/eretail_vendorresult.cfc: line 176
Called from C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm: line 56
Called from C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm: line 2
Called from C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm: line 1
Called from C:/WEB/HPhoto/pre_order.cfm: line 19
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 retail_products.manufacturer IN ( (param 2) ) AND retail_products.manufacturer IN ( (param 3) ) and 1override.preorder = (param 4) order by sell_price asc Limit 0,10;
Resources:

Browser   claudebot
Remote Address   54.152.77.92
Referrer  
Date/Time   28-Mar-24 11:41 AM
Stack Trace
at cferetail_vendorresult2ecfc164534590$funcGET.runFunction(C:/WEB/HPhoto/CFC/eretail_vendorresult.cfc:176) at cfA_Preorder2ecfm2084963892._factor6(C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm:56) at cfA_Preorder2ecfm2084963892._factor20(C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm:2) at cfA_Preorder2ecfm2084963892.runPage(C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm:1) at cfpre_order2ecfm585106247.runPage(C:/WEB/HPhoto/pre_order.cfm:19) at cferetail_vendorresult2ecfc164534590$funcGET.runFunction(C:/WEB/HPhoto/CFC/eretail_vendorresult.cfc:176) at cfA_Preorder2ecfm2084963892._factor6(C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm:56) at cfA_Preorder2ecfm2084963892._factor20(C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm:2) at cfA_Preorder2ecfm2084963892.runPage(C:/WEB/HPhoto/Templates/NewProducts/A_Preorder.cfm:1) at cfpre_order2ecfm585106247.runPage(C:/WEB/HPhoto/pre_order.cfm:19)

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 cfA_Preorder2ecfm2084963892._factor6(C:\WEB\HPhoto\Templates\NewProducts\A_Preorder.cfm:56)
	at cfA_Preorder2ecfm2084963892._factor20(C:\WEB\HPhoto\Templates\NewProducts\A_Preorder.cfm:2)
	at cfA_Preorder2ecfm2084963892.runPage(C:\WEB\HPhoto\Templates\NewProducts\A_Preorder.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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfpre_order2ecfm585106247.runPage(C:\WEB\HPhoto\pre_order.cfm:19)
	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)