CF_eConstruct ALERT!

Message: File eConstruct_appGlobals.cfm is missing. Process aborted.

Consult your documentation for help.
insert into Customers(customerid, saleDate, memberid, cfid, ship_fname, ship_lname, ship_phone, ship_company, ship_address, ship_city, ship_state, ship_zip, ship_country, bill_fname, bill_lname, bill_phone, bill_fax, bill_email, bill_company, bill_address, bill_city, bill_state, bill_zip, bill_country, credit_card_no, credit_card_expdate, shipVia, shipStatus, ooc, ooc_charge, void, returned, emailOffers, cardtype, paymenttype, processor, military_unit) values ( #Max_ID#, '#todayDate#', #form.memberid#, #Client.CFID#, '#capsfname#', '#capslname#', '#form.sphone#', '#capscompany#', '#capsaddress#', '#capscity#', '#capsprovince#', '#sstate#', '#form.szip#', '#form.scountry#', '#capfname#', '#caplname#', '#form.phone#', '#form.fax#', '#form.email#', '#capcompany#', '#capaddress#', '#capcity#', '#capprovince#', '#state#', '#form.zip#', '#form.country#', '#form.cardnumber#', '#form.cardexpmonth#/#form.cardexpyear#', #form.shipvia#, 0, 0, 0.00, 0, 0, #form.emailOffers#, '#form.cardtype#', '#form.paymenttype#', '#processor#', '#military_unit#') SELECT a.*, c.CategoryID, d.Name, b.DiscountType, b.DiscountAmount, b.DiscountEndDate, b.DiscountStartDate, (select count(*) from OptionName where OptionName.ProductID = a.ProductID) AS optionCount, e.UnitPrice, e.WholesalePrice FROM (((Products a LEFT JOIN Discounts b ON a.ProductID = b.ProductID) INNER JOIN ProductsCategories c ON a.ProductID = c.ProductID) INNER JOIN Categories d ON c.CategoryID = d.CategoryID) LEFT JOIN ProductsPrice e ON a.productID = e.ProductID WHERE a.ProductID = #varBasketProductID# AND (#varBasketQuantity# >= e.QtyBeginRange and #varBasketQuantity# <= e.QtyEndRange) SELECT a.name, a.nameid, a.required FROM OptionName a INNER JOIN OptionValue b ON (a.nameID = b.nameID) and (a.productid = b.productid) WHERE a.productid = #ItemsLong.productID# GROUP BY a.name, a.nameid, a.required INSERT INTO Sales(SaleID, CustomerID, ProductID, Quantity, UnitPrice, AddCost, AddWeight, WholeSalePrice, Discounts, HandlingFee, SaleDate) VALUES(#Max_ID#, #varCustID#, #varBasketProductID#, #varBasketQuantity#, #ItemsLong.UnitPrice#, #var_AddCost#, #var_AddWeight#, #ItemsLong.WholeSalePrice#, #evaluate(ItemsLong.UnitPrice * ".1")# #evaluate(ItemsLong.UnitPrice - ItemsLong.WholeSalePrice)# #evaluate(ItemsLong.UnitPrice * memberDiscountAmount)# #memberDiscountAmount# #evaluate(ItemsLong.UnitPrice * ItemsLong.DiscountAmount)# #ItemsLong.DiscountAmount# 0 , #ItemsLong.handlingfee#, '#todayDate#') UPDATE Products SET QtyInStock = (QtyInStock - #varBasketQuantity#) WHERE ProductID = #varBasketProductID# SELECT Max(SaleID) as MaxSaleID FROM Sales WHERE CustomerID = #varCustID# AND ProductID = #varBasketProductID# INSERT INTO SalesOptions(SaleID, Options) VALUES(#getSaleID.MaxSaleID#, '#htmleditformat(varOptionTemp)#') INSERT INTO SalesOptions(SaleID, Options) VALUES(#getSaleID.MaxSaleID#, '#session.dogtagtext[index]#')

Error: #cfcatch.detail#

UPDATE OptionQtyInStock SET QtyInStock = (QtyInStock - #varBasketQuantity#) WHERE Option_ValueID_Combo = '#ArrayToList(varvalueCombo)#' SELECT Customers.customerID, Sum(sales.quantity * ((sales.unitprice - sales.discounts) + sales.addcost)) as subtotal, Sum(Sales.Quantity * (sales.discounts)) as discounts, Sum(Sales.Quantity * Sales.handlingFee) as handlingfee, Sum(case taxable when 1 then ((sales.quantity * ((sales.unitprice - sales.discounts) + sales.addcost))*#varTaxPercent#) else 0 end) as tax Sum(IIf(taxable=-1,((sales.quantity * ((sales.unitprice - sales.discounts) + sales.addcost))*#varTaxPercent#),0)) AS Tax FROM (Sales INNER JOIN Products ON Sales.ProductID = Products.ProductID) INNER JOIN Customers ON Sales.CustomerID = Customers.customerID WHERE Sales.CustomerID = #varCustID# GROUP BY Customers.customerID update Customers set subtotal = #getTotals.subtotal#, discounts = #getTotals.Discounts#, tax = #getTotals.tax#, shipping = #varShipCost#, handlingFee = #getTotals.handlingFee#, shipVia = #varShipVia#, ooc = #ooc#, ooc_charge = #ooc_charge#, statementNo = 'INV-#vRandomValue#-#varCustID#', totalAmount = #varTotalAmount#, balance = #varTotalAmount# where customerID = #varCustID#

ALERT!

eConstruct&##153; Error!

Reason: An error occurred while processing the eConstruct_v6.cfm file!


Error Message: [ #cfcatch.message# ]

Server Name: #cgi.server_name#
Server Port: #cgi.server_port#
Remote Host: #cgi.remote_host#
Remote Address: #cgi.remote_addr#

Call Advanced Commerce Solutions at 1-877-493-2TEC or email us at sales@cf-acs.com for help.