We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Problem, Field-Types

Database not recording assets

I have an issue with a new site I am building. It is still in the development stage however I have run into a problem that I have not encountered before with other Perch installs.

My problem is that I find that Perch is not writing the assets to the database. I tried uploading an image both through an image field type and directly through the Asset Page. At first it will show a thumbnail of the image before it processes. Once the processing happens, the thumbnail goes away, but does not appear in the Assets. I checked the resource folder on the server and the upload is successful even when a crop is coded. To ensure the file was good I downloaded it and there were no issues with the file. I searched to see if there were any similar problems with solutions and did what I could. One thread that I found said to change a value in the resourceAWOL column but when I looked that's when I discovered there was nothing in the resources table.

All the other data text data was captured fine without issue.

Here is the diagnostic

Health check

Perch is up to date
PHP 5.6.21 is up to date
MySQL 5.1.72-rel14.10 is up to date
Image processing available

Summary information

Perch: 2.8.34, PHP: 5.6.21, MySQL: 5.5.53, with PDO
Server OS: Linux, cgi-fcgi
Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), perch_blog (5.0)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_blog', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /nfs/c06/h02/mnt/157634/domains/prchdev.silentoutsidr.gallery/html/perch
PERCH_CORE: /nfs/c06/h02/mnt/157634/domains/prchdev.silentoutsidr.gallery/html/perch/core
PERCH_RESFILEPATH: /nfs/c06/h02/mnt/157634/domains/prchdev.silentoutsidr.gallery/html/perch/resources
Image manipulation: GD
PHP limits: Max upload 99M, Max POST 99M, Memory: 99M, Total max file upload: 99M
F1: 6a33f95eca3667f9e0c39bf5ca2980fe
Resource folder writeable: Yes
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
REQUEST_URI: /perch/core/settings/diagnostics/
DOCUMENT_ROOT: /home/157634/domains/prchdev.silentoutsidr.gallery/html
HTTP_HOST: prchdev.silentoutsidr.gallery
Andrew Kennedy

Andrew Kennedy 0 points

  • 2 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Was this a fresh install of 2.8.34?

Yes it was a fresh install.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Has this always been the case or did it start happening at some point?

It has always been the case with this install.

Drew McLellan

Drew McLellan 2638 points
Perch Support

If you turn on debug and replace an image within the Assets app, what does the debug output say?

It appears there are a few missing columns.

[34] SELECT p.privKey FROM perch2_user_privileges p [12] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID 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' [12] 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 !="" Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'resourceAWOL' in 'where clause' Queries: 6 Memory: 1.1632

Drew McLellan

Drew McLellan 2638 points
Perch Support

Did you get any errors during setup?

Aside from typo or 2 when entering the credentials for install no.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you try doing a force-update by visiting this path in your site?

/perch/core/update/?force=update

I tried that. It seemed to have worked partially, it now registers in assets but does not show a preview image of the asset. Is that normal?

Here is what debug returned upon the forced update. There were a lot of duplicate column errors, which I assume would be normal for the forced update?

SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0 [1] SHOW TABLES LIKE 'perch2_resource_log' ALTER TABLE perch2_resources ADD resourceCreated DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00' AFTER resourceType ALTER TABLE perch2_resources ADD resourceUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER resourceCreated ALTER TABLE perch2_resources ADD resourceAWOL TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceUpdated ALTER TABLE perch2_resources ADD INDEX idx_awol (resourceAWOL) ALTER TABLE perch2_resources ADD resourceTitle CHAR(255) NULL DEFAULT NULL AFTER resourceAWOL ALTER TABLE perch2_resources ADD resourceFileSize INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTitle ALTER TABLE perch2_resources ADD resourceWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceFileSize ALTER TABLE perch2_resources ADD resourceHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceWidth ALTER TABLE perch2_resources ADD resourceCrop TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceHeight ALTER TABLE perch2_resources ADD resourceDensity FLOAT NOT NULL DEFAULT '1' AFTER resourceCrop ALTER TABLE perch2_resources ADD resourceTargetWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceDensity ALTER TABLE perch2_resources ADD resourceTargetHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTargetWidth ALTER TABLE perch2_resources ADD resourceMimeType CHAR(64) NULL DEFAULT NULL AFTER resourceTargetHeight ALTER TABLE perch2_resources ADD FULLTEXT INDEX idx_search (resourceTitle) ALTER TABLE perch2_resources ADD resourceInLibrary TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceMimeType ALTER TABLE perch2_resources ADD INDEX idx_library (resourceInLibrary) CREATE TABLE IF NOT EXISTS perch2_resource_tags ( tagID INT(10) NOT NULL AUTO_INCREMENT, tagTitle VARCHAR(255) NOT NULL DEFAULT '', tagSlug VARCHAR(255) NOT NULL DEFAULT '', tagCount int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (tagID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC CREATE TABLE IF NOT EXISTS perch2_resources_to_tags ( resourceID int(10) NOT NULL DEFAULT '0', tagID int(10) NOT NULL DEFAULT '0', PRIMARY KEY (resourceID,tagID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED CREATE TABLE IF NOT EXISTS perch2_resource_log ( logID int(10) unsigned NOT NULL AUTO_INCREMENT, appID char(32) NOT NULL DEFAULT 'content', itemFK char(32) NOT NULL DEFAULT 'itemRowID', itemRowID int(10) unsigned NOT NULL DEFAULT '0', resourceID int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (logID), KEY idx_resource (resourceID), KEY idx_fk (itemFK,itemRowID), UNIQUE KEY idx_uni (appID,itemFK,itemRowID,resourceID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('assets.create','Upload assets',1) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'assets.create' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('assets.manage','Manage assets',2) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'assets.manage' for key 'idx_key' CREATE TABLE IF NOT EXISTS perch2_categories ( catID int(10) NOT NULL AUTO_INCREMENT, setID int(10) unsigned NOT NULL, catParentID int(10) unsigned NOT NULL DEFAULT '0', catTitle char(64) NOT NULL DEFAULT '', catSlug char(64) NOT NULL DEFAULT '', catPath char(255) NOT NULL DEFAULT '', catDisplayPath char(255) NOT NULL DEFAULT '', catOrder int(10) unsigned NOT NULL DEFAULT '0', catTreePosition char(255) NOT NULL DEFAULT '000', catDynamicFields text NOT NULL, PRIMARY KEY (catID), KEY idx_set (setID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE IF NOT EXISTS perch2_category_sets ( setID int(10) NOT NULL AUTO_INCREMENT, setTitle char(64) NOT NULL DEFAULT '', setSlug char(64) NOT NULL DEFAULT '', setTemplate char(255) NOT NULL DEFAULT 'set.html', setCatTemplate char(255) NOT NULL DEFAULT 'category.html', setDynamicFields text, PRIMARY KEY (setID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.create','Create new categories',1) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.create' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.delete','Delete categories',2) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.delete' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.manage','Manage categories',3) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.manage' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.sets.create','Create category sets',4) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.sets.create' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.sets.delete','Delete category sets',5) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.sets.delete' for key 'idx_key' CREATE TABLE IF NOT EXISTS perch2_resource_log ( logID int(10) unsigned NOT NULL AUTO_INCREMENT, appID char(32) NOT NULL DEFAULT 'content', itemFK char(32) NOT NULL DEFAULT 'itemRowID', itemRowID int(10) unsigned NOT NULL DEFAULT '0', resourceID int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (logID), KEY idx_resource (resourceID), KEY idx_fk (itemFK,itemRowID), UNIQUE KEY idx_uni (appID,itemFK,itemRowID,resourceID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ALTER TABLE perch2_content_regions ADD regionUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER regionEditRoles Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'regionUpdated' ALTER TABLE perch2_content_items ADD itemUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER itemSearch Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'itemUpdated' ALTER TABLE perch2_content_items ADD itemUpdatedBy CHAR(32) NOT NULL DEFAULT '' AFTER itemUpdated Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'itemUpdatedBy' ALTER TABLE perch2_pages ADD pageTemplate CHAR(255) NOT NULL DEFAULT '' AFTER pageAttributeTemplate Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageTemplate' ALTER TABLE perch2_pages ADD templateID INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER pageTemplate Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'templateID' ALTER TABLE perch2_pages ADD pageSubpageTemplates VARCHAR(255) NOT NULL DEFAULT '' AFTER templateID Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageSubpageTemplates' ALTER TABLE perch2_pages ADD pageCollections VARCHAR(255) NOT NULL DEFAULT '' AFTER pageSubpageTemplates Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageCollections' CREATE TABLE IF NOT EXISTS perch2_category_counts ( countID int(10) unsigned NOT NULL AUTO_INCREMENT, catID int(10) unsigned NOT NULL, countType char(64) NOT NULL DEFAULT '', countValue int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (countID), KEY idx_cat (catID), KEY idx_cat_type (countType,catID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ALTER TABLE perch2_categories CHANGE catDisplayPath catDisplayPath CHAR(255) NOT NULL DEFAULT '' -- DROP INDEX idx_uni ON perch2_resource_log ALTER TABLE perch2_resource_log ADD UNIQUE INDEX idx_uni (appID, itemFK, itemRowID, resourceID) Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_uni' ALTER TABLE perch2_users ADD userPasswordToken CHAR(255) NOT NULL DEFAULT 'expired' AFTER userMasterAdmin Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userPasswordToken' ALTER TABLE perch2_users ADD userPasswordTokenExpires DATETIME NOT NULL DEFAULT '2015-01-01 00:00:00' AFTER userPasswordToken Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userPasswordTokenExpires' CREATE TABLE IF NOT EXISTS perch2_user_passwords ( passwordID int(10) unsigned NOT NULL AUTO_INCREMENT, userID int(10) unsigned NOT NULL, userPassword varchar(255) NOT NULL DEFAULT '', passwordLastUsed datetime NOT NULL DEFAULT '2000-01-01 00:00:00', PRIMARY KEY (passwordID), KEY idx_user (userID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ALTER TABLE perch2_users ADD userLastFailedLogin DATETIME NULL AFTER userPasswordTokenExpires Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userLastFailedLogin' ALTER TABLE perch2_users ADD userFailedLoginAttempts INT(0) UNSIGNED NOT NULL DEFAULT '0' AFTER userLastFailedLogin Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userFailedLoginAttempts' ALTER TABLE perch2_resources ADD INDEX idx_list (resourceParentID, resourceKey, resourceAWOL) [1] SHOW TABLES LIKE 'perch2_resource_log' [0] SELECT COUNT(*) FROM perch2_resource_log [nil] SELECT resourceID FROM perch2_resources WHERE resourceID NOT IN (SELECT resourceID FROM perch2_resource_log) [1] SHOW TABLES LIKE 'perch2_content_index' CREATE TABLE IF NOT EXISTS perch2_content_index ( indexID int(10) NOT NULL AUTO_INCREMENT, itemID int(10) NOT NULL DEFAULT '0', regionID int(10) NOT NULL DEFAULT '0', pageID int(10) NOT NULL DEFAULT '0', itemRev int(10) NOT NULL DEFAULT '0', indexKey char(64) NOT NULL DEFAULT '-', indexValue char(255) NOT NULL DEFAULT '', PRIMARY KEY (indexID), KEY idx_key (indexKey), KEY idx_val (indexValue), KEY idx_rev (itemRev), KEY idx_item (itemID), KEY idx_keyval (indexKey,indexValue), KEY idx_regrev (regionID,itemRev) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE IF NOT EXISTS perch2_resources ( resourceID int(10) unsigned NOT NULL AUTO_INCREMENT, resourceApp char(32) NOT NULL DEFAULT 'content', resourceBucket char(16) NOT NULL DEFAULT 'default', resourceFile char(255) NOT NULL DEFAULT '', resourceKey enum('orig','thumb') DEFAULT NULL, resourceParentID int(10) NOT NULL DEFAULT '0', resourceType char(4) NOT NULL DEFAULT '', PRIMARY KEY (resourceID), UNIQUE KEY idx_file (resourceBucket,resourceFile), KEY idx_app (resourceApp), KEY idx_key (resourceKey), KEY idx_type (resourceType) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ALTER TABLE perch2_content_items ADD INDEX idx_regrev USING BTREE (itemID, regionID, itemRev) Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_regrev' ALTER TABLE perch2_content_items ADD INDEX idx_order USING BTREE (itemOrder) Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_order' ALTER TABLE perch2_content_regions ADD INDEX idx_key USING BTREE (regionKey) Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_key' ALTER TABLE perch2_content_regions ADD INDEX idx_path USING BTREE (regionPage) Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_path' ALTER TABLE perch2_page_templates ADD templateNavGroups VARCHAR(255) NULL DEFAULT '' AFTER templateReference Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'templateNavGroups' CREATE TABLE IF NOT EXISTS perch2_navigation ( groupID int(10) NOT NULL AUTO_INCREMENT, groupTitle varchar(255) NOT NULL DEFAULT '', groupSlug varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (groupID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE IF NOT EXISTS perch2_navigation_pages ( navpageID int(10) unsigned NOT NULL AUTO_INCREMENT, pageID int(10) unsigned NOT NULL DEFAULT '0', groupID int(10) unsigned NOT NULL DEFAULT '0', pageParentID int(10) unsigned NOT NULL DEFAULT '0', pageOrder int(10) unsigned NOT NULL DEFAULT '1', pageDepth tinyint(10) unsigned NOT NULL, pageTreePosition varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (navpageID), KEY idx_group (groupID), KEY idx_page_group (pageID,groupID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC ALTER TABLE perch2_user_privileges ADD UNIQUE INDEX idx_key (privKey) Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.navgroups.configure','Configure navigation groups',7), ('content.navgroups.create','Create navigation groups',8), ('content.navgroups.delete','Delete navigation groups',9) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.navgroups.configure' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.create.toplevel','Add new top-level pages',3) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.create.toplevel' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.delete.own','Delete pages they created themselves',4) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.delete.own' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.templates.configure','Configure master pages',6) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.templates.configure' for key 'idx_key' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.republish','Republish pages', 12) ALTER TABLE perch2_pages ADD pageAccessTags VARCHAR(255) NOT NULL DEFAULT '' AFTER pageNavOnly Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAccessTags' ALTER TABLE perch2_pages ADD pageCreatorID INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER pageAccessTags Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageCreatorID' ALTER TABLE perch2_pages ADD pageModified DATETIME NOT NULL DEFAULT '2014-01-01 00:00:00' AFTER pageCreatorID Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageModified' ALTER TABLE perch2_pages ADD pageAttributes TEXT NOT NULL AFTER pageModified Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAttributes' ALTER TABLE perch2_pages ADD pageAttributeTemplate VARCHAR(255) NOT NULL DEFAULT 'default.html' AFTER pageAttributes Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAttributeTemplate' INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.attributes','Edit page titles and attributes',6) Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.attributes' for key 'idx_key' CREATE TABLE IF NOT EXISTS perch2_user_role_privileges ( roleID int(10) unsigned NOT NULL, privID int(10) unsigned NOT NULL, PRIMARY KEY (roleID,privID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 DELETE FROM perch2_settings WHERE settingID='update_2.8.34' AND userID=0 LIMIT 1 INSERT INTO perch2_settings(settingID,settingValue,userID) VALUES('update_2.8.34','done',0)

I tried uploading through an image field as well. That doesn't work as intended either. The upload works, it recognizes the asset being linked to it. I can see it on the page when looking at the site.

However, after adding the image the image field does not change from "Select or upload an image" to what the file attached actually is. Nor does it indicate what file is attached in the asset panel when I click on the link to select or upload an image. The asset panel doesn't show preview images either, just the names like the asset page / library.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yes, you'd expect the SQL errors, as the update tried to reinforce the state of the DB. Looks like it did fix some things though.

Do you have much content entered into this install? It sounds like something's fairly seriously wrong here.

No content really. Just started integrating perch into the design and inserting filler content to make sure it works correctly.

I take it just do a reinstall of Perch.

Drew McLellan

Drew McLellan 2638 points
Perch Support

I would drop the database tables and do a fresh install. Keep a close eye for any errors either on the page on in the log.

The reinstall worked. Thanks for the help.

I have come across another problem with my assets that was stated in this thread. Any new image assets I upload are again not displaying a preview thumbnail in the Assets page or panel. In addition to that the upload field does not display the file that is chosen but "Select File To Upload" instead. That new chosen asset also displays just fine on the front end. However, I looked in the database and the asset is being recorded and the file is successfully processed to the resources folder.

I do want to mention prior to this I did upload 2 assets to make sure everything worked after the reinstall. Those 2 assets display as expected. I don't know what could of happened to cause the problem. I was just working with my HTML templates when it stopped working after I updated.

Do you have any idea why Perch would suddenly stop displaying previews for new assets and show them as the chosen file for the field even when it seems to be recorded every where else?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Perch is a set of deterministic code, so it won't suddenly do anything different - it something has changed then it's in the environment. Have you checked the basics like available disk space?

I checked the environment and nothing has changed there either from what I can tell. Disk space 500mb used of 100 gb is a non issue and the same with bandwidth. All the sites I have are not big and don't draw a lot of traffic.

I turned on debug and didn't notice any errors reported from Perch. It's just odd how the assets work initially as expected then new assets don't show previews but are written to and read from the database, show up on the front-end, and processed to the server yet don't show up in the field they were inserted nor display a preview. Something is amiss somewhere and I'm not sure where to look. I have only a basic understand of programming and servers. So troubleshooting on my own is difficult.

Drew McLellan

Drew McLellan 2638 points
Perch Support

What's changed between when it was working and now?

I was working on some of my templates. The field that I was trying to upload through didn't have a label so I added one for clarity. Initially I used the same value for the label as I did the id. After my last post I tried changing the label and even id and tried uploading again, but still had the same result.

I didn't write or upload any php that was out of the ordinary either.