Orders are not processing correctly (v. 2.9 - 2.91)
Orders are not getting loaded to the storeadmin area after someone purchases something.
-
Open the finish.php file in the /go/ folder.
-
Add a single quote in front of the word $message to the order insert query by changing:
$insquery = "INSERT INTO " .SB_DB_PREFIX ."_orders (OrderNumber, IPAddress, OrderDate, Method, Discount, Subtotal, Shipping, Tax, Total, ShippingZone, InvName, InvCompany, InvAddress, InvCity, InvState, InvZip, InvCountry, Email, Phone, Fax, ShipName, ShipAddress, ShipCity, ShipState, ShipZip, ShipCountry, ShipPhone, Extra, SessData, Voucher, VoucherVal, Currency, GiftVCode, GiftVAmount, GiftVouchers, PayData, ShippingCalc, Message, Status) VALUES ('$id', '$ip', '$today', '$method', '$discount', '$subtotal', '$shipping', '$tax', '$total', '$shippingzone', '$invname', '$invcompany', '$invaddress', '$invcity', '$invstate', '$invzip', '$invcountry', '$email', '$tel', '$fax', '$shipname', '$shipaddress', '$shipcity', '$shipstate', '$shipzip', '$shipcountry', '$del_tel', '$extrainfo', '$sd', '$voucher', '$vval', '$currency', '$giftvcode', '$giftvamount', '$giftvouchers', '$pay_data', '$shipping_calc', $message', 'On Order')";to:
$insquery = "INSERT INTO " .SB_DB_PREFIX ."_orders (OrderNumber, IPAddress, OrderDate, Method, Discount, Subtotal, Shipping, Tax, Total, ShippingZone, InvName, InvCompany, InvAddress, InvCity, InvState, InvZip, InvCountry, Email, Phone, Fax, ShipName, ShipAddress, ShipCity, ShipState, ShipZip, ShipCountry, ShipPhone, Extra, SessData, Voucher, VoucherVal, Currency, GiftVCode, GiftVAmount, GiftVouchers, PayData, ShippingCalc, Message, Status) VALUES ('$id', '$ip', '$today', '$method', '$discount', '$subtotal', '$shipping', '$tax', '$total', '$shippingzone', '$invname', '$invcompany', '$invaddress', '$invcity', '$invstate', '$invzip', '$invcountry', '$email', '$tel', '$fax', '$shipname', '$shipaddress', '$shipcity', '$shipstate', '$shipzip', '$shipcountry', '$del_tel', '$extrainfo', '$sd', '$voucher', '$vval', '$currency', '$giftvcode', '$giftvamount', '$giftvouchers', '$pay_data', '$shipping_calc', '$message', 'On Order')";