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 Ilovecats
#2998
Hi

I'm getting the below error in Contacts when trying to filter by Department - Can you help?
(I'm trying to filter a list of contacts by department so i can email them)
  • Query Error -- Report to System Administrator ASAP


    MySQL Query Failed: Unknown column 'company_department.department' in 'where clause'

    SELECT SQL_CALC_FOUND_ROWS
    contact.is_hot AS isHot,
    contact.contact_id AS contactID,
    contact.contact_id AS exportID,
    contact.date_modified AS dateModifiedSort,
    contact.date_created AS dateCreatedSort,
    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(contact.date_modified, '%m-%d-%y') AS dateModified,
    company.name AS name,company.company_id as companyID,
    contact.first_name AS firstName,
    contact.last_name AS lastName,
    company_department.company_department_id AS companyDepartmentID, company_department.name as department,
    contact.title AS title,
    contact.email1 AS email1,
    contact.phone_work AS workPhone,
    contact.phone_cell AS cellPhone,
    contact.state AS state,
    contact.notes AS notes
    FROM
    contact
    LEFT JOIN company
    ON contact.company_id = company.company_id
    LEFT JOIN user AS owner_user
    ON contact.owner = owner_user.user_id
    LEFT JOIN company_department on company_department.company_department_id = contact.company_department_id LEFT JOIN saved_list_entry
    ON saved_list_entry.data_item_type = 300
    AND saved_list_entry.data_item_id = contact.contact_id
    AND saved_list_entry.site_id = 1
    WHERE
    contact.site_id = 1
    AND (company_department.department = 'sas' )

    GROUP BY contact.contact_id

    ORDER BY dateCreatedSort DESC
    LIMIT 0, 100

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