Query Error
Posted: 18 Aug 2020, 23:11
Hi all!
I receive this message when i try to enter ACTIVITIES, JOB ORDERS, CANDIDATES or COMPANIERS
I don´t know what to do!
Query Error -- Report to System Administrator ASAP
MySQL Query Failed: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sv000066_opencats.attachment.attachment_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT SQL_CALC_FOUND_ROWS
joborder.joborder_id AS jobOrderID,
joborder.joborder_id AS exportID,
joborder.date_modified AS dateModifiedSort,
joborder.date_created AS dateCreatedSort,
joborder.is_hot AS isHot,
IF(attachment_id, 1, 0) AS attachmentPresent,
joborder.title AS title,
company.name AS companyName,
company.company_id AS companyID,
joborder.type AS type,
joborder.status AS status,
DATE_FORMAT(joborder.date_created, '%d-%m-%y') AS dateCreated,
DATEDIFF(NOW(), joborder.date_created) AS daysOld,
(
SELECT
COUNT(*)
FROM
candidate_joborder_status_history
WHERE
joborder_id = joborder.joborder_id
AND
status_to = 400
AND
site_id = 1
) AS submitted,
(
SELECT
COUNT(*)
FROM
candidate_joborder
WHERE
joborder_id = joborder.joborder_id
AND
site_id = 1
) AS pipeline,
recruiter_user.first_name AS recruiterFirstName,recruiter_user.last_name AS recruiterLastName,CONCAT(recruiter_user.last_name, recruiter_user.first_name) AS recruiterSort,
owner_user.first_name AS ownerFirstName,owner_user.last_name AS ownerLastName,CONCAT(owner_user.last_name, owner_user.first_name) AS ownerSort
FROM
joborder
LEFT JOIN company
ON joborder.company_id = company.company_id
LEFT JOIN contact
ON joborder.contact_id = contact.contact_id
LEFT JOIN attachment
ON joborder.joborder_id = attachment.data_item_id
AND attachment.data_item_type = 400
LEFT JOIN user AS recruiter_user ON joborder.recruiter = recruiter_user.user_id
LEFT JOIN user AS owner_user ON joborder.owner = owner_user.user_id LEFT JOIN saved_list_entry
ON saved_list_entry.data_item_type = 400
AND saved_list_entry.data_item_id = joborder.joborder_id
AND saved_list_entry.site_id = 1
WHERE
joborder.site_id = 1
AND (joborder.status = 'Active' OR joborder.status = 'OnHold' OR joborder.status = 'Full' )
GROUP BY joborder.joborder_id
ORDER BY dateCreatedSort DESC
LIMIT 0, 50
I receive this message when i try to enter ACTIVITIES, JOB ORDERS, CANDIDATES or COMPANIERS
I don´t know what to do!
Query Error -- Report to System Administrator ASAP
MySQL Query Failed: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sv000066_opencats.attachment.attachment_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT SQL_CALC_FOUND_ROWS
joborder.joborder_id AS jobOrderID,
joborder.joborder_id AS exportID,
joborder.date_modified AS dateModifiedSort,
joborder.date_created AS dateCreatedSort,
joborder.is_hot AS isHot,
IF(attachment_id, 1, 0) AS attachmentPresent,
joborder.title AS title,
company.name AS companyName,
company.company_id AS companyID,
joborder.type AS type,
joborder.status AS status,
DATE_FORMAT(joborder.date_created, '%d-%m-%y') AS dateCreated,
DATEDIFF(NOW(), joborder.date_created) AS daysOld,
(
SELECT
COUNT(*)
FROM
candidate_joborder_status_history
WHERE
joborder_id = joborder.joborder_id
AND
status_to = 400
AND
site_id = 1
) AS submitted,
(
SELECT
COUNT(*)
FROM
candidate_joborder
WHERE
joborder_id = joborder.joborder_id
AND
site_id = 1
) AS pipeline,
recruiter_user.first_name AS recruiterFirstName,recruiter_user.last_name AS recruiterLastName,CONCAT(recruiter_user.last_name, recruiter_user.first_name) AS recruiterSort,
owner_user.first_name AS ownerFirstName,owner_user.last_name AS ownerLastName,CONCAT(owner_user.last_name, owner_user.first_name) AS ownerSort
FROM
joborder
LEFT JOIN company
ON joborder.company_id = company.company_id
LEFT JOIN contact
ON joborder.contact_id = contact.contact_id
LEFT JOIN attachment
ON joborder.joborder_id = attachment.data_item_id
AND attachment.data_item_type = 400
LEFT JOIN user AS recruiter_user ON joborder.recruiter = recruiter_user.user_id
LEFT JOIN user AS owner_user ON joborder.owner = owner_user.user_id LEFT JOIN saved_list_entry
ON saved_list_entry.data_item_type = 400
AND saved_list_entry.data_item_id = joborder.joborder_id
AND saved_list_entry.site_id = 1
WHERE
joborder.site_id = 1
AND (joborder.status = 'Active' OR joborder.status = 'OnHold' OR joborder.status = 'Full' )
GROUP BY joborder.joborder_id
ORDER BY dateCreatedSort DESC
LIMIT 0, 50