Formit Expression #1 of SELECT list is not in GROUP BY

Support
1

After upgrade to 3.2.3 I’m getting the following error when submitting a formit form…

[2026-07-22 18:00:22] (ERROR @ /app/data/public/core/vendor/xpdo/xpdo/src/xPDO/Om/xPDOObject.php : 227) Error 42000 executing statement: 
Array
(
    [0] => 42000
    [1] => 1055
    [2] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '###############.FormItForm.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)

Formit 5.2.4
PHP 8.3
Apache/2.4.58 (Ubuntu)

2

This is unlikely to have any relation to 3.2.3 specifically, rather it’s just a strict mysql mode issue in FormIt.

Looks like this has been reported to the FormIt repository before:

FormItSaveForm ERROR: Filter by form name and encrypted forms component causing SQL error · Issue #293 · Sterc/FormIt · GitHub

3

Thanks Mark - I’ve trawled through just about everything. It was working last week but not today

4

Removing recaptcha V2 and switching to V3 seems to have solved this