Deleted regions not re-appearing again

Hi Drew, it wasn't so I enabled it, saved and checked again; still no joy.

Drew McLellan said:

Have you tried invoking it from the page?

I don't know what that means?

Hi Drew, I've tried that and it hasn't made any difference (I'm on a Mac btw, so I tried both Ctrl-E & Cmd-E) It's a single page simple website. As a test, I decided to copy the /index.php and rename /index2.php and upload this to server to se if this regions get pulled in for this page. When I did this; It picks up the /index2.php page on Perch but has not regions underneath it. It also picks up 3 other pages (not mine!), that presumably this customer tried to create using the 'Add Page' button on the top righthand side of the screen, even though I hadn't enabled the pages app template for this site. When I try and delete any of these 3 pages, Perch simply kicks me out to login screen. Should I reinstall Perch completely here? I've turned on Debug, but nothing jumps out;

Debug Message - Perch 3.1.1
[1] SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='93d5c8bb7b789c5856fa435634be7244' LIMIT 1
UPDATE perch3_users SET userHash='b0ce7064746b2bfeb81946741ed5c032' WHERE userID='1'
[22] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[6] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[1] SELECT * FROM perch3_pages WHERE pageID=0 LIMIT 1
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch3_content_regions WHERE pageID=0 AND regionPage!='*' ORDER BY regionOrder ASC LIMIT 0, 100
[0] SELECT FOUND_ROWS() AS `count`
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_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 perch3_menu_items WHERE itemType='app' AND itemValue='content' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_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 perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC

They are declared within the individual editable div areas.

<?php perch_content('Gallery'); ?> <?php perch_content('Testimonials'); ?>

This website was working perfect as was, so I doubt it's the regions code that's the root cause. It's strange that the gallery images (which are obviously declared through Perch) are still holding on the website, almost like they are in a cached state.

The front facing page (/index.php) is not being picked up on Perch at all as a page. The test identical duplicate of this page (/index2.php) is reporting the below:

Debug Message - Perch 3.1.1
[1] SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='2743ba53465b54341ee2ea4f35b65914' LIMIT 1
UPDATE perch3_users SET userHash='d8f062f02b9c0069e56737025fe1b232' WHERE userID='1'
[22] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[6] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[1] SELECT * FROM perch3_pages WHERE pageID=0 LIMIT 1
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch3_content_regions WHERE pageID=0 AND regionPage!='*' ORDER BY regionOrder ASC LIMIT 0, 100
[0] SELECT FOUND_ROWS() AS `count`
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_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 perch3_menu_items WHERE itemType='app' AND itemValue='content' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_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 perch3_menu_items mi LEFT JOIN perch3_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.post.php
Queries: 13
Memory: 1.5669

Drew McLellan said:

The front facing page (/index.php) is not being picked up on Perch at all as a page.

But you can add debug to see what it outputs, right?

No, the debug you see above is from /index2.php. This is the exact same file, just renamed. It is getting picked up in Perch (along with 3 other pages). It's not picking it's regions up though and I cannot delete any of these pages.

Hi Drew. I cannot create the /index.php on Perch, so I cannot provide the debug. I have the file (/index.php) offline and if I copy over a new copy of this file to the server and refresh the website, it doesn't get picked up? If I copy/paste/rename this file to be /index2.php it does get picked up but is not working right either?

Hi Drew. It would appear that the original database became corrupted somehow... possibly because they had admin rights and tried adding a page that they didn't have the ability to do. I have since revoked this and given them Editor rights. Truth be told, I have no idea what they did or how it ended up behaving/corrupting like this. Anyway, I decided to create a new database on the server and update the config file, re-setup Perch and rebuild the page. Fixed now (the hard way!) Thanks.