| # |
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 |
| # |
Apr 23rd 2017, 11:55 |
iqu |
any suggestions: a good social media plugin that is able to post facebook, twitter, googleplus, linkedin... |
| # |
Apr 23rd 2017, 10:55 |
dereuromark |
ra7bi: why not? |
| # |
Apr 23rd 2017, 10:55 |
dereuromark |
cakephp534: re-format it afterwards after math operations again. formatting != internal calc handling |