Grouping broken in version 2.5, had to rollback upgrade


#1

Grouping used to work in previous versions, but it’s broken in version 2.5. Managed to reproduce this on a clean Bitnami image by creating a simple table “test” in MySQL with two columns: id and test_name.

When trying to get records, grouped by test_name using this:
https://<host_name>/api/v2/mysql/_table/test?fields=test_name&group=test_name
I now get this result:

{
  "error": {
    "code": 500,
    "context": null,
    "message": "Failed to retrieve records from 'test'.\nstrpos() expects parameter 1 to be string, array given",
    "trace": [
      "0 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-database/src/Resources/BaseDbTableResource.php(460): DreamFactory\\Core\\SqlDb\\Resources\\Table->retrieveRecordsByFilter('test', NULL, Array, Array)",

The problem appears whenever I add the “group” parameter.


#2

Having the same issue. My local version works fine but the new docker image I installed on digital ocean kept giving the error message. It is also version 2.5


#3

Hotfix dreamfactory/df-sqldb 0.8.2.

composer update dreamfactory/df-sqldb


#4

Thanks, that fixed it.