Search does not work with some phrases when running on PostgreSQL

[gino0631]

When trying to search for something, a page with "Whoops, looks like something went wrong." is displayed.

FreeScout: 1.7.30
Database: PostgreSQL 12.7

Log entry:

SQLSTATE[42803]: Grouping error: 7 ERROR: column "emails.email" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select "customers".*, "emails"."email" from "customers" left...
                              ^ (SQL: select "customers".*, "emails"."email" from "customers" left join "emails" on "customers"."id" = "emails"."customer_id" where ("customers"."first_name" like %der% or "customers"."last_name" like %der% or "customers"."company" like %der% or "customers"."job_title" like %der% or "customers"."phones" like %der% or "customers"."websites" like %der% or "customers"."social_profiles" like %der% or "customers"."address" like %der% or "customers"."city" like %der% or "customers"."state" like %der% or "customers"."zip" like %der% or "customers"."zip" like %der% or "emails"."email" like %der%) group by "customers"."id" limit 50 offset 0)

[freescout-helpdesk]

Duplicates #1664