Comments (10)
@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.
Related Issues (20)
- Changing date format throughout Decoy HOT 2
- Support Laravel 5.6 HOT 4
- Decoy Admin area not showing properly HOT 1
- Enabling Roles causes error exception HOT 6
- Call to undefined method Illuminate\Events\Dispatcher::fire() HOT 1
- Increment visual version numbers in sidebar with recently releases
- Vertical align the table actions
- Translations for fields
- Elements key is not declared in elements.yaml HOT 1
- Add CSV export support
- Searching for date and changing search field duplicates the date
- Don't write changes when admin remember_token changes HOT 1
- Upload svg in image field, "width cannot be null" HOT 2
- Changing element field type after it has been saved to DB
- Admin login not working on fresh install HOT 2
- wysiwyg editor trying to customise HOT 3
- Can't set Decoy locale() HOT 1
- Cannot Install decoy to fresh Laravel HOT 3
- Images + Files WYSIWYG editor HOT 1
- Do you need Filipino Translation for BKWLD?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from decoy.