[Pro] A Perch challenge?

Hey guys. I need some help. I was updating one of my client websites and something has happened to my blog section. This is a Perch CMS enabled site that is pulling data from an SQL database. Although the news (blog) and archive pages are still working fine. The post page is not and I can’t figure out why.

I contacted Perch and Rachel is basically saying I didn’t follow their video, even though the blog was working fine for the past year prior to the latest Perch update. Here’s the link to that support discussion as well: http://support.grabaperch.com/index.php?pg=forums.posts&id=9251

I checked all of my paths and they seem to be fine. I am totally perplexed. Help!

http://wmp.idealynx.com/about/news.php


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Are you working on a local dev copy or the live server? Did you backup before upgrading?

Todd


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

I did, but sadly recovering from the previous version will be very, very time-consuming. :frowning:


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

I’m not sure I understand why it would be so time consuming. Did you backup the db and the perch folder/files or just the db?

Are you working on the live site or the dev copy?

Todd

I did, but sadly recovering from the previous version will be very, very time-consuming. :frowning:


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

The problem is when Perch updates its app, it often changes the database schema so if I upload a previous Perch SQL file the new Perch core may not recognize the old fields.

Drew is on the case now and he too suspects an upgrade issue. I’ve offered to send him the MySQL database for closer examination and perhaps some manual correction. I’ll keep you posted. (fingers crossed)


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

That’s why I asked if you also backed up the old perch folder in addition to the db, for exactly this reason. Before upgrading I always duplicate the entire perch folder so if it all goes $!$s-up it’s a simple swap.

Todd

The problem is when Perch updates its app, it often changes the database schema so if I upload a previous Perch SQL file the new Perch core may not recognize the old fields.


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

I usually keep at least two copies of the entire folder and db, but I can’t seem to locate them. :frowning:

Yes, lesson learned—the hard way. :slight_smile: Hopefully, Drew can fix it, otherwise I may be using a lot of &%&**()&% words. :slight_smile:


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

I just found an old set from November. So I should be able to just replace my entire Perch folder and the db, correct?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Crap, that db was the same as the one I have now. I found an older one, but unfortunately it contains the Perch 1 core and db.

Looks like I may be rebuilding a new db, if that’s even possible.


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

If you’re sure the backup folder and db were created at the same time then yes, it’s a simple swap. I’ve done it this way myself without issue. However, if the backup folder and db were created on different dates then it’s riskier because there might be crucial differences; maybe you upgraded a specific app etc.

Todd

So I should be able to just replace my entire Perch folder and the db, correct?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Going forward with updates I would also suggest you first upgrade your non-critical dev copy, not the live site. Better to find and fix issues there. I had a similar issue two days ago with a MODX add-on update which broke part of the site but I was able to spot it locally before I attempted a live site update. Saved me a lot of trouble.

Todd


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Usually, I’m pretty good at catching this stuff so any problems never make their way on to the live server. But I totally blew this one. I’ll need to review my workflow and backup procedures to ensure this doesn’t happen again.

Since it appears that only the Blog fields are affected, do you think I can simply delete the fields associated with the blog and have Perch recreate them?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

I would check with Drew first. I once had a Perch Gallery problem where a client decided to muck about with the actual db structure (do not ask me why!) and needless to say they made a mess. After consulting with Drew I was able to manually delete some stuff from the db and was able to get it running again. I don’t suggest going this route without first consulting the devs.

Todd

Since it appears that only the Blog fields are affected, do you think I can simply delete the fields associated with the blog and have Perch recreate them?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Yes, that’s what I’m doing.

While we’re on this subject, may I ask how you handle backups? In other words, do you create backups for both your live and development copies or just one or the other?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Yes. I prefer to maintain a clear distinction between the two.

Todd

While we’re on this subject, may I ask how you handle backups? In other words, do you create backups for both your live and development copies or just one or the other?


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

I just realized that my prices are way too low to be dealing with all of this stuff.

And yes, I mean the problems I created. LOL


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

[Laughs] I think many of us have felt the same at some point.

Todd

I just realized that my prices are way too low to be dealing with all of this stuff.

And yes, I mean the problems I created.


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Good news! Drew said give it a try so I deleted ALL of the Perch Blog tables in the db and reinstalled the Blog app. Everything is working great, although I have about 1-2 hours of blog restoration ahead of me.

And the morale of this story…

BACKUP, BACKUP, BACKUP

Thanks for your help everyone! - K


offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options