Bug report

Summary

Filter by form name and encrypted forms tabs are empty.

Step to reproduce

Submit a form using FormItSaveForm hook

Observed behavior

When checking the submitted forms in formit CMP the form name filter select box is empty + encrypted forms tab is empty. MODX error log reporting the following SQL error:

core/xpdo/om/xpdoobject.class.php : 240) 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 'modx_event.FormItForm.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)

Expected behavior

Filter by from name and encrypted form tab should be working.

Environment

MODX 2.8.7 + FormIt 4.2.7
PHP 8.2 + MySQL 8