| # |
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']) |
| # |
Apr 23rd 2017, 21:38 |
iqu |
$query = $this->Articles->find('distance', $options) |
| # |
Apr 23rd 2017, 21:38 |
iqu |
$options = ['lat' => $lat, 'lng' => $lng, 'distance' => $distance]; |
| # |
Apr 23rd 2017, 21:36 |
iqu |
dereuromark: question over your fantastic geo plugin |
| # |
Apr 23rd 2017, 16:27 |
crazycoder |
i have checked the permissions and i see no problem |
| # |
Apr 23rd 2017, 16:26 |
crazycoder |
is this normal? Notice (8): session_start(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) |
| # |
Apr 23rd 2017, 15:43 |
dereuromark |
ah thats the catch |
| # |
Apr 23rd 2017, 15:40 |
marass |
but not everyone want to pay for it :) |
| # |
Apr 23rd 2017, 15:40 |
dereuromark |
A few basics: take a look at the core tickets if you like to help out, check out https://github.com/FriendsOfCake/awesome-cakephp if you find any plugins that you find useful and want to contribute. |
| # |
Apr 23rd 2017, 15:39 |
dereuromark |
marass: everyone does :slightly_smiling_face: |
| # |
Apr 23rd 2017, 15:39 |
marass |
maybe someone need some help with cake project? |
| # |
Apr 23rd 2017, 12:44 |
dereuromark |
plugin |
| # |
Apr 23rd 2017, 12:44 |
dereuromark |
checkout the twitter api |
| # |
Apr 23rd 2017, 11:58 |
iqu |
basically something that does all this: https://adamboother.com/blog/automatically-posting-to-a-facebook-page-using-the-facebook-sdk-v5-for-php-facebook-api/ |
| # |
Apr 23rd 2017, 11:55 |
iqu |
but to post to account |
| # |
Apr 23rd 2017, 11:55 |
iqu |
not share |