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

From where you are trying to looking? You can buy[…]

Email Integration

where I should upload this file :? :? :? :? :?[…]

Email Setting!!!-Solved

OpenCats dev are never been clear in thier answers[…]

Job Order Export

Hi RussH, any chance of getting a reply about thi[…]

Unable to edit Candidates

I have have freshly installed openCATS have set my[…]

How to install OpenCats on hostinger?

I have PHP 5.6 and I uploaded the OpenCats folder […]

how to "delete" a user

Thanks for the reply The thread op asked about de[…]

Yes it is possible. But you have to dug into the s[…]

It need to be exceptionally truthful to export the[…]