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

Good Day, I had created a questionnaire and syste[…]

I assume you're comfortable enough with file explo[…]

Hi Karl, I believe this version is being run i[…]

so - sounds like your installation was compromis[…]

Job Order Export

Hi Mak, please check your apache access.log and […]

Hi Karl, I believe this version is being run in […]

Hi Karl, I believe this version is being run in […]

Hi Karl, I believe this version is being run in […]

Thanks @RussH . Just a bad migration script o[…]

Can someone please help me on this one please,am n[…]

Hi Tony, regarding your email issue - still a prob[…]

Other Hosting Options?

it'll quite happily run in docker?

Make your own logo at 277x52 pixels and saved it a[…]

Make your own logo at 277x52 pixels and saved it a[…]