| # |
Apr 23rd 2021, 08:37 |
 paolo.bragagni |
:( |
| # |
Apr 23rd 2021, 08:37 |
paolo.bragagni |
I've change to this ```$middlewareQueue->add(new AuthorizationMiddleware($this, [ 'requireAuthorizationCheck' => false ]));``` and now search is working, but I dont know what does it means |
| # |
Apr 23rd 2021, 07:57 |
v.plancher |
@ndm What do you mean by "using custom aliases"? Do you refer to setting manually a `->join()` (instead of `leftJoinWith`)? |
| # |
Apr 23rd 2021, 06:36 |
paolo.bragagni |
when I filter I get 'The request to `/articles` did not apply any authorization checks.' |
| # |
Apr 23rd 2021, 06:35 |
paolo.bragagni |
hi all. some problems with search plugin (FoC) |
| # |
Apr 23rd 2021, 06:07 |
k4t |
Hi guys, my customer has own portel under its domain: example.com and I created for him another portal in CakePHP which will be stored on my company servers. Now customer wants to have my portal under his domain under following url: example.com/my-portal - is it possible? Normally I would expect separate domain or subdomain from the customer for my portal. |
| # |
Apr 23rd 2021, 05:49 |
admad |
@greg138 just curious why you had to rename `groups`, the reserved word is `group`. |
| # |
Apr 23rd 2021, 04:31 |
greg138 |
There's a bunch of new keywords added in v8. Just had to rename my "groups" table (for role-based access) because of this. |
| # |
Apr 23rd 2021, 04:31 |
greg138 |
My understanding is that the performance penalty is in the Cake side, and adds maybe a ms or something per query. If you have hundreds of queries, that can add up to a sizable penalty. If you have one very long-running query, it's an insignificant drop in the bucket. And I think (but have never needed it...) that there's a way to enable it just for a particular query and disable again afterwards? |
| # |
Apr 22nd 2021, 21:45 |
richard |
words to avoid when naming db columns |
| # |
Apr 22nd 2021, 21:45 |
richard |
@umer936 if you want to stop using quoteidentifiers one day: https://dev.mysql.com/doc/refman/5.7/en/keywords.html |
| # |
Apr 22nd 2021, 21:04 |
umer936 |
Oof. Makes sense though... This query in general is pretty rough ... It takes like 2min :P |
| # |
Apr 22nd 2021, 20:52 |
greg138 |
Beware that quoteIdentifiers does come with a performance penalty. :( |
| # |
Apr 22nd 2021, 19:40 |
umer936 |
Thanks y'all! |
| # |
Apr 22nd 2021, 19:40 |
umer936 |
quoteIdentifiers have fixed the issue :) |
| # |
Apr 22nd 2021, 19:35 |
kevin.pfeifer |
i just checked it with cake4 and there it doesn’t have that weird behaviour |
| # |
Apr 22nd 2021, 19:35 |
umer936 |
I think the quoteIdentifiers is what I needed! |
| # |
Apr 22nd 2021, 19:34 |
admad |
Pretty sure the error msg is whatever pdoerror provides. |
| # |
Apr 22nd 2021, 19:33 |
kevin.pfeifer |
the error message here is a bit missleading. The first line has the lowercased column name but the 2nd Line has the actual SQL which is being used |
| # |
Apr 22nd 2021, 19:32 |
umer936 |
Yup just found it |
| # |
Apr 22nd 2021, 19:32 |
ndm |
It's the `quoteIdentifiers` option. |
| # |
Apr 22nd 2021, 19:31 |
ndm |
@umer936 Ohhh, OK. I thought your actual SQL would change, but it's just in the error message? If so, try enabling auto-quoting in your driver config. |
| # |
Apr 22nd 2021, 19:28 |
umer936 |
https://i.imgur.com/jZ3OQyO.png |
| # |
Apr 22nd 2021, 19:27 |
admad |
https://getcomposer.org/doc/05-repositories.md#loading-a-package-from-a-vcs-repository "url" can be a local file system path |
| # |
Apr 22nd 2021, 19:27 |
umer936 |
Let me get a screenshot one sec |
| # |
Apr 22nd 2021, 19:26 |
kevin.pfeifer |
mhmm ok |
| # |
Apr 22nd 2021, 19:26 |
umer936 |
No it didn't change anything here |
| # |
Apr 22nd 2021, 19:26 |
kevin.pfeifer |
in tools |
| # |
Apr 22nd 2021, 19:26 |
kevin.pfeifer |
i know there are behaviours which do many things |
| # |
Apr 22nd 2021, 19:25 |
umer936 |
:+1:trying that now |
| # |
Apr 22nd 2021, 19:24 |
kevin.pfeifer |
i would try to not load that and check the sql again |
| # |
Apr 22nd 2021, 19:24 |
admad |
@mehov Seems like you made it standalone prematurely :). Anyway, the easiest way is just symlink it into an app's plugin folder. Another option is composer allows adding a local directory as a repo source, so use that feature to load it thorough app's composer.json. |
| # |
Apr 22nd 2021, 19:24 |
kevin.pfeifer |
could there be something the tools plugin does? |
| # |
Apr 22nd 2021, 19:22 |
mehov |
To be clear: I'm not asking for full guidance, but just a general idea |
| # |
Apr 22nd 2021, 19:22 |
ndm |
@umer936 That's pretty wild, I have to admit I'm kinda lost, internally `$query->sql()` is that would get sent to the DB, and what DebugKit receivees. If you recreate the same query using `$table->getConnection()->newQuery()->...`, do you get the same case chaning behavior. |
| # |
Apr 22nd 2021, 19:22 |
umer936 |
Don't think so. DebugKit, TinyAuth, Tools, and Migrations |
| # |
Apr 22nd 2021, 19:21 |
kevin.pfeifer |
could it be that you have some sort of plugin active that does the lowercase conversion? |
| # |
Apr 22nd 2021, 19:20 |
mehov |
@admad ok thank you, one more question please, can I somehow connect this standalone plugin to an actual app sitting in a different folder on the same server? I want to work on the plugin and see the changes right away, without committing and pushing them to the git server, and then downloading to the app via composer just to confirm it works |
| # |
Apr 22nd 2021, 19:19 |
umer936 |
Not easily |
| # |
Apr 22nd 2021, 19:18 |
kevin.pfeifer |
do you have xdebug available and/or a local setup where you can step through the code? |
| # |
Apr 22nd 2021, 19:17 |
admad |
@mehov bake in app and move, or finish your baking before making it standalone |
