Blog posts to categories, ticks gone?
We just updated from CMS 2.7.10 to 2.8.3 and updated the Blog as well. Under Blog, we see the list of Categories, but previous Blog posts now no longer have ANY categories ticked? However, in the DB "perch2_blog_posts_to_categories" shows various Blog posts to different categories.
Aside from the new Category template change we made, is there something else to change to get old posts and category selections matching up again?
Thanks.
Running:
Perch: 2.8.3 PHP: 5.4.38 MySQL: mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $, with PDO Server OS: Linux, cgi-fcgi Installed apps: content (2.8.3), assets (2.8.3), categories (2.8.3), perch_blog (4.6), perch_gallery (2.8.5)
Which version of Blog did you upgrade from?
Upgraded Blog from version 4.0.3
Ok, quite a jump. Did you follow the upgrade notes for Blog?
I added the category code into post, and copied over the category templates, I saw the other notes on change any category display, but this issue is in the CMS itself... The categories display as per Category section and the DB has the old info still.
Do you have the Blog set listed in the Categories app?
Yes. I can see the categories listed out under the set "Blog" under Categories App - as per before.
Ok, and you're using that set in your template?
Yep.
Is this set template correct?
That looks correct. Was it in place when you ran the update?
Category code was added to post as per instruction AFTER install.
Ok. That all sounds like it's fine.
Can you try running the blog update?
Ran the Blog update... no change. Logged out and in again, still no change.
Do the categories display on your site?
No, this shows nothing:
This is the category template:
Ok. I don't know what the state of your install is. Probably the best thing to do is revert your database to your pre-update backup and then let the update run again. This time note any errors or messages you get.
For the core or just the Blog app? I think it's going to be easier to just re-tick all the blog entries for the categories associated... I will try that on one and see if it shows up.
OK, so ticking a category for a post and it now shows.
So the past post entries listed in "perch2_blog_posts_to_categories" by ID and Cat ID are no longer being matched/read/used... The NEW post we ticked to a category is NOT saved in this table. This would explain why these old ones are no longer showing up...
Posts ticked to a category seem to be appended to postDynamicFields in Post itself - I can't find it recorded anywhere else.
Perhaps a patch is needed for Blog to convert this?
No, that is correct. I don't have an explanation for why yours didn't work when everyone else's has.
It's correct that it is no longer saving into or reading from blog_posts_to_categories?
Is it possible to run an SQL query to run to copy all the old category entries and append to postDynamicFields?