Forum

Thread tagged as: Error, Runway, Shop

Shipping sub total null

Hi,

We're trying to get the checkout working properly on a Perch shop - I'm currently making final tweaks to a shop already set up by someone else.

I'm having trouble with the shipping.

To summarise, in the control panel we have two shipping zones and two methods, for example shipping zone 1, and shipping zone 2, with shipping zone 1 as the default zone, and both have UK ticked.

For shipping method we have Standard Delivery, and Same Day Delivery. Standard delivery has Shipping Zone 1 ticked as available at £50, but not shipping zone 2. Same Day Delivery has no Shipping Zone ticked so I guess this just makes this null for now, but may be added later. For both methods we have min order value of £0, and the max order value empty.

With this considered, you could say we only have one shipping method, so no real need right now for a user to select a shipping method.

On the cart template I have a row to display Shipping: <perch:shop id="shipping_without_tax" />, but this outputs as blank.

When we click to checkout from the cart (using a product with shipping required and ticked 'yes'), instead of directing to PayPal we get an error:


Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'orderShippingSubtotal' cannot be null

Can you see what we've done wrong? It's as if it cannot see a shipping method, but since there's only one choice base on the back end configuration, I would have thought that would be automatically saved. We have tried adding <?php perch_shop_shipping_method_form(); ?>, but this again is a blank select box, it's as if it cannot see the standard shipping we have set-up.

These are the diagnostics:

Perch Runway: 3.0.10, PHP: 5.6.31, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $, with PDO
Server OS: Linux, fpm-fcgi
Installed apps: content (3.0.10), assets (3.0.10), categories (3.0.10), perch_blog (5.5.1), perch_shop_orders (1.2.5), perch_shop_products (1.2.5), perch_shop (1.2.5), perch_members (1.6.2)
App runtimes: <?php $apps_list = array( 'perch_members', 'perch_shop', 'perch_blog', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /home/stotto/public_html/dev/perch
PERCH_CORE: /home/stotto/public_html/dev/perch/core
PERCH_RESFILEPATH: /home/stotto/public_html/dev/perch/resources
Image manipulation: GD
PHP limits: Max upload 16M, Max POST 16M, Memory: 128M, Total max file upload: 16M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
HTTP_HOST: dev.stotto.com
DOCUMENT_ROOT: /home/stotto/public_html/dev
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php

And this is the debug output on the checkout page:

Debug Message - Perch Runway 3.0.10
[60] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /shop/checkout, so not using routes.
Using master page: /templates/pages/checkout.php
[1] SELECT * FROM perch2_members_sessions WHERE sessionID='f3d8532e0afa09df522c7396a265a8c0d73dcc07' AND sessionHttpFootprint='019b2cf9330edf5c21170e6d9f721624dbeac561' AND sessionExpires>'2017-10-06 10:47:42' LIMIT 1
User is logged in
[1] SELECT * FROM perch2_pages WHERE pagePath='/shop/checkout' LIMIT 1
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2017-10-06 10:47:00' AND saleTo>'2017-10-06 10:47:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
Holding redirects
Checking out with paypal-express
Member ID: 8
[1] SELECT * FROM perch2_shop_customers WHERE memberID=8
[1] SELECT billingAddress, shippingAddress FROM perch2_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1741
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='5' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
no address
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='5' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
INSERT INTO perch2_shop_addresses(addressDynamicFields,addressTitle,addressSlug,addressCreated) VALUES('{\"first_name\":\"Wayne\",\"last_name\":\"Hooper\",\"address_1\":false,\"address_2\":false,\"postcode\":false,\"country\":false,\"company\":false,\"city\":false,\"customer\":\"5\",\"phone\":false,\"county\":false,\"instructions\":false}','default','default','2017-10-06 10:47:42')
[1] SELECT * FROM perch2_shop_addresses WHERE addressID='209' LIMIT 1
No ids to log.
UPDATE perch2_shop_addresses SET addressDynamicFields='{\"first_name\":\"Wayne\",\"last_name\":\"Hooper\",\"address_1\":false,\"address_2\":false,\"postcode\":false,\"country\":false,\"company\":false,\"city\":false,\"customer\":\"5\",\"phone\":false,\"county\":false,\"instructions\":false}', addressTitle='default', addressSlug='default', addressCreated='2017-10-06 10:47:42', addressFirstName='Wayne', addressLastName='Hooper', addressCompany='', addressLine1='', customerID='5', countryID='', addressUpdated='2017-10-06 10:47:42' WHERE addressID='209'
No ids to log.
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='5' AND orderID IS NULL AND countryID>0 AND addressSlug='shipping'
no address
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='5' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
INSERT INTO perch2_shop_addresses(addressDynamicFields,addressTitle,addressSlug,addressCreated) VALUES('{\"first_name\":\"Wayne\",\"last_name\":\"Hooper\",\"address_1\":false,\"address_2\":false,\"postcode\":false,\"country\":false,\"company\":false,\"city\":false,\"customer\":\"5\",\"phone\":false,\"county\":false,\"instructions\":false}','shipping','shipping','2017-10-06 10:47:42')
[1] SELECT * FROM perch2_shop_addresses WHERE addressID='210' LIMIT 1
No ids to log.
UPDATE perch2_shop_addresses SET addressDynamicFields='{\"first_name\":\"Wayne\",\"last_name\":\"Hooper\",\"address_1\":false,\"address_2\":false,\"postcode\":false,\"country\":false,\"company\":false,\"city\":false,\"customer\":\"5\",\"phone\":false,\"county\":false,\"instructions\":false}', addressTitle='shipping', addressSlug='shipping', addressCreated='2017-10-06 10:47:42', addressFirstName='Wayne', addressLastName='Hooper', addressCompany='', addressLine1='', customerID='5', countryID='', addressUpdated='2017-10-06 10:47:42' WHERE addressID='210'
No ids to log.
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_customers WHERE memberID=8
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=1741
[43] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Tax mode: inc
[1] SELECT * FROM perch2_shop_cart_items WHERE cartID=1741 ORDER BY itemID ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=806 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[0] SELECT r.rateValue FROM perch2_shop_tax_group_rates gr, perch2_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch2_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[0] SELECT r.rateValue FROM perch2_shop_tax_group_rates gr, perch2_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT billingAddress, shippingAddress FROM perch2_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1741
[1] SELECT z.* FROM perch2_shop_shipping_zones z LEFT JOIN perch2_shop_shipping_zone_countries c ON z.zoneID=c.zoneID WHERE z.zoneActive=1 AND z.zoneDeleted IS NULL AND (c.countryID=236 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[2] SELECT * FROM perch2_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=1 AND rateDeleted IS NULL ORDER BY rateValue DESC
Rejecting shipping method ‘Stotto Delivery’ because: no price available for chosen shipping zone
Rejecting shipping method ‘Stotto Same Day Delivery’ because: no price available for chosen shipping zone
[nil] SELECT * FROM perch2_shop_promotions WHERE promoFrom<='2017-10-06 10:47:00' AND promoTo>'2017-10-06 10:47:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
INSERT INTO perch2_shop_orders(orderStatus,orderGateway,orderTotal,currencyID,orderItemsSubtotal,orderItemsTax,orderItemsTotal,orderShippingSubtotal,orderShippingDiscounts,orderShippingTax,orderShippingTaxDiscounts,orderShippingTotal,orderDiscountsTotal,orderTaxDiscountsTotal,orderSubtotal,orderTaxTotal,orderItemsRefunded,orderTaxRefunded,orderShippingRefunded,orderTotalRefunded,orderTaxID,orderShippingWeight,orderCreated,orderPricing,orderDynamicFields,customerID,shippingID,orderShippingTaxRate,orderBillingAddress,orderShippingAddress) VALUES('created','paypal-express','279.00','47','279.00','0.00',279,NULL,'0.00',NULL,'0.00',NULL,'0.00','0.00',279,'0.00',0,0,0,0,NULL,'0.00','2017-10-06 10:47:42','standard','[]','5',NULL,NULL,'209','210')
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'orderShippingSubtotal' cannot be null
[1] SELECT * FROM perch2_shop_order_statuses WHERE statusKey='created' AND statusActive=1 AND statusDeleted IS NULL
[nil] SELECT * FROM perch2_shop_emails WHERE emailStatus=1 AND emailActive=1
Using template: /templates/pages/attributes/seo.html
[1] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/shop/checkout' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT pageID FROM perch2_pages WHERE pagePath='/shop/checkout' LIMIT 1
INSERT INTO perch2_content_regions(regionKey,regionPage,regionHTML,regionOptions,pageID) SELECT 'footer' AS regionKey,'/shop/checkout' AS regionPage,'<!-- Undefined content: footer -->' AS regionHTML,'' AS regionOptions,'55' AS pageID FROM (SELECT 1) AS dtable WHERE ( SELECT COUNT(*) FROM perch2_content_regions WHERE regionKey='footer' AND (regionPage='/shop/checkout' OR regionPage='*') )=0 LIMIT 1
UPDATE perch2_content_regions SET regionOrder=0 WHERE regionPage='/shop/checkout' AND regionKey='footer' LIMIT 1
Array
(
    [type] => 8
    [message] => Undefined index: shipping_tax_rate
    [file] => /home/stotto/public_html/dev/perch/addons/apps/perch_shop/lib/PerchShop_Orders.class.php
    [line] => 71
)
Debug Message - Perch Runway 3.0.10
[60] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /shop/checkout, so not using routes.
Using master page: /templates/pages/checkout.php
[1] SELECT * FROM perch2_members_sessions WHERE sessionID='f3d8532e0afa09df522c7396a265a8c0d73dcc07' AND sessionHttpFootprint='019b2cf9330edf5c21170e6d9f721624dbeac561' AND sessionExpires>'2017-10-06 10:47:42' LIMIT 1
User is logged in
[1] SELECT * FROM perch2_pages WHERE pagePath='/shop/checkout' LIMIT 1
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2017-10-06 10:47:00' AND saleTo>'2017-10-06 10:47:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
Holding redirects
Checking out with paypal-express
Member ID: 8
[1] SELECT * FROM perch2_shop_customers WHERE memberID=8
[1] SELECT billingAddress, shippingAddress FROM perch2_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1741
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='5' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
no address
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='5' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
INSERT INTO perch2_shop_addresses(addressDynamicFields,addressTitle,addressSlug,addressCreated) VALUES('{\"first_name\":\"Wayne\",\"last_name\":\"Hooper\",\"address_1\":false,\"address_2\":false,\"postcode\":false,\"country\":false,\"company\":false,\"city\":false,\"customer\":\"5\",\"phone\":false,\"county\":false,\"instructions\":false}','default','default','2017-10-06 10:47:42')
[1] SELECT * FROM perch2_shop_addresses WHERE addressID='209' LIMIT 1
No ids to log.
UPDATE perch2_shop_addresses SET addressDynamicFields='{\"first_name\":\"Wayne\",\"last_name\":\"Hooper\",\"address_1\":false,\"address_2\":false,\"postcode\":false,\"country\":false,\"company\":false,\"city\":false,\"customer\":\"5\",\"phone\":false,\"county\":false,\"instructions\":false}', addressTitle='default', addressSlug='default', addressCreated='2017-10-06 10:47:42', addressFirstName='Wayne', addressLastName='Hooper', addressCompany='', addressLine1='', customerID='5', countryID='', addressUpdated='2017-10-06 10:47:42' WHERE addressID='209'
No ids to log.
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='5' AND orderID IS NULL AND countryID>0 AND addressSlug='shipping'
no address
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='5' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
INSERT INTO perch2_shop_addresses(addressDynamicFields,addressTitle,addressSlug,addressCreated) VALUES('{\"first_name\":\"Wayne\",\"last_name\":\"Hooper\",\"address_1\":false,\"address_2\":false,\"postcode\":false,\"country\":false,\"company\":false,\"city\":false,\"customer\":\"5\",\"phone\":false,\"county\":false,\"instructions\":false}','shipping','shipping','2017-10-06 10:47:42')
[1] SELECT * FROM perch2_shop_addresses WHERE addressID='210' LIMIT 1
No ids to log.
UPDATE perch2_shop_addresses SET addressDynamicFields='{\"first_name\":\"Wayne\",\"last_name\":\"Hooper\",\"address_1\":false,\"address_2\":false,\"postcode\":false,\"country\":false,\"company\":false,\"city\":false,\"customer\":\"5\",\"phone\":false,\"county\":false,\"instructions\":false}', addressTitle='shipping', addressSlug='shipping', addressCreated='2017-10-06 10:47:42', addressFirstName='Wayne', addressLastName='Hooper', addressCompany='', addressLine1='', customerID='5', countryID='', addressUpdated='2017-10-06 10:47:42' WHERE addressID='210'
No ids to log.
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_customers WHERE memberID=8
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=1741
[43] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Tax mode: inc
[1] SELECT * FROM perch2_shop_cart_items WHERE cartID=1741 ORDER BY itemID ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=806 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[0] SELECT r.rateValue FROM perch2_shop_tax_group_rates gr, perch2_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch2_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[0] SELECT r.rateValue FROM perch2_shop_tax_group_rates gr, perch2_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=805 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=805 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=805 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[1] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=69 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='805' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='69' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT billingAddress, shippingAddress FROM perch2_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1741
[1] SELECT z.* FROM perch2_shop_shipping_zones z LEFT JOIN perch2_shop_shipping_zone_countries c ON z.zoneID=c.zoneID WHERE z.zoneActive=1 AND z.zoneDeleted IS NULL AND (c.countryID=236 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[2] SELECT * FROM perch2_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=1 AND rateDeleted IS NULL ORDER BY rateValue DESC
Rejecting shipping method ‘Stotto Delivery’ because: no price available for chosen shipping zone
Rejecting shipping method ‘Stotto Same Day Delivery’ because: no price available for chosen shipping zone
[nil] SELECT * FROM perch2_shop_promotions WHERE promoFrom<='2017-10-06 10:47:00' AND promoTo>'2017-10-06 10:47:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
[1] SELECT * FROM perch2_shop_cart WHERE cartID=1741
INSERT INTO perch2_shop_orders(orderStatus,orderGateway,orderTotal,currencyID,orderItemsSubtotal,orderItemsTax,orderItemsTotal,orderShippingSubtotal,orderShippingDiscounts,orderShippingTax,orderShippingTaxDiscounts,orderShippingTotal,orderDiscountsTotal,orderTaxDiscountsTotal,orderSubtotal,orderTaxTotal,orderItemsRefunded,orderTaxRefunded,orderShippingRefunded,orderTotalRefunded,orderTaxID,orderShippingWeight,orderCreated,orderPricing,orderDynamicFields,customerID,shippingID,orderShippingTaxRate,orderBillingAddress,orderShippingAddress) VALUES('created','paypal-express','279.00','47','279.00','0.00',279,NULL,'0.00',NULL,'0.00',NULL,'0.00','0.00',279,'0.00',0,0,0,0,NULL,'0.00','2017-10-06 10:47:42','standard','[]','5',NULL,NULL,'209','210')
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'orderShippingSubtotal' cannot be null
[1] SELECT * FROM perch2_shop_order_statuses WHERE statusKey='created' AND statusActive=1 AND statusDeleted IS NULL
[nil] SELECT * FROM perch2_shop_emails WHERE emailStatus=1 AND emailActive=1
Using template: /templates/pages/attributes/seo.html
[1] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/shop/checkout' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT pageID FROM perch2_pages WHERE pagePath='/shop/checkout' LIMIT 1
INSERT INTO perch2_content_regions(regionKey,regionPage,regionHTML,regionOptions,pageID) SELECT 'footer' AS regionKey,'/shop/checkout' AS regionPage,'<!-- Undefined content: footer -->' AS regionHTML,'' AS regionOptions,'55' AS pageID FROM (SELECT 1) AS dtable WHERE ( SELECT COUNT(*) FROM perch2_content_regions WHERE regionKey='footer' AND (regionPage='/shop/checkout' OR regionPage='*') )=0 LIMIT 1
UPDATE perch2_content_regions SET regionOrder=0 WHERE regionPage='/shop/checkout' AND regionKey='footer' LIMIT 1
Array
(
    [type] => 8
    [message] => Undefined index: shipping_tax_rate
    [file] => /home/stotto/public_html/dev/perch/addons/apps/perch_shop/lib/PerchShop_Orders.class.php
    [line] => 71
)
Request time: 0.2163
Process time: 0.2161
Memory: 8.6736
Array
(
    [type] => 8
    [message] => Undefined index: shipping_tax_rate
    [file] => /home/stotto/public_html/dev/perch/addons/apps/perch_shop/lib/PerchShop_Orders.class.php
    [line] => 71
)

Many thanks, Alex
Alex Bennett

Alex Bennett 0 points

  • 3 years ago