Forum

Thread tagged as: Problem, Error, Runway

Runway Page Content keeps disappearing

Hi,

I have a weird issue with a Runway site, where the content of a page is randomly appearing and disappearing. We created another page elsewhere on the website that was just for linking to this page, and at one point we noticed that new regions appeared on this page as opposed to the original. However, we have other pages on the site that also are there just for link navigation purposes and these work fine.

Just to summarise, I'm not getting a blank page, but just the perch content is disappearing and then after re-saving perch regions or sometimes randomly refreshing the page it appears again. I've checked on different browsers and computers and the same thing is happening.

The page uses a master template used throughout the site with no other issues - the site has other 60-70 pages at the moment.

Any suggestions would be greatly appreciated!

Here's my diagnostic:

Perch Runway: 2.8.34, PHP: 5.4.45, MySQL: 5.5.46, with MySQLi
Server OS: Linux, cgi-fcgi
Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), perch_blog (5.0), perch_forms (1.8.3)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_blog', 'perch_forms', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /home/fullfatwebsite/public_html/zenithcosmetic/perch
PERCH_CORE: /home/fullfatwebsite/public_html/zenithcosmetic/perch/core
PERCH_RESFILEPATH: /home/fullfatwebsite/public_html/zenithcosmetic/perch/resources
Image manipulation: GD
PHP limits: Max upload 25M, Max POST 128M, Memory: 256M, Total max file upload: 25M
F1: 6a33f95eca3667f9e0c39bf5ca2980fe
Resource folder writeable: Yes
DOCUMENT_ROOT: /home/fullfatwebsite/public_html/zenithcosmetic
HTTP_HOST: zenithcosmetic.fullfatwebsitedesign.co.uk
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
Wayne Hooper

Wayne Hooper 6 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

What does debug output in both states?

Hi Drew,

When the page perch content disappears the debug is as follows:

Debug Message
SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC
Matched page: /non-surgical/skin/mole-removal, so not using routes.
Using master page: /templates/pages/blank.php
SELECT * FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
Using template: /templates/pages/attributes/seo.html
Using template: /templates/search/search-form.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/facial' OR pageSortPath='/surgical/facial' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/breasts' OR pageSortPath='/surgical/breasts' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/body' OR pageSortPath='/surgical/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/facial' OR pageSortPath='/non-surgical/facial' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin' OR pageSortPath='/non-surgical/skin' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/body' OR pageSortPath='/non-surgical/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/skin' OR pageSortPath='/conditions/skin' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/breasts' OR pageSortPath='/conditions/breasts' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/body' OR pageSortPath='/conditions/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith' OR pageSortPath='/why-zenith' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/item-btn-primary-yamm.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith/surgeons' OR pageSortPath='/why-zenith/surgeons' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith/reviews' OR pageSortPath='/why-zenith/reviews' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item.html
Debug Message
SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC
Matched page: /non-surgical/skin/mole-removal, so not using routes.
Using master page: /templates/pages/blank.php
SELECT * FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
Using template: /templates/pages/attributes/seo.html
Using template: /templates/search/search-form.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/facial' OR pageSortPath='/surgical/facial' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/breasts' OR pageSortPath='/surgical/breasts' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/body' OR pageSortPath='/surgical/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/facial' OR pageSortPath='/non-surgical/facial' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin' OR pageSortPath='/non-surgical/skin' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/body' OR pageSortPath='/non-surgical/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/skin' OR pageSortPath='/conditions/skin' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/breasts' OR pageSortPath='/conditions/breasts' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/body' OR pageSortPath='/conditions/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith' OR pageSortPath='/why-zenith' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/item-btn-primary-yamm.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith/surgeons' OR pageSortPath='/why-zenith/surgeons' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith/reviews' OR pageSortPath='/why-zenith/reviews' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item.html
Request time: 0.0744
Process time: 0.0742
Memory: 4.0093

But when the page is working, the debug is as follows:

Debug Message
SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC
Matched page: /non-surgical/skin/mole-removal, so not using routes.
Using master page: /templates/pages/treatment.php
SELECT * FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
Using template: /templates/pages/attributes/seo.html
Using template: /templates/search/search-form.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/facial' OR pageSortPath='/surgical/facial' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/breasts' OR pageSortPath='/surgical/breasts' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/body' OR pageSortPath='/surgical/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/facial' OR pageSortPath='/non-surgical/facial' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin' OR pageSortPath='/non-surgical/skin' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/body' OR pageSortPath='/non-surgical/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/skin' OR pageSortPath='/conditions/skin' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/breasts' OR pageSortPath='/conditions/breasts' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/body' OR pageSortPath='/conditions/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith' OR pageSortPath='/why-zenith' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/item-btn-primary-yamm.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith/surgeons' OR pageSortPath='/why-zenith/surgeons' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith/reviews' OR pageSortPath='/why-zenith/reviews' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item.html
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' OR pageSortPath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition
[3] Using template: /templates/navigation/breadcrumbs.html
SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/non-surgical/skin/mole-removal' OR regionPage='*' ORDER BY regionPage DESC
Debug Message
SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC
Matched page: /non-surgical/skin/mole-removal, so not using routes.
Using master page: /templates/pages/treatment.php
SELECT * FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
Using template: /templates/pages/attributes/seo.html
Using template: /templates/search/search-form.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/facial' OR pageSortPath='/surgical/facial' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/breasts' OR pageSortPath='/surgical/breasts' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/surgical/body' OR pageSortPath='/surgical/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[4] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/facial' OR pageSortPath='/non-surgical/facial' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin' OR pageSortPath='/non-surgical/skin' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/body' OR pageSortPath='/non-surgical/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/skin' OR pageSortPath='/conditions/skin' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-001%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/breasts' OR pageSortPath='/conditions/breasts' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[3] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/conditions/body' OR pageSortPath='/conditions/body' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[11] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith' OR pageSortPath='/why-zenith' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/item-btn-primary-yamm.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith/surgeons' OR pageSortPath='/why-zenith/surgeons' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006-003%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/why-zenith/reviews' OR pageSortPath='/why-zenith/reviews' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-006-002%' AND pageDepth >=2 AND pageDepth<=3 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item.html
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/non-surgical/skin/mole-removal' OR pageSortPath='/non-surgical/skin/mole-removal' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageTreePosition IN ('000-003-002-007', '000-003-002', '000-003', '000') ORDER BY pageTreePosition
[3] Using template: /templates/navigation/breadcrumbs.html
SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/non-surgical/skin/mole-removal' OR regionPage='*' ORDER BY regionPage DESC
Request time: 0.1417
Process time: 0.1415
Memory: 4.0267

In addition - I've just added a page for linking only to another page with Perch Nav, and I had the same issue with the Perch content on that page disappearing. I deleted the page for providing the link reference and the content re-appeared!

Drew McLellan

Drew McLellan 2638 points
Perch Support

Do you have multiple pages with the same path?

Yes - basically the same page is linked to twice in the navigation, once under the original page, and then a second page has been created to create a link to the same page but under different nav text but with the page path altered to point to the other page, if that makes sense.

Is that the right way to do it? It actually looks like when the page content disappears it's actually linking to the page used purely for navigation, which uses the blank master template, so it's like it doesn't know where to point.

We want to use Perch Nav, but there are times we need an element in the Pages tree to represent a link in navigation to another page.

Thanks for you help.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Having two pages with the same URL is not a scenario we've ever encountered or planned for - hence the slightly odd behaviour.

I see, sorry another member on this forum suggested doing that - in that case, can you suggest a way in which custom links can be introduced into Perch Nav? So for example you have menus like:

Tents:

2 man

3 man

4 man +

Family camping:

Tents - links to "4 man +" tents page above

Accessories

Sorry, not the best example, but you can see here we could have a menu and the link under "Tents - 4 man +" and then under "Family Camping - Tents" would link to the same page. Is this possible to achieve with Perch Nav, or would we always have to create a manually coded navigation tree that our client would struggle to update?

Thanks

Drew McLellan

Drew McLellan 2638 points
Perch Support

I think you'd need to use navigation groups for that.

Thanks Drew - just looked into Nav Groups and I can see that's exactly what's needed here.

I had to leave out...

'levels' => 1

...like on your example, otherwise it appeared blank, unless I went to as far as 3 - does it use the levels based on where pages sit in the tree?

Thanks

Just realised we have another issue here - is it possible to have the navigation link named differently within different navgroups?

So following the example above, we would have the same page linked to under both '4-man tents' and also 'family tents'.

I cannot see any option for this, so realise this might not be possible...

Thanks

Drew McLellan

Drew McLellan 2638 points
Perch Support

I don't really have any suggestions for you on how to accomplish this.

I understand that this isn't built into the Perch core functionality, but it could be really useful. To add a 'page' purely for linking purposes could enable clients to easily add external links too into the navigation, as well as links back to the same page. Could this be a suggestion?

I'm thinking an alternative would be to just create my own navigation template as a shared region instead with repeater links, but they would need to manually enter the page urls, unless I can use the page-list field with an option to manually enter if that's not selected...

Just wanted to add these thoughts in case anyone else comes across this with a similar issue.

Thanks