Forum

Thread tagged as: Question, Problem, Error

Update Blog gone wrong...

I started with a 'blog' section already in Perch 1 and updated it a few times. Now I'm converting to runway but using it as a standard Perch. I updated the blog app and on the backside everything is OK: I can see al the posts (not very many).

On the front there is no post showing up and I cannot add a new post.

Activating the debug function I get the next error:

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

What can I do to resolve this?

Olof Fredrikze

Olof Fredrikze 0 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Which version of Blog did you update from?

Where can I find this? I'm not sure but I was asked to upgrade the app

This is in the admin.php

$this->register_app('perch_blog', 'Blog', 1, 'A simple blog', '4.5.4'); 
Drew McLellan

Drew McLellan 2638 points
Perch Support

That's the current version. Are you upgrading from a Perch 1 version of Blog?

Yes, I think so. Probably.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok. Do you have a backup of the older version of the site?

I do have a backup of the files but not a backup of the most recent changes made in the database - so if I have to go back to that one, changes made last week will be gone (and that is a lot of work...)

Drew McLellan

Drew McLellan 2638 points
Perch Support

I just want you to look at the older files to see which version you're upgrading from.

:D (sigh of relief-icon)

What should I be looking for?

Drew McLellan

Drew McLellan 2638 points
Perch Support

The register_app line, just like you've given us for the current version.

$this->register_app('perch_blog', 'Blog', 1, 'A simple blog', '3.0.1');
$this->require_version('perch_blog', '2.0.2');

This is the last version I was using before the update.

The app is not used very often and the first version I was using was probably the first release.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, that version is for Perch 2, not Perch 1. Did it even work under Perch 1?

Yes, it worked well under Perch 1

If it's (very) complicated to fix this it's probably easier to rebuild the blog section since there are only 12 messages in it. Copy - paste.

But even then, I have to remove the old content from the database and do some clean-up in the files...

Drew McLellan

Drew McLellan 2638 points
Perch Support

What happens if you run the Blog update again?

 /perch/addons/apps/perch_blog/update/

Ehm...

Everything is fixed now. New posts are accepted, old posts are where they belong.

Did I miss something while updating?

Thanks for the support!

(Next version will be a transition to Runway - fingers crossed)

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, great!