| # |
Mar 16th 2018, 05:47 |
 vwpoit |
It combines data from lots of different places and I'm trying to find out if creating a MySQL view directly into my database will help or not. |
| # |
Mar 16th 2018, 05:46 |
vwpoit |
I ask because I keep getting very poor performance on one particular screen on my app. |
| # |
Mar 16th 2018, 05:46 |
vwpoit |
Hello, everyone! I came here because I haven't found solid information on how CakePHP handles MySQL views in terms of performance. Does it cache them like it does with regular MySQL tables? If so, does that mean results are more readily available than traditional CakePHP find methods and/or queries? |
| # |
Mar 16th 2018, 01:53 |
dereuromark |
We should make all magic strings auto-completeable.. |
| # |
Mar 16th 2018, 01:53 |
dereuromark |
I added autocomplete for element() template calls: https://github.com/dereuromark/cakephp-ide-helper/pull/77 Can someone with PHPStorm maybe test and give feedback here? |
| # |
Mar 16th 2018, 00:58 |
bez |
hi! i have a question about CakePHP 3 password hashing with DefaultPasswordHasher: does it uses the Security.salt for something? is it possible to change Security.salt in controller before hashing the password, for say, creating an account for another CakePHP application with a distinct Security.salt? |
| # |
Mar 15th 2018, 22:27 |
obinoob |
It's hard to get some basic help around! I've to drop this... unfortunately php communities are extremely toxic |
| # |
Mar 15th 2018, 22:23 |
obinoob |
ok thanks I've found it $this->paginate = [ 'order' => ['Users.id' => 'desc'] |
| # |
Mar 15th 2018, 22:16 |
obinoob |
is it possible to sort after order? |
| # |
Mar 15th 2018, 22:12 |
obinoob |
I can't sort asc or desc with query such as $this->Table->find()->where([...])->orderAsc(); |
| # |
Mar 15th 2018, 20:39 |
phpnut |
will have it checked out |
| # |
Mar 15th 2018, 20:36 |
lorenzo |
@phpnut ^ |
| # |
Mar 15th 2018, 20:33 |
cookieguru |
I tried several different usernames, including gibberish, and every time I try and sign up at https://my.cakephp.org/join it says `This username is already in use.` |
| # |
Mar 15th 2018, 19:23 |
inoas |
ok |
| # |
Mar 15th 2018, 19:23 |
dereuromark |
because it doesnt need to, the main where() logic happens which is the obvious exception of the current behavior |
| # |
Mar 15th 2018, 19:23 |
inoas |
no test case for false |
| # |
Mar 15th 2018, 19:22 |
inoas |
https://github.com/cakephp/cakephp/pull/11782/files |
| # |
Mar 15th 2018, 19:22 |
inoas |
I do |
| # |
Mar 15th 2018, 19:22 |
dereuromark |
you should look into the core pr |
| # |
Mar 15th 2018, 19:22 |
inoas |
ok |
| # |
Mar 15th 2018, 19:22 |
inoas |
don't have a test suite around, but I tried the SQL and it is invalid |
| # |
Mar 15th 2018, 19:22 |
dereuromark |
you are welcome to see what happens, ionas |
| # |
Mar 15th 2018, 19:22 |
dereuromark |
try it |
| # |
Mar 15th 2018, 19:22 |
conehead |
Still the same :S |
| # |
Mar 15th 2018, 19:21 |
inoas |
latter is invalid syntax... |
| # |
Mar 15th 2018, 19:21 |
inoas |
@dereuromark wouldn't $query->whereInList('id', [], ['allowEmpty' => false]); generate something similar to SELECT * FROM order WHERE id IN (); |
| # |
Mar 15th 2018, 19:09 |
conehead |
I will check. It was all auto generated. So I thought it should work this way. Will add the 's' everywhere |
| # |
Mar 15th 2018, 19:08 |
conehead |
you mean the 's' |
| # |
Mar 15th 2018, 19:07 |
dereuromark |
you dont see my point? |
| # |
Mar 15th 2018, 19:06 |
conehead |
https://pastebin.com/CejCBhLp |
| # |
Mar 15th 2018, 19:05 |
dereuromark |
IngridientsRecipe => IngridientsRecipes ? |
| # |
Mar 15th 2018, 19:03 |
conehead |
Has anything changed with 'through'? I set it up exactly like in the cookbook (https://book.cakephp.org/3.0/en/orm/associations.html#using-the-through-option), but when I try to open the edit page, it says: `Recipes is not associated with IngridientsRecipe` |
| # |
Mar 15th 2018, 18:42 |
birdy247 |
The file does exist, but its sym linked |
| # |
Mar 15th 2018, 18:41 |
birdy247 |
SSLCertificateFile: file '/etc/letsencrypt/live/mysite.xo.uk/cert.pem' does not exist or is empty |
| # |
Mar 15th 2018, 18:41 |
birdy247 |
does this mean restarting apache will also fail? |
| # |
Mar 15th 2018, 18:41 |
birdy247 |
If I do apache2ctl -t and it fails |
| # |
Mar 15th 2018, 18:39 |
admad |
this is how aliasing if done for all classes that support it |
| # |
Mar 15th 2018, 18:37 |
alysson-azevedo |
I see. Thanks |
| # |
Mar 15th 2018, 18:32 |
admad |
`['Clients' => ['className' => 'RxHooks.Sl20Clients']` |
| # |
Mar 15th 2018, 18:04 |
alysson-azevedo |
is it possible to create aliases to shell tasks? i'm trying `public $tasks = ['RxHooks.Sl20Clients' => 'Clients']` but it doesn't work |
| # |
Mar 15th 2018, 17:43 |
devito |
$ bin/cake migrations migrate -c my_custom_connection ``` |