Forum
Uploaded asset does not save, can't see any assets after upgrade.
Recently upgraded from Perch 2.08 to Perch Perch: 2.8.13
There were a couple of warnings on upgrade - have seen similar ones before and ignored with all being well. But this time the thing that is not working is uploading Assets. It starts uploading, completes but shows nothing, no thumb no asset saved.
Also, no current resources are showing in Assets.
If I go to Assets "app" I see these errors with debug turned on:
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=1 AND u.userHash='77624445be04dcfce8e8a5b2971b536c' LIMIT 1
UPDATE perch2_users SET userHash='4045e7840f6e28b62575daea1bfa38c4' WHERE userID='1'
SELECT p.privKey FROM perch2_user_privileges p
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
Adding: MailChimp
SELECT SQL_CALC_FOUND_ROWS DISTINCT r1.*, r2.resourceFile AS thumb, r2.resourceWidth AS thumbWidth, r2.resourceHeight AS thumbHeight, r2.resourceDensity AS thumbDensity FROM perch2_resources r1 LEFT OUTER JOIN perch2_resources r2 ON r2.resourceParentID=r1.resourceID AND r2.resourceKey='thumb' AND r2.resourceAWOL!=1 WHERE r1.resourceKey='orig' AND r1.resourceAWOL=0 ORDER BY r1.resourceUpdated DESC, r1.resourceID DESC LIMIT 0, 30
Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r2.resourceWidth' in 'field list'
SELECT FOUND_ROWS() AS `count`
SELECT DISTINCT resourceType FROM perch2_resources WHERE resourceAWOL=0 AND resourceType !="" ORDER BY resourceType ASC
Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'resourceAWOL' in 'where clause'
SELECT DISTINCT resourceBucket FROM perch2_resources WHERE resourceAWOL=0 AND resourceType !="" ORDER BY resourceType ASC
Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'resourceAWOL' in 'where clause'
Queries: 6
Memory: 2.0886
When I checked error logs, I see:
(13)Permission denied: /home/xxx/public_html/stage/cms/resources/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable, referer: https://stage.xxx.com.au/cms/core/apps/assets/
Never seen this before, not sure what Perch needs with htaccess file but I set folder permissions on resources folder to 666.
I saved install warnings as a PDF if you want to see - can email.
Any help much appreciated!
Cheers, Stuart.
FYI - the images do actually save on the server - can see them in FTP. They are getting processed to as per template settings...
Can you try rerunning the update? This time please note any message you get rather than just clearing them.
OK, done... these are the messages:
Did you get any messages other than debug information?
Yes, just "Successfully updated to version 2.8.13."
Does the issue persist?
Issue was persisting but slightly differently - the placeholder on upload was now showing in Assets but the image was still broken in CMS and in front end.
So I changed the folder permissions on "resources" to 755 and it now works!!
Can we expect current images already uploaded show up in Assets? Should we force another update to do this??
I saved an Event and the images on this entry then showed up in Assets. So I assume the best option is to do a "Republish"?
Try a republish and see if that helps.
Global republish didn't work.... but publishing individual pages does - it updates Assets with any images used on page. A bit annoying but it's a small site so all good.
So that force update did the trick, in combination with permission check/change on folder.
Thanks!