Forum
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!
This isn't something we've been able to reproduce here, but we'll keep an eye out for it.