Forum
Updating checkbox values in perch members app
Having the exact same issue as described in the thread linked below. The thread is now closed but doesn't seem like a solution was discovered. https://forum.grabaperch.com/forum/03-20-2018-updating-checkbox-values-in-perch-members-app
My Checkboxes are in register and profile templates. Checking them works fine but I can't save the empty value when unchecked in edit profile. Other field types can be amended on save with no issue.
Using
Perch Runway: 3.0.14 perch_members (1.6.1)
Template Code
<li>
<perch:input type="checkbox" id="org_sector_pharma" label="Pharma" value="pharma" />
<perch:label for="org_sector_pharma">Pharma</perch:label>
</li>
Degbug
Debug Message - Perch Runway 3.0.14
[23] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_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 perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /members/profile, so not using routes.
Using master page: /templates/pages/members/profile.php
[29] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
[1] SELECT * FROM perch2_members_sessions WHERE sessionID='0d44ac6bbbf2e1359ba29de520ffaa96ef6193d1' AND sessionHttpFootprint='6b04eed5eee7ef2887fc216620440808b0d5b9fa' AND sessionExpires>'2018-08-20 10:15:50' LIMIT 1
User is logged in
[1] SELECT * FROM perch2_pages WHERE pagePath='/members/profile' LIMIT 1
[2] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/members/profile' OR regionPage='*' ORDER BY regionPage DESC
Using template: /templates/pages/attributes/seo.html
Using template: /templates/pages/attributes/body_attributes.html
[5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/members/profile' LIMIT 1
[2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004-001', '000-004', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/main-nav-item.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Heading' AND (regionPage='/members/profile' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=33 AND idx.itemRev=1)) 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/global/_heading_top.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=33 AND idx.itemRev=1)) 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/global/_heading_bottom.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Content' AND (regionPage='/members/profile' OR regionPage='*')
[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=39 AND idx.itemRev=0)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
Using template: /templates/content/global/_blocks.html
Using sub-template: /templates/content/global/blocks/_textarea.html
Using sub-template: /templates/content/global/blocks/_list.html
Using sub-template: /templates/content/global/blocks/_button.html
Using sub-template: /templates/content/global/blocks/_image.html
Using sub-template: /templates/content/global/blocks/_img-txt.html
Using sub-template: /templates/content/global/blocks/_logos.html
Using sub-template: /templates/content/global/blocks/_video.html
Using sub-template: /templates/content/global/blocks/_map.html
Using sub-template: /templates/content/global/blocks/_table.html
Using sub-template: /templates/content/global/blocks/_testimonial.html
Using sub-template: /templates/content/global/blocks/_bullet_image_list.html
Using sub-template: /templates/content/global/blocks/_source_code.html
Using template: /templates/members/forms/profile.html
Using template: /templates/members/forms/password.html
[1] SELECT groupID FROM perch2_navigation WHERE groupSlug='footer-navigation' LIMIT 1
[3] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=1 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch2_pages p, perch2_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=1 AND p.pagePath='/members/profile' LIMIT 1
[3] Using template: /templates/navigation/item.html
Request time: 0.0582
Process time: 0.0567
Memory: 3.5584
Have you tried with the current version, or are you sticking to this old version for some other reason?
Yes just tried with the latest versions of Perch and Members app. The same issue persists.
Hi Drew - Any other ideas on what might be causing this?