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 sabermudez
#4823
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
User avatar
By RussH
#4831
MySQL defaults changed in MySQL 5.7 to enable only_full_group_by

If this is an existing installation, you must have upgraded MySQL. You will have to disable it. Disabling full_group_by will vary depending on what version of MySQL / MariaDB you're running.

Once you find your version, just google for how to disable only_full_group_mode on MySQL yourversion

A good explanation here: https://gabi.dev/2016/03/03/group-by-ar ... u-know-it/

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me