Posts by tonyastley

tonyastley · Mar 30th 2020

Code

------------------------------ here mem ------------------------------
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Details' AND (regionPage='/contact' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_name.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_description.html
Using template: /templates/pages/attributes/default.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/og_image.html
Using template: /templates/pages/attributes/og_image.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_name.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/contact_address_schema.html
[3] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/checkout' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-002-001', '000-002', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/nav_lis_only.html
[1] SELECT billingAddress, shippingAddress FROM perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=69
[1] SELECT * FROM perch3_shop_customers WHERE memberID=3
[4] SELECT * FROM perch3_shop_addresses WHERE customerID='3' AND addressDeleted IS NULL AND orderID IS NULL
[4] Using template: /addons/apps/perch_shop/templates/shop/checkout/order_address_form.html
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[4] SELECT * FROM perch3_shop_countries WHERE countryID='1' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='1' LIMIT 1
[1] SELECT billingAddress, shippingAddress FROM perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=69
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/address_block.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content//_contact_details/accreditations.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch3_pages WHERE pagePath='/foot-links' OR pageSortPath='/foot-links' LIMIT 1
[1] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/checkout' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-002-001', '000-002', '000') ORDER BY pageTreePosition DESC
[1] Using template: /templates/navigation/item.html
Request time: 0.1442
Process time: 0.1428
Memory: 5.1297
Array
(
[type] => 8
[message] => Undefined variable: siteName
[file] => /Users/tonyastley/Documents/Websites/M3_Floodtech/site-folder/kpanel/templates/layouts/siteFoot.php
[line] => 8
)

Display More

tonyastley · Mar 30th 2020

Code

Debug Message - Perch Runway 3.1.5
[28] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_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 perch3_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/shop/checkout.php
[55] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/checkout' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=69
[1] SELECT * FROM perch3_shop_cart WHERE cartID=69
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2020-03-30 12:06:00' AND saleTo>'2020-03-30 12:06:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
[1] SELECT * FROM perch3_members WHERE memberAuthType='native' AND memberPassword IS NOT NULL AND memberEmail='tony@kingsfordcreative.co.uk' AND memberStatus='active' AND (memberExpires IS NULL OR memberExpires>'2020-03-30 12:06:55') LIMIT 1
Password is ok.
[1] SELECT * FROM perch3_members WHERE memberAuthType='native' AND memberAuthID='3' LIMIT 1
log them in
[0] SELECT t.tag FROM perch3_members_tags t, perch3_members_member_tags mt WHERE t.tagID=mt.tagID AND mt.memberID='3' AND (mt.tagExpires IS NULL OR mt.tagExpires>'2020-03-30 12:06:00')
INSERT INTO perch3_members_sessions(sessionID,sessionExpires,sessionHttpFootprint,memberID,sessionData) VALUES('8c755bae2ca8267f5198d9f523192d5eb62acc6a','2020-04-04 12:06:55','01bdbd4c6bfc0a74f7a9abdd52a8f5c7ba8b1dec','3','{\"first_name\":\"Tony\",\"last_name\":\"Astley\",\"memberID\":\"3\",\"memberAuthType\":\"native\",\"memberAuthID\":\"3\",\"memberEmail\":\"tony@kingsfordcreative.co.uk\",\"memberStatus\":\"active\",\"memberCreated\":\"2020-03-20 09:16:28\",\"memberExpires\":null,\"tags\":[],\"token\":\"c2e95d31429312d4fb26eab6c9316548c5a20275\"}')
DELETE FROM perch3_members_sessions WHERE sessionExpires < '2020-03-30 12:06:55'
[1] SELECT * FROM perch3_members_sessions WHERE sessionID='8c755bae2ca8267f5198d9f523192d5eb62acc6a' AND sessionHttpFootprint='01bdbd4c6bfc0a74f7a9abdd52a8f5c7ba8b1dec' AND sessionExpires>'2020-03-30 12:06:55' LIMIT 1
User is logged in
UPDATE perch3_shop_cart SET memberID='3' WHERE cartID='69'
[1] SELECT * FROM perch3_shop_customers WHERE memberID=3
UPDATE perch3_shop_cart SET customerID='3' WHERE cartID='69'
------------------------------ setting loc from adr default ------------------------------
default
[1] SELECT * FROM perch3_shop_customers WHERE memberID=3
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='3' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationDeleted IS NULL AND ((countryID=236 AND regionID IS NULL) OR locationIsDefault=1) ORDER BY locationIsDefault ASC LIMIT 1
UPDATE perch3_shop_cart SET locationID='1' WHERE cartID='69'
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=69
[1] SELECT * FROM perch3_shop_cart WHERE cartID=69
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_customers WHERE memberID=3
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=69
Tax mode: exc
[1] SELECT * FROM perch3_shop_cart_items WHERE cartID=69 ORDER BY itemID ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=76 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2020-03-30 12:06:00' AND promoTo>'2020-03-30 12:06:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
Promo (Tester Discount) skipped: discount code not applied.
UPDATE perch3_shop_cart SET cartTotalItems='1', cartTotalProducts='1', cartTotalWithTax='0.00', cartTotalWithoutTax='0.00' WHERE cartID='69'

Display More

tonyastley · Mar 30th 2020

Code

Debug Message - Perch Runway 3.1.5
[28] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_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 perch3_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/shop/checkout.php
[55] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/checkout' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=69
[1] SELECT * FROM perch3_shop_cart WHERE cartID=69
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2020-03-30 12:06:00' AND saleTo>'2020-03-30 12:06:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
[1] SELECT * FROM perch3_members WHERE memberAuthType='native' AND memberPassword IS NOT NULL AND memberEmail='tony@kingsfordcreative.co.uk' AND memberStatus='active' AND (memberExpires IS NULL OR memberExpires>'2020-03-30 12:06:55') LIMIT 1
Password is ok.
[1] SELECT * FROM perch3_members WHERE memberAuthType='native' AND memberAuthID='3' LIMIT 1
log them in
[0] SELECT t.tag FROM perch3_members_tags t, perch3_members_member_tags mt WHERE t.tagID=mt.tagID AND mt.memberID='3' AND (mt.tagExpires IS NULL OR mt.tagExpires>'2020-03-30 12:06:00')
INSERT INTO perch3_members_sessions(sessionID,sessionExpires,sessionHttpFootprint,memberID,sessionData) VALUES('8c755bae2ca8267f5198d9f523192d5eb62acc6a','2020-04-04 12:06:55','01bdbd4c6bfc0a74f7a9abdd52a8f5c7ba8b1dec','3','{\"first_name\":\"Tony\",\"last_name\":\"Astley\",\"memberID\":\"3\",\"memberAuthType\":\"native\",\"memberAuthID\":\"3\",\"memberEmail\":\"tony@kingsfordcreative.co.uk\",\"memberStatus\":\"active\",\"memberCreated\":\"2020-03-20 09:16:28\",\"memberExpires\":null,\"tags\":[],\"token\":\"c2e95d31429312d4fb26eab6c9316548c5a20275\"}')
DELETE FROM perch3_members_sessions WHERE sessionExpires < '2020-03-30 12:06:55'
[1] SELECT * FROM perch3_members_sessions WHERE sessionID='8c755bae2ca8267f5198d9f523192d5eb62acc6a' AND sessionHttpFootprint='01bdbd4c6bfc0a74f7a9abdd52a8f5c7ba8b1dec' AND sessionExpires>'2020-03-30 12:06:55' LIMIT 1
User is logged in
UPDATE perch3_shop_cart SET memberID='3' WHERE cartID='69'
[1] SELECT * FROM perch3_shop_customers WHERE memberID=3
UPDATE perch3_shop_cart SET customerID='3' WHERE cartID='69'
------------------------------ setting loc from adr default ------------------------------
default
[1] SELECT * FROM perch3_shop_customers WHERE memberID=3
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='3' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationDeleted IS NULL AND ((countryID=236 AND regionID IS NULL) OR locationIsDefault=1) ORDER BY locationIsDefault ASC LIMIT 1
UPDATE perch3_shop_cart SET locationID='1' WHERE cartID='69'
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=69
[1] SELECT * FROM perch3_shop_cart WHERE cartID=69
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_customers WHERE memberID=3
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=69
Tax mode: exc
[1] SELECT * FROM perch3_shop_cart_items WHERE cartID=69 ORDER BY itemID ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=76 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2020-03-30 12:06:00' AND promoTo>'2020-03-30 12:06:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
Promo (Tester Discount) skipped: discount code not applied.
UPDATE perch3_shop_cart SET cartTotalItems='1', cartTotalProducts='1', cartTotalWithTax='0.00', cartTotalWithoutTax='0.00' WHERE cartID='69'
------------------------------ here mem ------------------------------
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Details' AND (regionPage='/contact' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_name.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_description.html
Using template: /templates/pages/attributes/default.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/og_image.html
Using template: /templates/pages/attributes/og_image.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/site_name.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=15 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/_contact_details/contact_address_schema.html
[3] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/checkout' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-002-001', '000-002', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/nav_lis_only.html
[1] SELECT billingAddress, shippingAddress FROM perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=69
[1] SELECT * FROM perch3_shop_customers WHERE memberID=3
[4] SELECT * FROM perch3_shop_addresses WHERE customerID='3' AND addressDeleted IS NULL AND orderID IS NULL
[4] Using template: /addons/apps/perch_shop/templates/shop/checkout/order_address_form.html
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[4] SELECT * FROM perch3_shop_countries WHERE countryID='1' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='236' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='1' LIMIT 1
[1] SELECT billingAddress, shippingAddress FROM perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=69

Display More

tonyastley · Mar 30th 2020

OK, I've done that - as a temporary fix I changed the value of the submit button on the customer_login.html template to 'Continue' - it is this value that get's inherited by the button on the perch_shop_order_address_form.

I've had to divide the debug, the forum is not letting me post in full as it is saying it's too long?

tonyastley · Mar 30th 2020

To make it stranger, if I navigate away from the page, then navigate back the form correctly shows 'OK!'

Note: simply refreshing the page does not change the text, you have to actually go away from the page and navigate back to it.

tonyastley · Mar 30th 2020

Here's a strange one...

I'm building the checkout process for the shop, once the user has clicked through to checkout they are presented with a login or register screen. For existing users the perch_shop_addresses_set will not have been set so they are presented with the perch_shop_order_address_form asking them to choose a billing and delivery. However the form shows 'Login' on the submit button rather than the 'OK!' from the template.

The form works fine and the addresses are set, but obviously 'Login' makes no sense to a user who has just logged in.

Any ideas?

tonyastley · Mar 30th 2020

That worked great, Thanks again Hussein.

tonyastley · Mar 26th 2020

Hello,

I would like Perch Shop to show only the products from the current category (excluding products within it's sub categories)

I have the following code:

PHP

<?php
perch_shop_products([
'category' => $fullcatPath,
'template' => 'products/views/product_list_categorised.html',
]);
?>

$fullcatPath provides a path such as: 'products/access-flood-protection/'

My issue is that it is showing all of the products within the sub categories of 'access-flood-protection' as well - I essentially only want it one flat level.

I have a template giving me the id of the current category, and I can see from the showall that there is a category array assigned to the product, I can't work out how to filter the results using the two pieces of information.

tonyastley · Mar 20th 2020

I've added a promotion discount to the site. I ran a test order and it worked perfectly fine.

However it is applying the discount to the cart persistently, even if I log out the discount is shown on the cart table.

Is this by design? If so is there a way to remove it when an order is placed?

tonyastley · Mar 20th 2020

OK, I think I have it:

When an order is created, the system will assign an ID to the shipping address, and a separate ID to the billing address. You can see names of these id's in the showall table for the order. They are:

orderShippingAddress

orderBillingAddress

The value will be an integer, for example:

perch_shop_customer_address(29);

'29' is the value stored for the billing address.

orderShippingAddress	30
orderBillingAddress	29

To obtain this number, you will need call the order details into a specific template containing only that ID, for example:

Code

$billingAddress = perch_shop_order($orderID, [
'template' => '/shop/orders/billingAddress.html'
], true);

The template billingAddress.html contains only the following ID:

Code

<perch:shop id="orderBillingAddress" />

You can then use the value stored in $billingAddress to display the address:

Code

perch_shop_customer_address($billingAddress);

Same logic applies for shipping address.

tonyastley · Mar 20th 2020

Hello,

I'm trying to show the shipping and billing address of an specific order. I have found reference to:

perch_shop_customer_address();
perch_shop_customer_addresses();

The former accepts an array of options, but I cannot find any documentation on what these options are?

My goal is to show the shipping and billing address based on a particular order ID.

Could someone explain how this is done please...

tonyastley · Mar 18th 2020

Thanks, your response has pointed me in the right direction. This page as the answer:

https://docs.grabaperch.com/templates/pagination/

Adding this code to the template has got me started.

Code

<perch:after>
<perch:if exists="paging">
<div class="paging">
Page <perch:content id="current_page" type="hidden">
of <perch:content id="number_of_pages" type="hidden">
<perch:if exists="not_first_page">
<a href="<perch:content id="prev_url" type="hidden" encode="false">">Previous</a>
</perch:if>
<perch:content id="page_links" encode="false">
<perch:if exists="not_last_page">
<a href="<perch:content id="next_url" type="hidden" encode="false">">Next</a>
</perch:if>
</div>
</perch:if>
</perch:after>

Display More

The perch_content_custom docs had me believe a default would appear as it does for site nav:

page-links	True or false. Create numbered page links as well as previous and next links.
page-link-template	The template to use (if not the default) to generate the page links.

tonyastley · Mar 18th 2020

The blog article template is as follows:

Code

<div class="article section">
<h2><perch:content id="title" label="Title" title /></h2>
<h6 class="date"><perch:content id="event_date" type="date" label="Date of event" format="D d F y" /></h6>
<perch:template path="content/blocks/blocks.html">
</div>

Should there be markup in there for where the pagination links appear?

The pages php is as follows:

PHP

<?php
include($_SERVER['DOCUMENT_ROOT'].'/perch/runtime.php');
include($_SERVER['DOCUMENT_ROOT'].'/_includes/config.php');
$pageTitle = 'Blog';
include($include.'/_common/docHead.php');
perch_content_create('Articles', array(
'template' => 'blog/blog_article.html',
'multiple' => true,
));
?>
<div class="blog section">
<div class="wrapper">
<?php perch_content_custom('Articles', array(
'template' => 'blog/blog_article.html',
'count' => 2,
'paginate' => true,
'page-links' => true,
));
?>
</div>
</div>
<?php include($include.'/_common/docBottom.php'); ?>

Display More

tonyastley · Mar 18th 2020

I'm using a multiple region as a simple blog for a client.

Code

perch_content_create('Articles', array(
'template' => 'blog/blog_article.html',
'multiple' => true,
));

This region is then called into the page:

PHP

<?php perch_content_custom('Articles', array(
'template' => 'blog/blog_article.html',
'count' => 2,
'paginate' => true,
'page-links' => true,
));

The articles show, and the count value works fine but the standard pagination doesn't show.

Is there something I'm missing?

tonyastley · Mar 12th 2020

Thanks Jordin, I'm going to try an persevere a little further with Perch.

tonyastley · Mar 11th 2020

Thanks Ellimondo.

I can see the logic in Perch Shop creating the variants, but for the use case we have (products with multiple options) I'm not sure it is a good fit.

Thanks for letting us know anyway. It's a shame we had to get so far into setting up to find out. Nevermind it will be a good solution single dimension products in the future.

tonyastley · Mar 11th 2020

This might mean Perch isn't a fit for us. Some of our products are built to order have 3/4 sets of configurable options, this would result in a cumbersome amount of sub products to manage.

tonyastley · Mar 10th 2020

Hit a bit of a brick wall with Perch Shop, couple of questions to see if we can get further:

1. Is it possible to extend the product options template to accommodate images

Our case here is to enable users to select door handle styles when purchasing a door.

2. Is it possible to update the price on the page when option is clicked.

Currently the only way of knowing the value of what you have selected is by adding it to the cart.

If anyone could provide an answer to the above I would be very grateful, even if it is a 'no'.

tonyastley · Mar 5th 2020

My bad, I hadn't switched the radio button. No issues, I re-installed and it works fine.

tonyastley · Mar 5th 2020

Hello,

I've installed Perch Runway locally to try it out before purchasing. Everything went through fine, however when I try to log in I get the message:

Sorry, your license key isn't valid for this domain. Log into your Perch account and add the following as your live or testing domain: dev.testdomain.loc

I read here that it should be possible under a .loc domain?

http://forum.grabaperch.com/fo…locally-without-a-license

Has anything changed in the last 2 years since that forum post?

Posts by tonyastley

Perch Shop Address form Saying 'Login' instead of 'OK!'

Perch Shop Address form Saying 'Login' instead of 'OK!'

Perch Shop Address form Saying 'Login' instead of 'OK!'

Perch Shop Address form Saying 'Login' instead of 'OK!'

Perch Shop Address form Saying 'Login' instead of 'OK!'

Perch Shop Address form Saying 'Login' instead of 'OK!'

Perch Shop - Show Only Products from Top Level of Current Category (not sub categories)

Perch Shop - Show Only Products from Top Level of Current Category (not sub categories)

Perch Shop Discount Remaining Active even after logout

Perch Shop Show Shipping and Billing Address on Order

Perch Shop Show Shipping and Billing Address on Order

Pagination not showing for perch_content_custom multiple region

Pagination not showing for perch_content_custom multiple region

Pagination not showing for perch_content_custom multiple region

Perch Shop Variants to Add Amount to Base Price

Perch Product Options with Images

Perch Shop Variants to Add Amount to Base Price

Perch Product Options with Images

Unable to test Perch Runway locally on a .loc domain

Unable to test Perch Runway locally on a .loc domain