opencats.org

hi, when we try to manipulate mass import files wh´re havig the following error message
MySQL Query Failed: Unknown column 'stored_on_s3' in 'field list'

SELECT
attachment_id as attachmentID,
site_id as siteID,
title,
original_filename as originalFileName,
stored_filename as storedFileName,
content_type as contentType,
resume,
text,
date_created as dateCreated,
date_modified as dateModified,
directory_name as directoryName,
file_size_kb as fileSizeKB,
stored_on_s3 as storedOnS3,
stored_locally as storedLocally
FROM
attachment
WHERE
data_item_type = 500
AND
site_id = 1
any idea what could be the inconvenient?
Thanks

stored_on_s3 as storedOnS3,yes for some reason this field was introduced during the 0.9.2, it's there in error. This can be fixed by

execute the following queries in MySQL:

ALTER TABLE `attachment` ADD COLUMN `stored_on_s3` tinyint(1) default 0;
ALTER TABLE `attachment` ADD COLUMN `stored_locally` tinyint(1) default 0;
--