New Page Replaces 'Home' in Structure - Weird Behaviour

jack · Nov 23rd 2020

Ok, this is an odd one.

I have a site running Perch Runway. I go to add a new 'top level' page, based on a template in perch>templates>pages. When I add the page the existing 'Home' page becomes a child of nothing, preventing the website from loading. The new page ('Stripe Intent' on the screenshot) is saved, but appears to have sub-pages, even though it doesn't. When being shown the confirmation message after creating the page, the actual 'Page Details' being displayed are for the Home page, not the new page.

Anyone seen anything like this before? I've built loads of sites in Runway and never seen it do this - bizarre issue with the database?

Other symptoms are that it takes about 40s to load the home page and there are ? symbols appearing the data (instead of £ signs etc) shown by <perch:showall /> on various templates (particularly things like the cart).

PHP

Perch Runway: 3.1.7, PHP: 7.4.12, MySQL: mysqlnd 7.4.12, with MySQLi
Server OS: Linux, litespeed
Installed apps: content (3.1.7), assets (3.1.7), categories (3.1.7), perch_blog (5.6.1), cma_branchcontact (0.1), cma_branchnews (0.1), cma_email (0.1), perch_events (1.9.5), perch_forms (1.12), cma_membersearch (0.1), perch_shop_orders (1.2.6), perch_shop_products (1.2.6), perch_shop (1.2.6), perch_members (1.6.4), pipit_catalog (1.2.1)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_members', 'perch_blog', 'perch_events', 'perch_forms', 'perch_shop', 'cma_branchcontact', 'cma_branchnews', 'cma_email', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /home/bikeorguk/public_html/perch
PERCH_CORE: /home/bikeorguk/public_html/perch/core
PERCH_RESFILEPATH: /home/bikeorguk/public_html/perch/resources
Image manipulation: GD
PHP limits: Max upload 64M, Max POST 64M, Memory: 128M, Total max file upload: 64M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
HTTP_HOST: bike.org.uk
DOCUMENT_ROOT: /home/bikeorguk/public_html
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php

Display More

jack · Nov 23rd 2020

Here's the debug code from the bottom of the page showing the queries being used to create the page (I commented out the redirect in perch>core>apps>content>modes>page.add.pre.php so I could see this). Not sure if it shows anything helpful.

Code

Debug Message - Perch Runway 3.1.7
[1] SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='7cd020c4b05b152677aaa77752f99d0a' LIMIT 1
UPDATE perch2_users SET userHash='6e9552b43c5df87e9eb05604af8994cf' WHERE userID='1'
[63] SELECT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[18] SELECT itemValue FROM perch2_menu_items WHERE itemType='app'
[37] SELECT *, (LENGTH(templatePath) - LENGTH(REPLACE (templatePath, "/", ""))) AS depth FROM perch2_page_templates ORDER BY depth, templatePath ASC
[1] SELECT * FROM perch2_pages WHERE pageID=18 LIMIT 1
[1] SELECT * FROM perch2_page_templates WHERE templateID='0' LIMIT 1
[1] SELECT * FROM perch2_pages WHERE pageID='18' LIMIT 1
[1] SELECT * FROM perch2_pages WHERE pageID='18' LIMIT 1
INSERT INTO perch2_pages(pageTitle,pageNavText,pageParentID,templateID,pageNew,pageCreatorID,pageModified,pageAttributes,pageTemplate,pageSubpageRoles,pageSubpageTemplates,pageDepth,pagePath) VALUES('Stripe Complete','Stripe Complete','18','0',1,'1','2020-11-23 20:15:40','','shop_intent.php','','',2,'/products/stripe-complete')
[1] SELECT * FROM perch2_pages WHERE pageID=1 LIMIT 1
updating tree position
[1] SELECT * FROM perch2_pages WHERE pageID='18' LIMIT 1
[6] SELECT MAX(pageOrder) FROM perch2_pages WHERE pageParentID=18
UPDATE perch2_pages SET pageParentID='18', pageOrder=7, pageDepth=2, pageTreePosition='000-005-007' WHERE pageID='1'
[1] SELECT * FROM perch2_page_templates WHERE templateID='2' LIMIT 1
[1] SELECT *, REPLACE(pagePath, '/index.php', '') as sortPath FROM perch2_pages WHERE pageNew=1 ORDER BY LENGTH(sortPath)-LENGTH(REPLACE(sortPath, '/', '')) ASC
[1] SELECT pageID, pageDepth, pageTreePosition FROM perch2_pages WHERE pageID=18 LIMIT 1
[7] SELECT COUNT(*) FROM perch2_pages WHERE pageNew=0 AND pageParentID=18
[0] SELECT COUNT(*) FROM perch2_pages WHERE pageTreePosition='000-005-008'
UPDATE perch2_pages SET pageSortPath='/products/stripe-complete', pageParentID='18', pageOrder=8, pageTreePosition='000-005-008', pageNew=0 WHERE pageID='0'
[nil] SELECT *, REPLACE(pagePath, '/index.php', '') as sortPath FROM perch2_pages WHERE pageNew=1 ORDER BY LENGTH(sortPath)-LENGTH(REPLACE(sortPath, '/', '')) ASC
[1] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[13] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1] SELECT itemTitle FROM perch2_menu_items WHERE itemType='app' AND itemValue='content' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /core/apps/content/modes/page.add.post.php
[66] SELECT p.*, (SELECT COUNT(*) FROM perch2_pages WHERE pageParentID=p.pageID) AS subpages FROM perch2_pages p ORDER BY pageTreePosition ASC
[37] SELECT *, (LENGTH(templatePath) - LENGTH(REPLACE (templatePath, "/", ""))) AS depth FROM perch2_page_templates ORDER BY depth, templatePath ASC
Queries: 32
Memory: 4.3041

Display More

jack · Nov 24th 2020

Fixed!

I compated the database table structure (perch2_pages) to another Perch Runway site and there were a few differences:

No Primary field assigned
No index on parentPageID
No auto increment on pageID

I've no idea how these differences occured, but after manually updating the broken table everything's working OK again.