Forum

Thread tagged as: Problem, Blog

Blog issue

I got a couple of site with the latest Blog app and I've noticed a weird issue. Publishing sometimes takes 3 or more saves to publish, and if I go back into a post and save it, it disappears. I'm just setting up some post examples and one doesn't post until a newer one is posted... for example post 1 doesn't show until post 2 is published, but post 2 doesn't show. Then all disappeared, but when I went to the settings to get my diagnostics, this made them all show.

Perch: 3.1.2, PHP: 7.2.1, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $, with PDO
Server OS: Darwin, cgi-fcgi
Installed apps: content (3.1.2), assets (3.1.2), categories (3.1.2), perch_blog (5.6.1), pipit_sharing (1.2.0)
App runtimes: <?php $apps_list = [ 'perch_blog', 'pipit_sharing', ];
PERCH_LOGINPATH: /perch
PERCH_PATH: /Users/hoops78/Documents/Malhere Carp Garden/root/perch
PERCH_CORE: /Users/hoops78/Documents/Malhere Carp Garden/root/perch/core
PERCH_RESFILEPATH: /Users/hoops78/Documents/Malhere Carp Garden/root/perch/resources
Image manipulation: GD
PHP limits: Max upload 126M, Max POST 256M, Memory: 512M, Total max file upload: 126M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
REQUEST_URI: /perch/core/settings/diagnostics/
DOCUMENT_ROOT: /Users/hoops78/Documents/Malhere Carp Garden/root
HTTP_HOST: malhere
Wayne Hooper

Wayne Hooper 6 points

  • 2 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

2 years ago

Have you checked debug for any errors?
Wayne Hooper

Wayne Hooper 6 points

2 years ago

Hi

I have the following admin debug when I have edited a post and re-saved it. It then disappears from the front-end and only the other untouched posts remain.

Debug Message - Perch 3.1.2
[1] SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='1eea74e1e4859b28ba9bb8ee985040e9' LIMIT 1
UPDATE perch3_users SET userHash='89af0b3807237a6dfa77fe28a761e7ad' WHERE userID='1'
[31] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
Adding: Pipit Sharing
[8] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[0] SELECT COUNT(*) FROM perch3_blog_comments WHERE commentStatus='PENDING'
[1] SELECT * FROM perch3_blog_authors WHERE authorEmail='wayne@fullfatdesigns.co.uk' LIMIT 1
[1] SELECT * FROM perch3_blog_posts WHERE postID=5
[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
[1] SELECT * FROM perch3_blogs WHERE blogID=1 LIMIT 1
[1] SELECT * FROM perch3_blog_sections WHERE blogID='1' ORDER BY sectionTitle ASC
Using template: /templates/blog/post.html
[1] SELECT * FROM perch3_resources WHERE resourceID='719' LIMIT 1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceKey='thumb'
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceTargetWidth=800 AND resourceTargetHeight=600 AND resourceCrop=1 AND resourceDensity=1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceTargetWidth=350 AND resourceTargetHeight=250 AND resourceCrop=1 AND resourceDensity=1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceTargetWidth=350 AND resourceTargetHeight=0 AND resourceCrop=0 AND resourceDensity=1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceTargetWidth=400 AND resourceTargetHeight=250 AND resourceCrop=1 AND resourceDensity=1
Logging resources for perch_blog
DELETE FROM perch3_resource_log WHERE appID='perch_blog' AND itemFK='postID' AND itemRowID=5
INSERT IGNORE INTO perch3_resource_log(`appID`, `itemFK`, `itemRowID`, `resourceID`) VALUES('perch_blog','postID',5,719),('perch_blog','postID',5,720),('perch_blog','postID',5,819),('perch_blog','postID',5,820),('perch_blog','postID',5,821),('perch_blog','postID',5,822)
UPDATE perch3_blog_posts SET postStatus='Published', postTemplate='post.html', postDescRaw='Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum.\r\n\r\nCras mattis consectetur purus sit amet fermentum. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.\r\n\r\nCurabitur blandit tempus porttitor. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Maecenas sed diam eget risus varius blandit sit amet non magna. Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.\r\n\r\nInteger posuere erat a ante venenatis dapibus posuere velit aliquet. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec sed odio dui. Curabitur blandit tempus porttitor. Maecenas faucibus mollis interdum. Curabitur blandit tempus porttitor. Cras mattis consectetur purus sit amet fermentum.\r\n\r\nMorbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.\r\n\r\nDonec sed odio dui. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Donec id elit non mi porta gravida at eget metus. Nulla vitae elit libero, a pharetra augue. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam quis risus eget urna mollis ornare vel eu leo.\r\n\r\nFusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Curabitur blandit tempus porttitor. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vestibulum id ligula porta felis euismod semper. Aenean lacinia bibendum nulla sed consectetur. Cras justo odio, dapibus ac facilisis in, egestas eget quam.', postDescHTML='<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum.</p>\n<p>Cras mattis consectetur purus sit amet fermentum. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.</p>\n<p>Curabitur blandit tempus porttitor. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Maecenas sed diam eget risus varius blandit sit amet non magna. Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.</p>\n<p>Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec sed odio dui. Curabitur blandit tempus porttitor. Maecenas faucibus mollis interdum. Curabitur blandit tempus porttitor. Cras mattis consectetur purus sit amet fermentum.</p>\n<p>Morbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.</p>\n<p>Donec sed odio dui. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Donec id elit non mi porta gravida at eget metus. Nulla vitae elit libero, a pharetra augue. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam quis risus eget urna mollis ornare vel eu leo.</p>\n<p>Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Curabitur blandit tempus porttitor. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vestibulum id ligula porta felis euismod semper. Aenean lacinia bibendum nulla sed consectetur. Cras justo odio, dapibus ac facilisis in, egestas eget quam.</p>', postTitle='new plans for malhere', postDynamicFields='{\"excerpt\":{\"_flang\":\"markdown\",\"raw\":\"Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum..\",\"processed\":\"<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum..<\\/p>\"},\"video\":{\"_flang\":\"plain\",\"raw\":\"\",\"processed\":\"\"},\"image\":{\"assetID\":\"719\",\"title\":\"IMG 0695\",\"_default\":\"\\/perch\\/resources\\/img0695.jpg\",\"bucket\":\"default\",\"path\":\"img0695.jpg\",\"size\":580651,\"w\":1728,\"h\":1152,\"mime\":\"image\\/jpeg\",\"sizes\":{\"thumb\":{\"w\":\"150\",\"h\":\"100\",\"target_w\":150,\"target_h\":150,\"density\":2,\"path\":\"img0695-thumb@2x.jpg\",\"size\":28535,\"mime\":\"image\\/jpeg\",\"assetID\":\"720\"},\"w800h600c1\":{\"w\":\"800\",\"h\":\"600\",\"target_w\":\"800\",\"target_h\":\"600\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w800h600.jpg\",\"size\":221057,\"mime\":\"\",\"assetID\":\"819\"},\"w350h250c1\":{\"w\":\"350\",\"h\":\"250\",\"target_w\":\"350\",\"target_h\":\"250\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w350h250.jpg\",\"size\":45075,\"mime\":\"\",\"assetID\":\"820\"},\"w350hc0\":{\"w\":\"350\",\"h\":\"233\",\"target_w\":\"350\",\"target_h\":false,\"crop\":false,\"density\":\"1\",\"path\":\"img0695-w350.jpg\",\"size\":38454,\"mime\":\"\",\"assetID\":\"821\"},\"w400h250c1\":{\"w\":\"400\",\"h\":\"250\",\"target_w\":\"400\",\"target_h\":\"250\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w400h250.jpg\",\"size\":50479,\"mime\":\"\",\"assetID\":\"822\"}}}}' WHERE postID='5'
No ids to log.
UPDATE perch3_blog_posts SET postStatus='Published', postTemplate='post.html', postDescRaw='Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum.\r\n\r\nCras mattis consectetur purus sit amet fermentum. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.\r\n\r\nCurabitur blandit tempus porttitor. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Maecenas sed diam eget risus varius blandit sit amet non magna. Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.\r\n\r\nInteger posuere erat a ante venenatis dapibus posuere velit aliquet. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec sed odio dui. Curabitur blandit tempus porttitor. Maecenas faucibus mollis interdum. Curabitur blandit tempus porttitor. Cras mattis consectetur purus sit amet fermentum.\r\n\r\nMorbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.\r\n\r\nDonec sed odio dui. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Donec id elit non mi porta gravida at eget metus. Nulla vitae elit libero, a pharetra augue. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam quis risus eget urna mollis ornare vel eu leo.\r\n\r\nFusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Curabitur blandit tempus porttitor. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vestibulum id ligula porta felis euismod semper. Aenean lacinia bibendum nulla sed consectetur. Cras justo odio, dapibus ac facilisis in, egestas eget quam.', postDescHTML='<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum.</p>\n<p>Cras mattis consectetur purus sit amet fermentum. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.</p>\n<p>Curabitur blandit tempus porttitor. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Maecenas sed diam eget risus varius blandit sit amet non magna. Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.</p>\n<p>Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec sed odio dui. Curabitur blandit tempus porttitor. Maecenas faucibus mollis interdum. Curabitur blandit tempus porttitor. Cras mattis consectetur purus sit amet fermentum.</p>\n<p>Morbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.</p>\n<p>Donec sed odio dui. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Donec id elit non mi porta gravida at eget metus. Nulla vitae elit libero, a pharetra augue. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam quis risus eget urna mollis ornare vel eu leo.</p>\n<p>Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Curabitur blandit tempus porttitor. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vestibulum id ligula porta felis euismod semper. Aenean lacinia bibendum nulla sed consectetur. Cras justo odio, dapibus ac facilisis in, egestas eget quam.</p>', postTitle='new plans for malhere', postDynamicFields='{\"excerpt\":{\"_flang\":\"markdown\",\"raw\":\"Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum..\",\"processed\":\"<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum..<\\/p>\"},\"video\":{\"_flang\":\"plain\",\"raw\":\"\",\"processed\":\"\"},\"image\":{\"assetID\":\"719\",\"title\":\"IMG 0695\",\"_default\":\"\\/perch\\/resources\\/img0695.jpg\",\"bucket\":\"default\",\"path\":\"img0695.jpg\",\"size\":580651,\"w\":1728,\"h\":1152,\"mime\":\"image\\/jpeg\",\"sizes\":{\"thumb\":{\"w\":\"150\",\"h\":\"100\",\"target_w\":150,\"target_h\":150,\"density\":2,\"path\":\"img0695-thumb@2x.jpg\",\"size\":28535,\"mime\":\"image\\/jpeg\",\"assetID\":\"720\"},\"w800h600c1\":{\"w\":\"800\",\"h\":\"600\",\"target_w\":\"800\",\"target_h\":\"600\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w800h600.jpg\",\"size\":221057,\"mime\":\"\",\"assetID\":\"819\"},\"w350h250c1\":{\"w\":\"350\",\"h\":\"250\",\"target_w\":\"350\",\"target_h\":\"250\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w350h250.jpg\",\"size\":45075,\"mime\":\"\",\"assetID\":\"820\"},\"w350hc0\":{\"w\":\"350\",\"h\":\"233\",\"target_w\":\"350\",\"target_h\":false,\"crop\":false,\"density\":\"1\",\"path\":\"img0695-w350.jpg\",\"size\":38454,\"mime\":\"\",\"assetID\":\"821\"},\"w400h250c1\":{\"w\":\"400\",\"h\":\"250\",\"target_w\":\"400\",\"target_h\":\"250\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w400h250.jpg\",\"size\":50479,\"mime\":\"\",\"assetID\":\"822\"}}}}', postDateTime='2018-11-01 20:08:44', postSlug='2018-11-01-new-plans-for-malhere' WHERE postID='5'
No ids to log.
DELETE FROM perch3_blog_index WHERE itemKey='postID' AND itemID='5'
INSERT INTO perch3_blog_index (itemKey, itemID, indexKey, indexValue) VALUES ('postID',5,'excerpt','Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue'),('postID',5,'video',''),('postID',5,'image','/perch/resources/img0695.jpg'),('postID',5,'postID','5'),('postID',5,'blogID','1'),('postID',5,'postTitle','new plans for malhere'),('postID',5,'postSlug','2018-11-01-new-plans-for-malhere'),('postID',5,'postDateTime','2018-11-01 20:08:44'),('postID',5,'postDescRaw','Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue'),('postID',5,'postDescHTML','<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel au'),('postID',5,'postTags',''),('postID',5,'postStatus','Published'),('postID',5,'authorID','1'),('postID',5,'sectionID','1'),('postID',5,'postCommentCount','0'),('postID',5,'postImportID',''),('postID',5,'postLegacyURL',''),('postID',5,'postAllowComments','1'),('postID',5,'postTemplate','post.html'),('postID',5,'postMetaTemplate','post_meta.html'),('postID',5,'postIsPublished','0'),('postID',5,'itemID',''),('postID',5,'itemRowID',''),('postID',5,'postURL','/testimonials-news/2018-11-01-new-plans-for-malhere'),('postID',5,'postURLFull','https://malhere/testimonials-news/2018-11-01-new-plans-for-malhere'),('postID',5,'_id',5)
[1] OPTIMIZE TABLE perch3_blog_index
[nil] SELECT COUNT(*) AS qty, c.catID FROM perch3_blog_index i, perch3_categories c, perch3_blog_posts p WHERE i.indexValue=c.catPath AND i.indexKey='_category' AND i.itemKey='postID' AND i.itemID=p.postID AND p.postStatus='Published' AND p.postDateTime<='2018-11-01 20:08:00' GROUP BY i.indexValue, c.catID
DELETE FROM perch3_category_counts WHERE countType='blog.post'
[1] SELECT authorID, COUNT(*) AS qty FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2018-11-01 20:08:00' GROUP BY authorID
UPDATE perch3_blog_authors SET authorPostCount=0
UPDATE perch3_blog_authors SET authorPostCount='2' WHERE authorID=1 LIMIT 1
[1] SELECT c.sectionID, COUNT(p.postID) AS qty FROM perch3_blog_sections c, perch3_blog_posts p WHERE c.sectionID=p.sectionID AND p.postStatus='Published' AND p.postDateTime<='2018-11-01 20:08:00' GROUP BY c.sectionID ORDER BY c.sectionTitle ASC
UPDATE perch3_blog_sections SET sectionPostCount=0
UPDATE perch3_blog_sections SET sectionPostCount='2' WHERE sectionID='1' LIMIT 1
Edit mode: edit
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[2] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_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 perch3_menu_items WHERE itemType='app' AND itemValue='perch_blog' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_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 perch3_menu_items mi LEFT JOIN perch3_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/edit.post.php
[1] SELECT * FROM perch3_resources WHERE resourceID='719' LIMIT 1
Queries: 48
Memory: 4.6666

A second save, brings it back;

Debug Message - Perch 3.1.2
[1] SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='52c04c7dd4d29be55933c6cca84e7340' LIMIT 1
UPDATE perch3_users SET userHash='e1237ff35f8e751c429e3bddf75fe3ba' WHERE userID='1'
[31] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
Adding: Pipit Sharing
[8] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[0] SELECT COUNT(*) FROM perch3_blog_comments WHERE commentStatus='PENDING'
[1] SELECT * FROM perch3_blog_authors WHERE authorEmail='wayne@fullfatdesigns.co.uk' LIMIT 1
[1] SELECT * FROM perch3_blog_posts WHERE postID=5
[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
[1] SELECT * FROM perch3_blogs WHERE blogID=1 LIMIT 1
[1] SELECT * FROM perch3_blog_sections WHERE blogID='1' ORDER BY sectionTitle ASC
Using template: /templates/blog/post.html
[1] SELECT * FROM perch3_resources WHERE resourceID='719' LIMIT 1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceKey='thumb'
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceTargetWidth=800 AND resourceTargetHeight=600 AND resourceCrop=1 AND resourceDensity=1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceTargetWidth=350 AND resourceTargetHeight=250 AND resourceCrop=1 AND resourceDensity=1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceTargetWidth=350 AND resourceTargetHeight=0 AND resourceCrop=0 AND resourceDensity=1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='719' AND resourceTargetWidth=400 AND resourceTargetHeight=250 AND resourceCrop=1 AND resourceDensity=1
Logging resources for perch_blog
DELETE FROM perch3_resource_log WHERE appID='perch_blog' AND itemFK='postID' AND itemRowID=5
INSERT IGNORE INTO perch3_resource_log(`appID`, `itemFK`, `itemRowID`, `resourceID`) VALUES('perch_blog','postID',5,719),('perch_blog','postID',5,720),('perch_blog','postID',5,819),('perch_blog','postID',5,820),('perch_blog','postID',5,821),('perch_blog','postID',5,822)
UPDATE perch3_blog_posts SET postStatus='Published', postTemplate='post.html', postDescRaw='Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum.\r\n\r\nCras mattis consectetur purus sit amet fermentum. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.\r\n\r\nCurabitur blandit tempus porttitor. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Maecenas sed diam eget risus varius blandit sit amet non magna. Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.\r\n\r\nInteger posuere erat a ante venenatis dapibus posuere velit aliquet. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec sed odio dui. Curabitur blandit tempus porttitor. Maecenas faucibus mollis interdum. Curabitur blandit tempus porttitor. Cras mattis consectetur purus sit amet fermentum.\r\n\r\nMorbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.\r\n\r\nDonec sed odio dui. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Donec id elit non mi porta gravida at eget metus. Nulla vitae elit libero, a pharetra augue. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam quis risus eget urna mollis ornare vel eu leo.\r\n\r\nFusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Curabitur blandit tempus porttitor. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vestibulum id ligula porta felis euismod semper. Aenean lacinia bibendum nulla sed consectetur. Cras justo odio, dapibus ac facilisis in, egestas eget quam.', postDescHTML='<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum.</p>\n<p>Cras mattis consectetur purus sit amet fermentum. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.</p>\n<p>Curabitur blandit tempus porttitor. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Maecenas sed diam eget risus varius blandit sit amet non magna. Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.</p>\n<p>Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec sed odio dui. Curabitur blandit tempus porttitor. Maecenas faucibus mollis interdum. Curabitur blandit tempus porttitor. Cras mattis consectetur purus sit amet fermentum.</p>\n<p>Morbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.</p>\n<p>Donec sed odio dui. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Donec id elit non mi porta gravida at eget metus. Nulla vitae elit libero, a pharetra augue. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam quis risus eget urna mollis ornare vel eu leo.</p>\n<p>Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Curabitur blandit tempus porttitor. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vestibulum id ligula porta felis euismod semper. Aenean lacinia bibendum nulla sed consectetur. Cras justo odio, dapibus ac facilisis in, egestas eget quam.</p>', postTitle='new plans for malhere', postDynamicFields='{\"excerpt\":{\"_flang\":\"markdown\",\"raw\":\"Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum..\",\"processed\":\"<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum..<\\/p>\"},\"video\":{\"_flang\":\"plain\",\"raw\":\"\",\"processed\":\"\"},\"image\":{\"assetID\":\"719\",\"title\":\"IMG 0695\",\"_default\":\"\\/perch\\/resources\\/img0695.jpg\",\"bucket\":\"default\",\"path\":\"img0695.jpg\",\"size\":580651,\"w\":1728,\"h\":1152,\"mime\":\"image\\/jpeg\",\"sizes\":{\"thumb\":{\"w\":\"150\",\"h\":\"100\",\"target_w\":150,\"target_h\":150,\"density\":2,\"path\":\"img0695-thumb@2x.jpg\",\"size\":28535,\"mime\":\"image\\/jpeg\",\"assetID\":\"720\"},\"w800h600c1\":{\"w\":\"800\",\"h\":\"600\",\"target_w\":\"800\",\"target_h\":\"600\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w800h600.jpg\",\"size\":221057,\"mime\":\"\",\"assetID\":\"819\"},\"w350h250c1\":{\"w\":\"350\",\"h\":\"250\",\"target_w\":\"350\",\"target_h\":\"250\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w350h250.jpg\",\"size\":45075,\"mime\":\"\",\"assetID\":\"820\"},\"w350hc0\":{\"w\":\"350\",\"h\":\"233\",\"target_w\":\"350\",\"target_h\":false,\"crop\":false,\"density\":\"1\",\"path\":\"img0695-w350.jpg\",\"size\":38454,\"mime\":\"\",\"assetID\":\"821\"},\"w400h250c1\":{\"w\":\"400\",\"h\":\"250\",\"target_w\":\"400\",\"target_h\":\"250\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w400h250.jpg\",\"size\":50479,\"mime\":\"\",\"assetID\":\"822\"}}}}' WHERE postID='5'
No ids to log.
UPDATE perch3_blog_posts SET postStatus='Published', postTemplate='post.html', postDescRaw='Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum.\r\n\r\nCras mattis consectetur purus sit amet fermentum. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.\r\n\r\nCurabitur blandit tempus porttitor. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Maecenas sed diam eget risus varius blandit sit amet non magna. Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.\r\n\r\nInteger posuere erat a ante venenatis dapibus posuere velit aliquet. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec sed odio dui. Curabitur blandit tempus porttitor. Maecenas faucibus mollis interdum. Curabitur blandit tempus porttitor. Cras mattis consectetur purus sit amet fermentum.\r\n\r\nMorbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.\r\n\r\nDonec sed odio dui. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Donec id elit non mi porta gravida at eget metus. Nulla vitae elit libero, a pharetra augue. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam quis risus eget urna mollis ornare vel eu leo.\r\n\r\nFusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Curabitur blandit tempus porttitor. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vestibulum id ligula porta felis euismod semper. Aenean lacinia bibendum nulla sed consectetur. Cras justo odio, dapibus ac facilisis in, egestas eget quam.', postDescHTML='<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum.</p>\n<p>Cras mattis consectetur purus sit amet fermentum. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis. Integer posuere erat a ante venenatis dapibus posuere velit aliquet.</p>\n<p>Curabitur blandit tempus porttitor. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Maecenas sed diam eget risus varius blandit sit amet non magna. Curabitur blandit tempus porttitor. Maecenas sed diam eget risus varius blandit sit amet non magna. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.</p>\n<p>Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Sed posuere consectetur est at lobortis. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Donec sed odio dui. Curabitur blandit tempus porttitor. Maecenas faucibus mollis interdum. Curabitur blandit tempus porttitor. Cras mattis consectetur purus sit amet fermentum.</p>\n<p>Morbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum. Donec ullamcorper nulla non metus auctor fringilla.</p>\n<p>Donec sed odio dui. Praesent commodo cursus magna, vel scelerisque nisl consectetur et. Donec id elit non mi porta gravida at eget metus. Nulla vitae elit libero, a pharetra augue. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Nullam quis risus eget urna mollis ornare vel eu leo.</p>\n<p>Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Curabitur blandit tempus porttitor. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vestibulum id ligula porta felis euismod semper. Aenean lacinia bibendum nulla sed consectetur. Cras justo odio, dapibus ac facilisis in, egestas eget quam.</p>', postTitle='new plans for malhere', postDynamicFields='{\"excerpt\":{\"_flang\":\"markdown\",\"raw\":\"Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum..\",\"processed\":\"<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cras mattis consectetur purus sit amet fermentum..<\\/p>\"},\"video\":{\"_flang\":\"plain\",\"raw\":\"\",\"processed\":\"\"},\"image\":{\"assetID\":\"719\",\"title\":\"IMG 0695\",\"_default\":\"\\/perch\\/resources\\/img0695.jpg\",\"bucket\":\"default\",\"path\":\"img0695.jpg\",\"size\":580651,\"w\":1728,\"h\":1152,\"mime\":\"image\\/jpeg\",\"sizes\":{\"thumb\":{\"w\":\"150\",\"h\":\"100\",\"target_w\":150,\"target_h\":150,\"density\":2,\"path\":\"img0695-thumb@2x.jpg\",\"size\":28535,\"mime\":\"image\\/jpeg\",\"assetID\":\"720\"},\"w800h600c1\":{\"w\":\"800\",\"h\":\"600\",\"target_w\":\"800\",\"target_h\":\"600\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w800h600.jpg\",\"size\":221057,\"mime\":\"\",\"assetID\":\"819\"},\"w350h250c1\":{\"w\":\"350\",\"h\":\"250\",\"target_w\":\"350\",\"target_h\":\"250\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w350h250.jpg\",\"size\":45075,\"mime\":\"\",\"assetID\":\"820\"},\"w350hc0\":{\"w\":\"350\",\"h\":\"233\",\"target_w\":\"350\",\"target_h\":false,\"crop\":false,\"density\":\"1\",\"path\":\"img0695-w350.jpg\",\"size\":38454,\"mime\":\"\",\"assetID\":\"821\"},\"w400h250c1\":{\"w\":\"400\",\"h\":\"250\",\"target_w\":\"400\",\"target_h\":\"250\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"img0695-w400h250.jpg\",\"size\":50479,\"mime\":\"\",\"assetID\":\"822\"}}}}', postDateTime='2018-11-01 20:11:57', postSlug='2018-11-01-new-plans-for-malhere' WHERE postID='5'
No ids to log.
DELETE FROM perch3_blog_index WHERE itemKey='postID' AND itemID='5'
INSERT INTO perch3_blog_index (itemKey, itemID, indexKey, indexValue) VALUES ('postID',5,'excerpt','Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue'),('postID',5,'video',''),('postID',5,'image','/perch/resources/img0695.jpg'),('postID',5,'postID','5'),('postID',5,'blogID','1'),('postID',5,'postTitle','new plans for malhere'),('postID',5,'postSlug','2018-11-01-new-plans-for-malhere'),('postID',5,'postDateTime','2018-11-01 20:11:57'),('postID',5,'postDescRaw','Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel augue'),('postID',5,'postDescHTML','<p>Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Sed posuere consectetur est at lobortis. Curabitur blandit tempus porttitor. Vestibulum id ligula porta felis euismod semper. Vivamus sagittis lacus vel au'),('postID',5,'postTags',''),('postID',5,'postStatus','Published'),('postID',5,'authorID','1'),('postID',5,'sectionID','1'),('postID',5,'postCommentCount','0'),('postID',5,'postImportID',''),('postID',5,'postLegacyURL',''),('postID',5,'postAllowComments','1'),('postID',5,'postTemplate','post.html'),('postID',5,'postMetaTemplate','post_meta.html'),('postID',5,'postIsPublished','0'),('postID',5,'itemID',''),('postID',5,'itemRowID',''),('postID',5,'postURL','/testimonials-news/2018-11-01-new-plans-for-malhere'),('postID',5,'postURLFull','https://malhere/testimonials-news/2018-11-01-new-plans-for-malhere'),('postID',5,'_id',5)
[1] OPTIMIZE TABLE perch3_blog_index
[nil] SELECT COUNT(*) AS qty, c.catID FROM perch3_blog_index i, perch3_categories c, perch3_blog_posts p WHERE i.indexValue=c.catPath AND i.indexKey='_category' AND i.itemKey='postID' AND i.itemID=p.postID AND p.postStatus='Published' AND p.postDateTime<='2018-11-01 20:11:00' GROUP BY i.indexValue, c.catID
DELETE FROM perch3_category_counts WHERE countType='blog.post'
[1] SELECT authorID, COUNT(*) AS qty FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2018-11-01 20:11:00' GROUP BY authorID
UPDATE perch3_blog_authors SET authorPostCount=0
UPDATE perch3_blog_authors SET authorPostCount='2' WHERE authorID=1 LIMIT 1
[1] SELECT c.sectionID, COUNT(p.postID) AS qty FROM perch3_blog_sections c, perch3_blog_posts p WHERE c.sectionID=p.sectionID AND p.postStatus='Published' AND p.postDateTime<='2018-11-01 20:11:00' GROUP BY c.sectionID ORDER BY c.sectionTitle ASC
UPDATE perch3_blog_sections SET sectionPostCount=0
UPDATE perch3_blog_sections SET sectionPostCount='2' WHERE sectionID='1' LIMIT 1
Edit mode: edit
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[2] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_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 perch3_menu_items WHERE itemType='app' AND itemValue='perch_blog' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_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 perch3_menu_items mi LEFT JOIN perch3_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/edit.post.php
[1] SELECT * FROM perch3_resources WHERE resourceID='719' LIMIT 1
Queries: 48
Memory: 4.6666
Wayne Hooper

Wayne Hooper 6 points

2 years ago

Does anything look a problem from the debugs? I didn't see anything that jumped out to me...