opencats.org

I have been breaking my head over this for the last few months..

When I export candidates out - I get first / last name, email, skills, ID #, etc.. I am trying to modify it so that I can export some custom fields for candidates also (particularly: If candidate is OK to relocate and If he is OK to work contract or permanent).

Merci tout le monde.

Alex

you're exporting to another application? Unless you get the app changed, you'd be better off exporting from the database directly using a query on a separate webpage, or from PhpMyAdmin...

Russ

and 0.9.1 installation error

I had previously installed and used v.8 successfully. But when I tried a fresh install of v.9 I my install went smoothly until I was prompted to start the app, and that's when I go a page full of errors - apparently having to do with SQL tables. I tried to upgrade my .8 version to v.91 (using the release candidate supplied somewhere in the forum, but I got the same errors. Can someone help me please. My vital stats are - WAMP, MySQL5, PHP5.... Here's the offending transcript:


Query Error -- Report to System Administrator ASAP

MySQL Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';

INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Left', ''' at line 1

DELETE FROM `career_portal_template`;

INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Left', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Footer', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Header', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Main', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'CSS', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Search Results', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Questionnaire', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Job Details', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Thanks for your Submission', '');
INSERT INTO `career_portal_template` VALUES (null, 'Blank Page', 'Content - Apply for Position', '');

INSERT INTO `career_portal_template` VALUES (null, 'CATS 2.0', 'Left', '');
INSERT INTO `career_portal_template` VALUES (null, 'CATS 2.0', 'Footer', '');
INSERT INTO `career_portal_template` VALUES (null, 'CATS 2.0', 'Header', '
\r\n
IMAGE: CATS Applicant Tracking System Careers Page
\r\n
\r\n
Shortcuts:
\r\n IMAGE: Return to Main\r\nIMAGE: RSS Feed\r\n IMAGE: Show All Jobs\r\n
'); INSERT INTO `career_portal_template` VALUES (null, 'CATS 2.0', 'Content - Main', '
\r\n
Available Openings at
\r\n
\r\n


Re: 0.9.1 installation error

Did this error occur in 0.9.1 as well? I believe this was remedied in that version. Otherwise, a quick fix would be to 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;
--

Re: 0.9.1 installation error

...yes the error did occur in 0.9.1. I applied the fix as you suggested and the problem is solved.

Thanks