Log message #4019592

# At Username Text
# Apr 24th 2017, 06:09 zbouby do some is able to browse www.lafeeriedebebe.com with an iphone ?
# Apr 24th 2017, 06:09 zbouby i m facing an issue
# Apr 24th 2017, 06:09 zbouby hello all
# Apr 24th 2017, 03:44 angelxmoreno yeoman it is for now then
# Apr 24th 2017, 03:44 angelxmoreno well..that was not the droid i was looking for
# Apr 24th 2017, 03:38 angelxmoreno oohh, i found `https://github.com/cakephp/bake`
# Apr 24th 2017, 03:37 angelxmoreno did we ever port cakephp cli goodies like we did orm, cache and utility ?
# Apr 23rd 2017, 22:37 yomexzo but with what we have right now, it’s impossible.
# Apr 23rd 2017, 22:36 yomexzo i need to alias a Table with a name that has been used in another table… I want `$this->Orders->Transactions` and `$this->Store->Transactions` to refer to different tables
# Apr 23rd 2017, 22:35 yomexzo > * *Note* If your `$alias` uses plugin syntax only the name part will be used as * key in the registry. This means that if two plugins, or a plugin and app provide * the same alias, the registry will only store the first instance.
# Apr 23rd 2017, 22:35 yomexzo it is causing me a pain
# Apr 23rd 2017, 22:35 yomexzo is there any way around it?
# Apr 23rd 2017, 22:35 yomexzo i just found this => https://github.com/cakephp/cakephp/blob/master/src/ORM/Locator/TableLocator.php#L158
# Apr 23rd 2017, 22:25 keremcankaya Ah actually i found Installer.php postInstall callback, i guess i can change from there
# Apr 23rd 2017, 22:22 keremcankaya Hey there guys im deploying a cake 3 app to azure web app with composer extension, is there way to bypass composer set file permissions question? Cause it’s failing auto deployment
# Apr 23rd 2017, 22:03 dereuromark jep
# Apr 23rd 2017, 22:00 iqu dereuromark: easiest solution for now: set config: 'init' => ["SET sql_mode = ''"],
# Apr 23rd 2017, 21:48 dereuromark I wonder what the PostGres SQL query looks like on that one. And if the ORM works here. Because then this could be somthing the ORM should be able to resolve internally.
# Apr 23rd 2017, 21:48 iqu if i could just set that on the fly
# Apr 23rd 2017, 21:48 iqu ],
# Apr 23rd 2017, 21:48 iqu 'init' => ["SET sql_mode = ''"],
# Apr 23rd 2017, 21:48 iqu ...
# Apr 23rd 2017, 21:48 iqu 'host' => 'localhost',
# Apr 23rd 2017, 21:48 iqu 'persistent' => false,
# Apr 23rd 2017, 21:48 iqu 'driver' => 'Cake\Database\Driver\Mysql',
# Apr 23rd 2017, 21:48 iqu 'className' => 'Cake\Database\Connection',
# Apr 23rd 2017, 21:48 iqu 'default' => [
# Apr 23rd 2017, 21:48 iqu 'Datasources' => [
# Apr 23rd 2017, 21:48 iqu found something like:
# Apr 23rd 2017, 21:47 dereuromark try sth like `mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));`
# Apr 23rd 2017, 21:45 dereuromark You can set a flag here to keep the old sql mode, thats the easiest way for now. If someone can make a PR to include the group into the select this will also be fixed I think.
# Apr 23rd 2017, 21:45 iqu yep. yes. this is mysql problem
# Apr 23rd 2017, 21:44 dereuromark yeah this is sth that bugs me a lot lately :slightly_smiling_face: A new setting of trying to make mysql more standard
# Apr 23rd 2017, 21:44 iqu ok. This must be something with mysql 5.7 -> http://stackoverflow.com/questions/36228836/syntax-error-or-access-violation-1055-expression-8-of-select-list-is-not-in-gr
# Apr 23rd 2017, 21:40 iqu Error: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '247news.Articles.lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
# Apr 23rd 2017, 21:40 iqu gives funny warning which i dont fully understand
# Apr 23rd 2017, 21:38 iqu grouping does not work
# Apr 23rd 2017, 21:38 iqu ->limit(5);
# Apr 23rd 2017, 21:38 iqu ->group(['formatted_address'])
# Apr 23rd 2017, 21:38 iqu ->order(['id' => 'desc'])
# Apr 23rd 2017, 21:38 iqu ->select(['formatted_address'])