Forum

Thread tagged as: Question, Problem, Configuration

Hiding Members from Navigation not working...

Just updated to 2.7.1. Even after selecting hide from navigation in page options, still there to see...

Matthew Owen

Matthew Owen 0 points

  • 7 years ago

Just to update, I cannot hide any pages/Folders from the Navigation....

Drew McLellan

Drew McLellan 2638 points
Perch Support

How are you displaying your navigation?

<?php perch_pages_navigation(array( 'levels' => 1 )); ?>

being added with an include

Drew McLellan

Drew McLellan 2638 points
Perch Support

It's definitely working in my tests. Is there anything else you can tell me?

Ahh, it seems that the ticked field 'Hide from Navigation' does not save properly.

I tick it, save it, go to Pages, go back to page options and it is empty...

Drew McLellan

Drew McLellan 2638 points
Perch Support

That's not happening here - it's working as normal.

Can you turn debug on, check the box, click Submit and then let me know what the debug output says at that point?

0,0121  0   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='619826bd5691f3929215c7fdcf53c2aa' LIMIT 1
0,0136  0,0015  UPDATE perch2_users SET userHash='1cb76db8ba488d1458b18fb9be1f3925' WHERE userID=1
0,0139  0,0002  SELECT p.privKey FROM perch2_user_privileges p
0,0169  0,003   SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
0,0346  0,0177  SELECT * FROM perch2_pages WHERE pageID=21 LIMIT 1
0,0348  0,0002  SELECT * FROM perch2_pages WHERE pageID='0' LIMIT 1
0,0373  0,0026  UPDATE perch2_pages SET pagePath='/members/index.php', pageSubpagePath='/members', pageHidden='1', pageAccessTags='', pageModified='2014-10-28 15:10:08', pageCollections='', pageSubpageRoles='', pageSubpageTemplates='' WHERE pageID=21
0,0376  0,0002  Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pageCollections' in 'field list'
0,0376  0,0001  SELECT * FROM perch2_content_regions WHERE pageID='21' ORDER BY regionOrder ASC
0,038   0,0004  UPDATE perch2_content_regions SET regionPage='/members/index.php' WHERE regionID=71
0,0381  0,0002  UPDATE perch2_content_regions SET regionPage='/members/index.php' WHERE regionID=72
0,0383  0,0001  DELETE FROM perch2_navigation_pages WHERE pageID='21'
0,0385  0,0002  Setting alert: Erfolgreich aktualisiert (success)
0,0388  0,0003  SELECT * FROM perch2_user_roles ORDER BY roleTitle ASC
0,0393  0,0005  SELECT * FROM perch2_navigation ORDER BY groupTitle ASC
0,0423  0,0031  SELECT p.*, (SELECT COUNT(*) FROM perch2_pages WHERE pageParentID=p.pageID) AS subpages FROM perch2_pages p ORDER BY pageTreePosition ASC
0,044   0,0017  Queries: 17
Drew McLellan

Drew McLellan 2638 points
Perch Support

Could you try rerunning the update?

 /perch/core/update/?force=update

ok, at top says successfully updated with this underneath.

Time Δ Message 0,0179 0 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='45d011d729c5e1c6846388dfa7daf1eb' LIMIT 1 0,0198 0,0019 UPDATE perch2_users SET userHash='05388dd4d5a648154d76a69d4121230d' WHERE userID=1 0,0201 0,0003 SELECT p.privKey FROM perch2_user_privileges p 0,0238 0,0037 SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID 0,047 0,0233 SHOW TABLES LIKE 'perch2_resource_log' 0,0477 0,0006 ALTER TABLE perch2_resources ADD resourceCreated DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00' AFTER resourceType 0,0536 0,0059 ALTER TABLE perch2_resources ADD resourceUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER resourceCreated 0,0559 0,0023 ALTER TABLE perch2_resources ADD resourceAWOL TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceUpdated 0,0895 0,0336 ALTER TABLE perch2_resources ADD INDEX idx_awol (resourceAWOL) 0,0914 0,0019 ALTER TABLE perch2_resources ADD resourceTitle CHAR(255) NULL DEFAULT NULL AFTER resourceAWOL 0,0931 0,0017 ALTER TABLE perch2_resources ADD resourceFileSize INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTitle 0,095 0,0019 ALTER TABLE perch2_resources ADD resourceWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceFileSize 0,0969 0,0019 ALTER TABLE perch2_resources ADD resourceHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceWidth 0,0989 0,002 ALTER TABLE perch2_resources ADD resourceCrop TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceHeight 0,101 0,0021 ALTER TABLE perch2_resources ADD resourceDensity FLOAT NOT NULL DEFAULT '1' AFTER resourceCrop 0,1032 0,0023 ALTER TABLE perch2_resources ADD resourceTargetWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceDensity 0,1053 0,0021 ALTER TABLE perch2_resources ADD resourceTargetHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTargetWidth 0,1071 0,0018 ALTER TABLE perch2_resources ADD resourceMimeType CHAR(64) NULL DEFAULT NULL AFTER resourceTargetHeight 0,1094 0,0023 ALTER TABLE perch2_resources ADD FULLTEXT INDEX idx_search (resourceTitle) 0,1114 0,002 ALTER TABLE perch2_resources ADD resourceInLibrary TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceMimeType 0,1131 0,0017 ALTER TABLE perch2_resources ADD INDEX idx_library (resourceInLibrary) 0,1151 0,002 CREATE TABLE IF NOT EXISTS perch2_resource_tags ( tagID INT(10) NOT NULL AUTO_INCREMENT, tagTitle VARCHAR(255) NOT NULL DEFAULT '', tagSlug VARCHAR(255) NOT NULL DEFAULT '', tagCount int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (tagID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC 0,1152 0,0001 CREATE TABLE IF NOT EXISTS perch2_resources_to_tags ( resourceID int(10) NOT NULL DEFAULT '0', tagID int(10) NOT NULL DEFAULT '0', PRIMARY KEY (resourceID,tagID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED 0,1153 0,0001 CREATE TABLE IF NOT EXISTS perch2_resource_log ( logID int(10) unsigned NOT NULL AUTO_INCREMENT, appID char(32) NOT NULL DEFAULT 'content', itemFK char(32) NOT NULL DEFAULT 'itemRowID', itemRowID int(10) unsigned NOT NULL, resourceID int(10) unsigned NOT NULL, PRIMARY KEY (logID), KEY idx_resource (resourceID), KEY idx_fk (itemFK,itemRowID), KEY idx_uni (appID,itemFK,itemRowID,resourceID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 0,1154 0,0001 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('assets.create','Upload assets',1) 0,1156 0,0002 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'assets.create' for key 'idx_key' 0,1156 0 CREATE TABLE IF NOT EXISTS perch2_categories ( catID int(10) NOT NULL AUTO_INCREMENT, setID int(10) unsigned NOT NULL, catParentID int(10) unsigned NOT NULL DEFAULT '0', catTitle char(64) NOT NULL DEFAULT '', catSlug char(64) NOT NULL DEFAULT '', catPath char(255) NOT NULL DEFAULT '', catDisplayPath char(255) NOT NULL, catOrder int(10) unsigned NOT NULL DEFAULT '0', catTreePosition char(255) NOT NULL DEFAULT '000', catDynamicFields text NOT NULL, PRIMARY KEY (catID), KEY idx_set (setID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 0,1158 0,0001 CREATE TABLE IF NOT EXISTS perch2_category_sets ( setID int(10) NOT NULL AUTO_INCREMENT, setTitle char(64) NOT NULL DEFAULT '', setSlug char(64) NOT NULL DEFAULT '', setTemplate char(255) NOT NULL DEFAULT 'set.html', setCatTemplate char(255) NOT NULL DEFAULT 'category.html', setDynamicFields text, PRIMARY KEY (setID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 0,1158 0,0001 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.create','Create new categories',1) 0,1159 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.create' for key 'idx_key' 0,1159 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.delete','Delete categories',2) 0,116 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.delete' for key 'idx_key' 0,116 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.manage','Manage categories',3) 0,1161 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.manage' for key 'idx_key' 0,1161 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.sets.create','Create category sets',4) 0,1162 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.sets.create' for key 'idx_key' 0,1162 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.sets.delete','Delete category sets',5) 0,1163 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.sets.delete' for key 'idx_key' 0,1185 0,0022 SELECT COUNT(*) FROM perch2_gallery_images 0,1193 0,0008 SELECT i.imageID, i.imageBucket AS bucket, i.albumID, iv.versionPath AS file, i.imageAlt AS title, iv.versionWidth AS width, iv.versionHeight AS height FROM perch2_gallery_image_versions iv, perch2_gallery_images i WHERE iv.imageID=i.imageID AND iv.versionKey='original' AND i.imageStatus='active' 0,1196 0,0003 Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.imageBucket' in 'field list' 0,1196 0 SELECT * FROM perch2_resources ORDER BY resourceUpdated ASC 0,1202 0,0006 ALTER TABLE perch2_content_regions ADD regionUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER regionEditRoles 0,1204 0,0002 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'regionUpdated' 0,1204 0 ALTER TABLE perch2_content_items ADD itemUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER itemSearch 0,1206 0,0002 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'itemUpdated' 0,1206 0 ALTER TABLE perch2_content_items ADD itemUpdatedBy CHAR(32) NOT NULL DEFAULT '' AFTER itemUpdated 0,1207 0,0001 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'itemUpdatedBy' 0,1207 0 ALTER TABLE perch2_pages ADD pageTemplate CHAR(255) NOT NULL DEFAULT '' AFTER pageAttributeTemplate 0,1232 0,0024 ALTER TABLE perch2_pages ADD templateID INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER pageTemplate 0,1252 0,002 ALTER TABLE perch2_pages ADD pageSubpageTemplates VARCHAR(255) NOT NULL DEFAULT '' AFTER templateID 0,1272 0,002 ALTER TABLE perch2_pages ADD pageCollections VARCHAR(255) NOT NULL DEFAULT '' AFTER pageSubpageTemplates 0,1293 0,0021 CREATE TABLE IF NOT EXISTS perch2_category_counts ( countID int(10) unsigned NOT NULL AUTO_INCREMENT, catID int(10) unsigned NOT NULL, countType char(64) NOT NULL DEFAULT '', countValue int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (countID), KEY idx_cat (catID), KEY idx_cat_type (countType,catID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 0,1299 0,0006 SHOW TABLES LIKE 'perch2_content_index' 0,1303 0,0004 CREATE TABLE IF NOT EXISTS perch2_content_index ( indexID int(10) NOT NULL AUTO_INCREMENT, itemID int(10) NOT NULL DEFAULT '0', regionID int(10) NOT NULL DEFAULT '0', pageID int(10) NOT NULL DEFAULT '0', itemRev int(10) NOT NULL DEFAULT '0', indexKey char(64) NOT NULL DEFAULT '-', indexValue char(255) NOT NULL DEFAULT '', PRIMARY KEY (indexID), KEY idx_key (indexKey), KEY idx_val (indexValue), KEY idx_rev (itemRev), KEY idx_item (itemID), KEY idx_keyval (indexKey,indexValue), KEY idx_regrev (regionID,itemRev) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 0,1304 0,0001 CREATE TABLE IF NOT EXISTS perch2_resources ( resourceID int(10) unsigned NOT NULL AUTO_INCREMENT, resourceApp char(32) NOT NULL DEFAULT 'content', resourceBucket char(16) NOT NULL DEFAULT 'default', resourceFile char(255) NOT NULL DEFAULT '', resourceKey enum('orig','thumb') DEFAULT NULL, resourceParentID int(10) NOT NULL DEFAULT '0', resourceType char(4) NOT NULL DEFAULT '', PRIMARY KEY (resourceID), UNIQUE KEY idx_file (resourceBucket,resourceFile), KEY idx_app (resourceApp), KEY idx_key (resourceKey), KEY idx_type (resourceType) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 0,1305 0,0001 ALTER TABLE perch2_content_items ADD INDEX idx_regrev USING BTREE (itemID, regionID, itemRev) 0,1306 0,0001 Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_regrev' 0,1306 0 ALTER TABLE perch2_content_items ADD INDEX idx_order USING BTREE (itemOrder) 0,1307 0,0001 Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_order' 0,1307 0 ALTER TABLE perch2_content_regions ADD INDEX idx_key USING BTREE (regionKey) 0,1309 0,0001 Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_key' 0,1309 0 ALTER TABLE perch2_content_regions ADD INDEX idx_path USING BTREE (regionPage) 0,131 0,0001 Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_path' 0,131 0 ALTER TABLE perch2_page_templates ADD templateNavGroups VARCHAR(255) NULL DEFAULT '' AFTER templateReference 0,1738 0,0428 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'templateNavGroups' 0,1738 0 CREATE TABLE IF NOT EXISTS perch2_navigation ( groupID int(10) NOT NULL AUTO_INCREMENT, groupTitle varchar(255) NOT NULL DEFAULT '', groupSlug varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (groupID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 0,174 0,0002 CREATE TABLE IF NOT EXISTS perch2_navigation_pages ( navpageID int(10) unsigned NOT NULL AUTO_INCREMENT, pageID int(10) unsigned NOT NULL DEFAULT '0', groupID int(10) unsigned NOT NULL DEFAULT '0', pageParentID int(10) unsigned NOT NULL DEFAULT '0', pageOrder int(10) unsigned NOT NULL DEFAULT '1', pageDepth tinyint(10) unsigned NOT NULL, pageTreePosition varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (navpageID), KEY idx_group (groupID), KEY idx_page_group (pageID,groupID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC 0,1741 0,0001 ALTER TABLE perch2_user_privileges ADD UNIQUE INDEX idx_key (privKey) 0,1742 0,0001 Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_key' 0,1742 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.navgroups.configure','Configure navigation groups',7), ('content.navgroups.create','Create navigation groups',8), ('content.navgroups.delete','Delete navigation groups',9) 0,1744 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.navgroups.configure' for key 'idx_key' 0,1744 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.create.toplevel','Add new top-level pages',3) 0,1745 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.create.toplevel' for key 'idx_key' 0,1745 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.delete.own','Delete pages they created themselves',4) 0,1746 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.delete.own' for key 'idx_key' 0,1746 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.templates.configure','Configure master pages',6) 0,1747 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.templates.configure' for key 'idx_key' 0,1747 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.republish','Republish pages', 12) 0,1747 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.republish' for key 'idx_key' 0,1748 0 ALTER TABLE perch2_pages ADD pageAccessTags VARCHAR(255) NOT NULL DEFAULT '' AFTER pageNavOnly 0,175 0,0003 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAccessTags' 0,175 0 ALTER TABLE perch2_pages ADD pageCreatorID INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER pageAccessTags 0,1751 0,0001 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageCreatorID' 0,1751 0 ALTER TABLE perch2_pages ADD pageModified DATETIME NOT NULL DEFAULT '2014-01-01 00:00:00' AFTER pageCreatorID 0,1753 0,0002 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageModified' 0,1753 0 ALTER TABLE perch2_pages ADD pageAttributes TEXT NOT NULL AFTER pageModified 0,1754 0,0001 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAttributes' 0,1754 0 ALTER TABLE perch2_pages ADD pageAttributeTemplate VARCHAR(255) NOT NULL DEFAULT 'default.html' AFTER pageAttributes 0,1755 0,0001 Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAttributeTemplate' 0,1755 0 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.attributes','Edit page titles and attributes',6) 0,1756 0,0001 Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.attributes' for key 'idx_key' 0,1756 0 CREATE TABLE IF NOT EXISTS perch2_user_role_privileges ( roleID int(10) unsigned NOT NULL, privID int(10) unsigned NOT NULL, PRIMARY KEY (roleID,privID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 0,1757 0,0001 DELETE FROM perch2_settings WHERE settingID='update_2.7.1' AND userID=0 LIMIT 1 0,176 0,0002 INSERT INTO perch2_settings(settingID,settingValue,userID) VALUES('update_2.7.1','done',0) 0,1761 0,0001 Queries: 75

Drew McLellan

Drew McLellan 2638 points
Perch Support

Any difference?

Yes, all is now working & the Asset problem is also resolved! Thank you Drew!

Do I need to look at the install problems?

Drew McLellan

Drew McLellan 2638 points
Perch Support

What problems?