Disappearing assets

aulda · Feb 2nd 2019

We have just started adding the main content to a new website I build using perch and I have just got some users going adding some image files and sub pages to a directory part of the site. Things were going fine yesterday but then I notice today that some of the images uploaded into the assets and used on the site have now disappeared. They are still listed in the assets but not visible as images on the pages where they are used. You can still download the original files so the assets still exist. Any clues why this might have happened?

Here is a screenshot of the assets page on the CMS.

The CMS debug below seems free of errors:

Code

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='c2a30879c13207f5e7093204850aba89' LIMIT 1
UPDATE perch3_users SET userHash='8a9eea7877b381d8a066444bb3eaa16e' WHERE userID='1'
[40] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[12] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[3] SELECT DISTINCT resourceBucket FROM perch3_resources WHERE resourceAWOL=0 AND resourceType !=""
[30] SELECT SQL_CALC_FOUND_ROWS DISTINCT r1.* FROM perch3_resources r1 WHERE r1.resourceKey='orig' AND r1.resourceAWOL=0 AND r1.resourceBucket IN ('Adverts', 'Main-Images', 'admin', 'default') ORDER BY r1.resourceUpdated DESC, r1.resourceID DESC LIMIT 0, 30
[71] SELECT FOUND_ROWS() AS `count`
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=380 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=376 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=371 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=368 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=364 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=360 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=354 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=350 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=347 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=346 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=343 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=335 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=334 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=333 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=329 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=327 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=319 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=311 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=303 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=295 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=287 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=279 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=271 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=263 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=255 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=247 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=239 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=231 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=223 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=215 AND resourceKey='thumb' AND resourceAWOL!=1 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 0, 1
[7] 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='assets' 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: /core/apps/assets/modes/list.post.php
[5] SELECT DISTINCT resourceType FROM perch3_resources WHERE resourceAWOL=0 AND resourceType !="" ORDER BY resourceType ASC
[3] SELECT DISTINCT resourceBucket FROM perch3_resources WHERE resourceAWOL=0 AND resourceType !=""
[nil] SELECT t.tagTitle, t.tagSlug, t.tagCount FROM perch3_resource_tags t WHERE tagCount > 0 GROUP BY t.tagID ORDER BY t.tagCount DESC LIMIT 40
Queries: 46
Memory: 2.5961

Display More

And so does the debug on a page where the asset should be appearing.

aulda · Feb 2nd 2019

Here is the debug from the page itself.

Code

Debug Message - Perch 3.1.2
[40] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_pages WHERE pagePath='/accommodation/index.php' LIMIT 1
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
[9] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/accommodation/index.php' OR regionPage='*' ORDER BY regionPage DESC
[6] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/accommodation/index.php' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
[6] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/accommodation/index.php' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/dropdownnav.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='adverts' LIMIT 1
[78] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=4 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[1] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=4 AND p.pagePath='/accommodation/index.php' LIMIT 1
[1] SELECT pageID FROM perch3_navigation_pages WHERE groupID=4 AND pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
[15] Using template: /templates/navigation/item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-navigation' LIMIT 1
[5] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/accommodation/index.php' LIMIT 1
[5] Using template: /templates/navigation/footernav.html
[2] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2019-02-02 17:28:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 2
[1] SELECT FOUND_ROWS() AS `count`
[2] Using template: /templates/blog/post_exerpt_in_list.html
[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC

Display More

drewm · Feb 3rd 2019

It's odd that both the files are there and the database records are there, but they're not showing. I've not seen that before.

Are you getting any errors in your browser console?

aulda · Feb 5th 2019

No errors in the browser console.

I deleted the blank assets and reloaded them. Then re-added them to the pages. Obviously that all worked fine.

The problem hasn't re-occurred today.

drewm · Feb 5th 2019

So would it be accurate to say that there's now no error state that we can meaningfully debug?

aulda · Feb 5th 2019

That would be accurate, though as we are loading content very actively for the next week, could you leave this thread open for a couple of days just in case the glitch re-occurs and I can capture some definitive error message?

Thanks

drewm Feb 2nd 2019