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!