[zoomiest]

Hello all.

I had previously uploaded a stack up resumes. They were not all converted to candidates. I have gone back to upload some more, and the wizard seems to have an issue - it never showed me where to specify the upload directory...

But the major point was that when I went to go rescan the directory, I got the following error.

Code: Select all

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

General Information
PHP Version: 5.2.4-2ubuntu5.4
Database Version: MySQL 5.0.51a-3ubuntu5.4
Installation Directory: /var/www/opencats

Any thoughts on how I can a get those new resumes into CATS?

[RussH]

Hiya,

I just uploaded some resume's (C.V's) last month.. but what version of cats/opencats are you running?

[cards]

Did you ever find a resolution for this problem? I'm getting the same error when trying to delete the bulk imported resumes that were not converted to candidates.

[sbsnz]

I have the same issue:

When I try to rescan or delete the ones that did not recognise in import. It says:

You have uploaded 7 unclassified resume documents. You can search these documents; but, they are not attached to candidates because candidate information (like their name, address, etc.) was not available when they were uploaded.

Rescan the documents to try to automatically detect candidate information. Enter it manually if necessary.

--> It shows me the below error if I try to rescan or delete the resumes.

HELP

Query Error -- Report to System Administrator ASAP


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


using CATS Version 0.9.1 (Beas).

[sand]

Hi,
I had the same problem and solved it with this:
ALTER TABLE cats.attachment ADD (stored_on_s3 BOOL DEFAULT FALSE);
ALTER TABLE cats.attachment ADD (stored_locally BOOL DEFAULT TRUE);

I run 0.9.2 Diablo
Best regards,

Ralf