/admin/changes: ErrorException: SQLSTATE[42000]: Syntax error or access violation: 1055 about decoy HOT 10 CLOSED

@noxify Yeah, works for me, thanks for looking into it.

The issue is that only postgres doesn't use CONCAT

from decoy.

What database and version are you using?

from decoy.

mysql 5.7

from decoy.

From https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

The ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES modes were added in MySQL 5.7.5.

We're running 5.6 here, which is why we haven't encountered this.

I added a commit to master, can you see if dev-master fixes it for you?

from decoy.

Yea, that solved it. Thanks :)

from decoy.

The same problem occurs with postgres (9.6.10) :)

from decoy.

@noxify Did the master branch fix? We're gonna tag a new release soon

from decoy.

@weotch i used the "composer require ..." from the docs - I will change it and test it again.

Thanks for the hint :)

from decoy.

@weotch - tested it with postgres and mysql5.6, but with both databases I got the following error:

Method Bkwld\Decoy\Fields\Listing::__toString() must not throw an exception, caught ErrorException: SQLSTATE[42000]: Syntax error or access violation: 1055 'decoy.admins.id' isn't in GROUP BY (SQL: select admins.id, CONCAT(first_name, " ", last_name) name from `changes` inner join `admins` on `admins`.`id` = `admin_id` group by `admin_id`) (View: /Applications/MAMP/htdocs/decoy/vendor/bkwld/decoy/views/shared/list/_full_header.haml)

• OSX
• MAMP with PHP7.1
• mysql 5.6
• postgres 9.6.10

composer.json:

"require": {
        "php": ">=5.6.4",
        "bkwld/decoy": "dev-master",
        "laravel/framework": "5.4.*", //5.4.19
        "laravel/tinker": "~1.0"
    },

from decoy.

I changed the getAdmins() method to the following:

    public static function getAdmins()
    {
        return Admin::all(['id', 'email'])->pluck('email', 'id');
    }

and everything works fine :)

If i'm not wrong, the getAdmins() will be used to show the values for the search dropdown.
Does it not make sense to show all admins without the limitation?

from decoy.