Blog post list empty after update

Hoops78 · May 7th 2019

Hi

I've updated a site (v2.8.34 with blog 4.6 (I think)) to the latest (diagnostics below).

I updated the core first, then blog and the updating posts message ran and completed. I've just realised when going to the blog app and listing posts, its empty. The posts are on the site so I hadn't noticed earlier. I can't be 100% which version of blog I updated from, but it was higher than 4.5 as I don't need to do any extra work to update.

Would a force update help?

Regards

Wayne

PHP

Perch: 3.1.5, PHP: 7.2.17, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $, with PDO
Server OS: Linux, cgi-fcgi
Installed apps: content (3.1.5), assets (3.1.5), categories (3.1.5), perch_blog (5.6.1)
App runtimes: <?php $apps_list = array( 'perch_blog', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /home/fullfatwebsite/public_html/beautyroom/perch
PERCH_CORE: /home/fullfatwebsite/public_html/beautyroom/perch/core
PERCH_RESFILEPATH: /home/fullfatwebsite/public_html/beautyroom/perch/resources
Image manipulation: GD
PHP limits: Max upload 25M, Max POST 128M, Memory: 256M, Total max file upload: 25M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
DOCUMENT_ROOT: /home/fullfatwebsite/public_html/beautyroom
HTTP_HOST: beautyroom.fullfatwebsitedesign.co.uk
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php

Display More

Hoops78 · May 9th 2019

Hi

Any suggestions about this? as I'm hoping to push this live tomorrow.

Regards

Wayne

drewm · May 9th 2019

What does debug say on the page where you expect to see the listing?

Hoops78 · May 9th 2019

it says;

Code

Debug Message - Perch 3.1.5
[1] SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='a1a134dcc517e7bbcaccbed8d1da4333' LIMIT 1
UPDATE perch2_users SET userHash='e4b9e8bdba8bacc3f8fc075bab29869f' WHERE userID='1'
[35] SELECT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[11] SELECT itemValue FROM perch2_menu_items WHERE itemType='app'
[0] SELECT COUNT(*) FROM perch2_blog_comments WHERE commentStatus='PENDING'
[1] SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
[1] SELECT * FROM perch2_blogs ORDER BY blogTitle ASC LIMIT 1
[2] SELECT * FROM perch2_categories c, perch2_category_sets s WHERE c.setID=s.setID AND s.setSlug='blog' ORDER BY catTreePosition ASC
[1] SELECT * FROM perch2_blog_sections WHERE blogID=1 ORDER BY sectionTitle ASC
SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_blog_posts WHERE blogID=1 ORDER BY postDateTime DESC LIMIT 0, 15
Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'blogID' in 'where clause'
[1] SELECT FOUND_ROWS() AS count
Attempting app installation: perch_blog
[1] SHOW TABLES LIKE "perch2_blog_posts"
[1] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[6] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1] SELECT itemTitle FROM perch2_menu_items WHERE itemType='app' AND itemValue='perch_blog' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /addons/apps/perch_blog/modes/list.post.php
Queries: 17
Memory: 2.7873

Display More

I'm guessing this is the problem...

Code

Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'blogID' in 'where clause'

What should I do to fix this?

drewm · May 9th 2019

Did you run the blog updater?

Hoops78 · May 9th 2019

Is that part of the blog update? I saw the message about posts being updated. Or is it something else?

Hoops78 · May 12th 2019

Is there anything else I can try? Or something I've missed? I could do with fixing this for tomorrow if possible.

Regards

Wayne

Hoops78 · May 13th 2019

Found how to do the blog updater

Code

perch/addons/apps/perch_blog/update/

fixed it