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

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

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.

Mxkert · Mar 30th 2020

Could you enable debug and post your debug script from that page here?

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

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

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

------------------------------ 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

JordinB · Apr 2nd 2020

Did you make that template change in the shop app template folder?

Just in case... you can copy that template to your perch/templates/ folder following the same folder structure as in the shop app. And it will override the template in the shop app so you can make changes like this without worrying about them being overwritten by a shop app update.

so if there was a template in :

Code

perch/addons/apps/perch_shop/templates/address/list.html

you can copy it to:

Code

perch/templates/shop/address/list.html

tonyastley · Apr 3rd 2020

Thanks Jordin,

Looks like I've been using Perch Templates incorrectly for years. I recently replaced the shop app entirely to reset the base templates and started adding mine back into the correct place.

The issue still persists though, logging in at that stage of the buying process changes the wording on the submit button of the perch_shop_order_address_form to 'login' rather than what the (default) template says it should be 'OK!'.

ellimondo · Apr 3rd 2020

Hi Tony

This can be confusing, especially if you're dealing with multiple templates.

First, double check that none of your templates in your debug output are showing /perch/addons/perch_shop/templates as a path. They should all point to /perch/templates as Jordin pointed out.

Perform a text search of all files inside your /perch/template folder for "value='Log in'" (or whatever is showing by mistake). That should then reveal your potential ghost in the machine.

Jon

tonyastley · Apr 6th 2020

Thanks Jon,

This is a strange one, as that's my normal process for working out what is being shown. Take a look at the video link below and you will see the text on the form 'change'.

It inherits the submit button value from the previous screen, but if I go to a different page and then back again it uses the submit button value from the template.

https://www.dropbox.com/s/hw4d…qk0l/checkoutbug.mov?dl=0

jamiekingmedia · Feb 6th 2021

Hello Tony, and everyone else who's contributed.
I found this post, while looking for an answer to the very same question.
I had;

perch_member_login_form,
perch_shop_registration_form,
perch_shop_order_addresses_form, and
perch_shop_shipping_method_form

All on the same page (showing and hiding with IF-statements of course).

My problem: The same as you Tony, the mysterious OK! turned into "Log in".

Here is what I discovered:
The <input> id="" is set as id="submit" on a few of those form in the Templates.
I changed the ID to "submit1", "submit2" etc on each template I used, and it seemed to fix the problem.
I tested this a few times over, but its not a comprehensive test, but I feel the ID's on the submit buttons are the issue. - Hope this helps you and others.

tonyastley · Feb 9th 2021

Thanks Jamie, will take a look!

bhenmia0 · Mar 10th 2021

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