Log message #4155099

# At Username Text
# Jul 2nd 2018, 15:08 rudy1976s we are detecting a lot of strange queries created by sqlserver when working on it
# Jul 2nd 2018, 15:07 lorenzo @rudy1976s what do you need to change?
# Jul 2nd 2018, 15:07 lorenzo @afdm74 I recommend this plugin that will help you do that https://github.com/FriendsOfCake/search
# Jul 2nd 2018, 15:06 rudy1976s I need to tweak it because we are facing performance problem using cake on sqlserver
# Jul 2nd 2018, 15:06 rudy1976s @lorenzo thank you
# Jul 2nd 2018, 15:06 lorenzo you need to make the post arguments into get arguments
# Jul 2nd 2018, 15:03 afdm74 Hi guys, Having trouble using pagination and custom queries. When clicking in next page it loses all filter information and display a Not Found page. I debugged it and the reason is because the Paginator uses Get requests. The paginator is not geeting or keeping the filters and resetting when clicked on the next page. What am I doing wrong?
# Jul 2nd 2018, 15:03 lorenzo it shuld be `[PDO::CONSTANT_THING => $value]`
# Jul 2nd 2018, 15:00 rudy1976s @lorenzo, so the array should only contain PDO constants or should I need to add as [‘pdo_name’ => ‘pdo_constant’]
# Jul 2nd 2018, 14:52 lorenzo you need to use the constants
# Jul 2nd 2018, 14:52 lorenzo yeah, it can be any PDO flag
# Jul 2nd 2018, 14:47 rudy1976s I need to add some PDO flag to the sql server datasources: I know from docs this is supported, but the associative array could contain all PDO supported flag ? and what is the correct names to build associative array ? on pdo docs I was only able to find the constants
# Jul 2nd 2018, 14:45 itmpls good morning
# Jul 2nd 2018, 14:45 rudy1976s good afternoon
# Jul 2nd 2018, 14:10 dereuromark PRs
# Jul 2nd 2018, 14:10 qq @dereuromark how to improve the cakephp documents in Chinese? the Chinese(zh) document has not been updated for ages.
# Jul 2nd 2018, 14:06 itmpls it happens to all of us :slightly_smiling_face: np
# Jul 2nd 2018, 14:06 rrd564 :slightly_smiling_face:
# Jul 2nd 2018, 14:06 rrd564 eh what a silly mistake
# Jul 2nd 2018, 14:05 rrd564 @itmpls thanks, that was it!
# Jul 2nd 2018, 14:04 itmpls try ^
# Jul 2nd 2018, 14:04 rrd564 I used Datalist.php
# Jul 2nd 2018, 14:04 itmpls does it need to be DatalistWidget.php ?
# Jul 2nd 2018, 14:04 itmpls filename?
# Jul 2nd 2018, 14:04 rrd564 and the first parameter of format
# Jul 2nd 2018, 14:03 rrd564 Except the classname
# Jul 2nd 2018, 14:03 rrd564 https://book.cakephp.org/3.0/en/views/helpers/form.html#building-a-widget-class
# Jul 2nd 2018, 14:03 rrd564 So now it is exactly the same what we have in the cookbook
# Jul 2nd 2018, 14:03 itmpls oh ok
# Jul 2nd 2018, 14:03 rrd564 I just started to rorking on ti
# Jul 2nd 2018, 14:03 itmpls pastebin*
# Jul 2nd 2018, 14:02 itmpls can you paste the class definition?
# Jul 2nd 2018, 14:02 rrd564 in Datalist.php `namespace App\View\Widget;`
# Jul 2nd 2018, 14:02 itmpls does it have the right namespace?
# Jul 2nd 2018, 14:01 rrd564 In my `AppView.php` file I have this: `$this->loadHelper('Form', [ 'templates' => 'form-templates', 'widgets' => [ 'datalist' => ['Datalist'] ] ]);`
# Jul 2nd 2018, 14:01 itmpls how are you loading it?
# Jul 2nd 2018, 14:00 rrd564 Hi, I am building a custom widget fot html datalist input, but I am missing something as I get `"Unable to locate widget class"` Any guess why? I have created my class at `/src/View/Widget/Datalist.php file`
# Jul 2nd 2018, 13:58 itmpls brazil v mexico soon, who does everyone have!?!?
# Jul 2nd 2018, 13:58 itmpls yup sorry i'm useless :S
# Jul 2nd 2018, 13:54 joshualuckers will try to do so later, thanks for now! :)
# Jul 2nd 2018, 13:53 itmpls i would guess its new Collection($diff) or the map