Forum

Thread tagged as: Question, Error, Blog

Blog admin pager issue

Hi!

There seems to be some bug in the pager in Blog admin.

I get on the listing page, page 1 of 6. 2 of 6 is displayed correctly, but 3 of 6 is not there. Instead I get 3 of 3.

This is the first page where in the listing is also drafts, if this could be somehow related?

I can change the page directly from the url parameter up to 6th page.

This occurred after the update to blog app 5.0 and Perch core 2.8.17.

I'm not getting any PHP-error in apache logs.

Here's what the message says on 2 of 6

Debug Message
SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=2 AND u.userHash='1bfb607e93e82136c52e6c245cb0484a' LIMIT 1
UPDATE perch2_users SET userHash='0a79eb381ec57f5b13fde6491038ea00' WHERE userID='2'
SELECT p.privKey FROM perch2_user_privileges p
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=2 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
SELECT * FROM perch2_blogs WHERE blogID=1 LIMIT 1
SELECT * FROM perch2_categories c, perch2_category_sets s WHERE c.setID=s.setID AND s.setSlug='blog' ORDER BY catTreePosition ASC
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 15, 15
SELECT FOUND_ROWS() AS count
SELECT COUNT(*) FROM perch2_blog_comments WHERE commentStatus='PENDING'
Queries: 12
Memory: 1,326

Here's what the message says on 3 of 3

Debug Message
SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=2 AND u.userHash='c4551f42c267b94b087acd67846032a0' LIMIT 1
UPDATE perch2_users SET userHash='9cf5429f338290b412c261d04020b6f9' WHERE userID='2'
SELECT p.privKey FROM perch2_user_privileges p
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=2 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
SELECT * FROM perch2_blogs WHERE blogID=1 LIMIT 1
SELECT * FROM perch2_categories c, perch2_category_sets s WHERE c.setID=s.setID AND s.setSlug='blog' ORDER BY catTreePosition ASC
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 30, 15
SELECT FOUND_ROWS() AS count
SELECT COUNT(*) FROM perch2_blog_comments WHERE commentStatus='PENDING'
Queries: 12
Memory: 1,3181

Here's what the message says on 4 of 4

Debug Message
SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=2 AND u.userHash='5077efc39ad2bc97914e75a4f41a5f97' LIMIT 1
UPDATE perch2_users SET userHash='dd7b4b16c8f85a9c399e044eb0ae3235' WHERE userID='2'
SELECT p.privKey FROM perch2_user_privileges p
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=2 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
SELECT * FROM perch2_blogs WHERE blogID=1 LIMIT 1
SELECT * FROM perch2_categories c, perch2_category_sets s WHERE c.setID=s.setID AND s.setSlug='blog' ORDER BY catTreePosition ASC
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 45, 15
SELECT FOUND_ROWS() AS count
SELECT COUNT(*) FROM perch2_blog_comments WHERE commentStatus='PENDING'
Queries: 12
Memory: 1,3031

Any ideas? Thanks!

Karri Karttunen

Karri Karttunen 0 points

  • 5 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

This isn't something we've been able to reproduce here, but we'll keep an eye out for it.