OpenCATS 0.9.4-3

Free, Open-Source Applicant Tracking System including job-board. Entirely customisable!

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 alaoa
What i export from a list I get the following error:

MySQL Query Failed: Too many tables; MySQL can only use 61 tables in a join

candidate.candidate_id AS candidateID,
candidate.candidate_id AS exportID,
candidate.is_hot AS isHot,
candidate.date_modified AS dateModifiedSort,
candidate.date_created AS dateCreatedSort,
IF(candidate_joborder_submitted.candidate_joborder_id, 1, 0) AS submitted,
IF(attachment_id, 1, 0) AS attachmentPresent,
candidate.first_name AS firstName,
candidate.last_name AS lastName,
candidate.email1 AS email1,
candidate.email2 AS email2,
candidate.phone_home AS phoneHome,
candidate.phone_cell AS phoneCell,
candidate.phone_work AS phoneWork,
candidate.address AS address, AS city,
candidate.state AS state, AS zip,
candidate.notes AS notes,
candidate.web_site AS webSite,
candidate.key_skills AS keySkills,
By alaoa
I didn't want to post the whole error. I think it has to do with the many extra fields that we added. Is there a way to limit the amount of columns it tries to pull. Please point me in the right direction. I'm willing to donate!!!
By alaoa
Well I guess no one monitors this board. It's sad really because this software is pretty good. I ended up finding the problem. In


in the function drawCSV() I had to force it to only select the first 6o columns
Code: Select all
$i = 0;
        foreach ($this->_classColumns as $index => $data)
            if($i < 60){
        		$exportableColumns[] = array('name' => $index, 'data' => $data);
Just in case anyone else runs into this problem

Is there a way to add a "Custom Field" t[…]

Unable to add attachment in OpenCATS User Login

Hi Team, Our OpenCATS Create Candidate Attachment […]

I've now implemented an iCal feed for the calendar[…]

Get your hands on the best solo microwave oven, be[…]

Hi, this is an activity update against a candida[…]

Hosting / Development

Yws. I am intrested. Because I want o change my we[…]

Clearly, this could just as easily be used to gen[…]

Security issues

it's dependant on me getting my lazy/busy arse int[…]