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
#961
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

SELECT SQL_CALC_FOUND_ROWS
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,
candidate.city AS city,
candidate.state AS state,
candidate.zip AS zip,
candidate.notes AS notes,
candidate.web_site AS webSite,
candidate.key_skills AS keySkills,
By alaoa
#968
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
#969
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

/cats/lib/DataGrid.php

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);
            }
            $i++;
        }
Just in case anyone else runs into this problem
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[…]

Email Integration

Hey CFM, all, this is the code I had created to […]

Job Order Export

Hi Russ, I have OpenCATS setup on shared hosting,[…]

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

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

hey plz reply fast

Hi All, would like to ask the following: We have[…]