| # |
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']) |
| # |
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. |