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

Russ, Good morning and thank you for checking on[…]

Autofill option

let me test on a local install.. works on the prod[…]

Upgrade to PHP 7.3

So.. we're at 7.2 at the moment, there is at least[…]

Security issues

Okay, so this is a wiki entry for restricting file[…]

Hello! Thanks ementalist! This fixed my upgrade […]

Resume scoring

Hi, sorry this isn't available within opencats

Bulk Activity Logging

Hi, this is both easy and hard to do... There'[…]