Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
By smassain
#2232
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? :oops:
Thanks
User avatar
By RussH
#2233
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;
--

This is the "import from resume"[…]

EMAIL CONFIGURATION

Hi, the email configuration (including different[…]

as the title says...

It's essential to keep these synchronized to ensur[…]