Thread tagged as: Problem, Installation, Configuration

Can't Get Perch Content Areas to Show Up

Hi there - I've built 20+ sites on Perch so for me, installing Perch is something I do on a very regular basis. However, it's the strangest issue I've got here, but I did my latest local Perch install and I can't get any of my Perch content areas to show up.

I've done all the error checking I can find in the Perch documentation, and all the error checking I've ever seen in any other of my Perch sites...

• I know my local environment is running correctly, because I have six other Perch sites running on my local environment (MAMP3 on my MBP running 10.9, all Perch installs are 2.4.9). • I have my Perch runtime installed on the page correctly, and when I view source I do NOT see it in source so I know it's getting parsed correctly. • I am running other php includes on my pages, so I know PHP is operating correctly on the pages. • After installing Perch, I can log in to the admin and run diagnostics - everything looks proper, no errors.

To double-check, I even ported everything over to my public dev server and tested it there - same exact results, everything is running correctly and admin is accessible,I just can't get any of the Perch content areas in the pages to show up in the admin.

Site is running in dev here:

Admin login is here:

Menu page with a lot of Perch tags is here:

Frankly, I'm stumped. I've even totally deleted and reinstalled from scratch, and to test I put the example.php page from the install package in the root of the site... nothing. Cannot get the Perch content areas to show up in the admin at all.

Any help you could offer would be greatly appreciated. Please let me know if you need any more info from me to help with this issue. :)

Gregg Tomlinson

Gregg Tomlinson 1 points

  • 7 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

What do you get if you add debug to the pages in question?

I have added that debug query to the pages, there's quite a bit of output but this is getting repeated often:

Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pageModified' in 'field list'

You can see the output at the bottom of the pages here: and here:

Drew McLellan

Drew McLellan 2638 points
Perch Support

Was this an upgrade from an older version of Perch?

No, it's (the Perch core) is a clone of a 2.4.9 install running successfully on another site. Do you think I should scrap the entire Perch install and re-install from scratch?

Rachel Andrew

Rachel Andrew 394 points
Perch Support

I'm confused as you said you had installed from scratch. Can you drop all of your tables and run install again?

Certainly can! And when I said "from scratch" -- what I mean is that I have a core set of folders I use for each of my installs: Perch core (current version which I update by replacing core when needed) plus all Perch Apps I use (again, update as needed). This way, when I do my installs I have everything current and from scratch.

I'll completely delete my Perch folders, delete db, do a reinstall from a downloaded version of Perch, and install debugging - and report back.

OK, that totally fixed the issue. So apparently I need to rebuild my core set of folders for my Perch install because something's gone awry in there - or, jsut install from a downloaded set every time. Thank you for the help, it's very much appreciated!