Forum
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?
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
That's the current version. Are you upgrading from a Perch 1 version of Blog?
Yes, I think so. Probably.
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...)
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?
The
register_app
line, just like you've given us for the current version.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.
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...
What happens if you run the Blog update again?
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)
Ok, great!