- 26 Oct 2018, 19:14
#3895
Hi, I have about 12000 Candidate records now but I can't load the Candidates Tab. It keeps circling and then it'll either work finally OR most likely the below message error. Can someone point me in the right direction? do i need to upgrade my hosting RAM? or is this a different issue?
Query Error -- Report to System Administrator ASAP
MySQL Query Failed: Lost connection to MySQL server during query
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,
owner_user.first_name AS ownerFirstName,owner_user.last_name AS ownerLastName,CONCAT(owner_user.last_name, owner_user.first_name) AS ownerSort,
DATE_FORMAT(candidate.date_modified, '%m-%d-%y') AS dateModified,
DATE_FORMAT(candidate.date_created, '%m-%d-%y') AS dateCreated,
candidate.state AS state,
candidate.key_skills AS keySkills,
extra_field1.value AS extra_field_value1,
candidate.first_name AS firstName,
candidate.last_name AS lastName,
candidate.email1 AS email1,
candidate.phone_cell AS phoneCell,
candidate.notes AS notes,
extra_field0.value AS extra_field_value0,
extra_field2.value AS extra_field_value2,
candidate.current_employer AS currentEmployer,
candidate.current_pay AS currentPay
FROM
candidate
LEFT JOIN attachment
ON candidate.candidate_id = attachment.data_item_id
AND attachment.data_item_type = 100
LEFT JOIN candidate_joborder AS candidate_joborder_submitted
ON candidate_joborder_submitted.candidate_id = candidate.candidate_id
AND candidate_joborder_submitted.status >= 400
AND candidate_joborder_submitted.site_id = 1
AND candidate_joborder_submitted.status != 650
LEFT JOIN user AS owner_user ON candidate.owner = owner_user.user_id
LEFT JOIN extra_field AS extra_field1 ON candidate.candidate_id = extra_field1.data_item_id AND extra_field1.field_name = 'Department' AND extra_field1.data_item_type = 100
LEFT JOIN extra_field AS extra_field0 ON candidate.candidate_id = extra_field0.data_item_id AND extra_field0.field_name = 'Title' AND extra_field0.data_item_type = 100
LEFT JOIN extra_field AS extra_field2 ON candidate.candidate_id = extra_field2.data_item_id AND extra_field2.field_name = 'Work Auth' AND extra_field2.data_item_type = 100 LEFT JOIN saved_list_entry
ON saved_list_entry.data_item_type = 100
AND saved_list_entry.data_item_id = candidate.candidate_id
AND saved_list_entry.site_id = 1
WHERE
candidate.site_id = 1
AND candidate.is_admin_hidden = 0
GROUP BY candidate.candidate_id
ORDER BY dateModifiedSort DESC
LIMIT 0, 100