The farm_group_members_query() function, which was added as part of the recent Group asset type (#2915217: Group asset type with membership tracking), is incompatible with PostgreSQL.

It adds a query expression that uses two functions unavailable in PostgreSQL: SUBSTRING_INDEX() and GROUP_CONCAT().

Currently this function is not used anywhere in farmOS - but it is used in the Grazing module (https://github.com/mstenta/farm_grazing).

Comments

m.stenta created an issue. See original summary.

m.stenta’s picture

m.stenta
he/him
Primary language English
CreditAttribution: m.stenta commented
Status: Active » Closed (won't fix)

Closing this as "won't fix".

There are a few small bugs like this with PostgreSQL in farmOS 1.x that we most likely won't fix.

We've focused our attention on making PostgreSQL the default recommended database for farmOS 2.x. This is no longer an issue in farmOS 2.x.