Hi, I updated to payload 3.77.0 from 3.74.0 and started getting this error:
Error: Failed query: select distinct "users"."id", "users"."created_at", "users"."created_at" from "users" left join "users_roles" on "users"."id" = "users_roles"."parent_id" where ("users_roles"."value" = $1 and "users_roles"."value" ilike $2) order by "users"."created_at" desc limit $3
params: seller,%seller%,10
at async Profiles (src\blocks\Profiles\component.tsx:15:22)
13 | const payload = await getPayload({ config: configPromise })
14 |
15 | const profiles = await payload.find({
| ^
16 | collection: 'users',
17 | depth: 1,
18 | limit: maxProfiles, {
query: 'select distinct "users"."id", "users"."created_at", "users"."created_at" from "users" left join "users_roles" on "users"."id" = "users_roles"."parent_id" where ("users_roles"."value" = $1 and "users_roles"."value" ilike $2) order by "users"."created_at" desc limit $3',
params: [Array],
digest: '30144703',
[cause]: error: operator does not exist: enum_users_roles ~~* unknown
at async Profiles (src\blocks\Profiles\component.tsx:15:22)
13 | const payload = await getPayload({ config: configPromise })
14 |
15 | const profiles = await payload.find({
| ^
16 | collection: 'users',
17 | depth: 1,
18 | limit: maxProfiles, {
length: 214,
severity: 'ERROR',
code: '42883',
detail: undefined,
hint: 'No operator matches the given name and argument types. You might need to add explicit type casts.',
position: '215',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_oper.c',
line: '635',
routine: 'op_error'
}
}
Do anyone knows what could it be?