| # |
Jan 9th 2020, 14:47 |
 ricksaccous |
you gotta bind those params |
| # |
Jan 9th 2020, 14:09 |
ndm |
Well, let's call it "(user) data", given that I don't know where `$id` comes from, but even if it's not user data currently (ie data sent by the user(agent) to your application), you never know when someone might make a change for the source of `$id`, so don't even start with inserting (user) data into queries directly. |
| # |
Jan 9th 2020, 14:06 |
alexdd55976 |
@ndm not sure what you mean with user data? |
| # |
Jan 9th 2020, 14:04 |
ndm |
@alexdd55976 It's still really bad form, never insert user data into queries if you can avoid it, always use bindings when possible, don't let stuff like that slip |
| # |
Jan 9th 2020, 14:03 |
alexdd55976 |
@sdevore thanks :) |
| # |
Jan 9th 2020, 14:02 |
sdevore |
Also https://book.cakephp.org/3/en/orm/query-builder.html#advanced-conditions there is a bit on notIn I have to run a kid to school but will be back in about an hour if you are still stuck ;) But I have faith that in my absence insight will be self discovered ;) |
| # |
Jan 9th 2020, 14:02 |
alexdd55976 |
@dereuromark good point thanks. i will forward him the message.. i am not in the office |
| # |
Jan 9th 2020, 14:01 |
dereuromark |
The $id is better (int) casted, otherwise you might open yourself to sql injections^^ |
| # |
Jan 9th 2020, 14:01 |
sdevore |
check out https://book.cakephp.org/3/en/orm/query-builder.html#subqueries |
| # |
Jan 9th 2020, 14:00 |
alexdd55976 |
the subselect is the big issue |
| # |
Jan 9th 2020, 13:59 |
alexdd55976 |
bu i am sure there is a more cakey way to do that |
| # |
Jan 9th 2020, 13:59 |
ndm |
ouch |
| # |
Jan 9th 2020, 13:59 |
alexdd55976 |
a colleague did that ```$this->Departments->find() ->where([ 'departments.active' => 1, 'departments.id NOT IN (SELECT DISTINCT department_id FROM users_departments where user_id <> ' . $id . ' )', ]);``` |
| # |
Jan 9th 2020, 13:58 |
slackebot |
`Departments__modified` FROM departments Departments WHERE ( departments.active = '1' AND departments.id NOT IN ( SELECT DISTINCT department_id FROM users_departments where user_id <> 1 ) )``` |
| # |
Jan 9th 2020, 13:58 |
alexdd55976 |
can somebody help me bringing the following statement to orm query? ```SELECT Departments.id AS `Departments__id`, Departments.name AS `Departments__name`, Departments.user_id AS `Departments__user_id`, Departments.is_root AS `Departments__is_root`, Departments.parent_id AS `Departments__parent_id`, Departments.active AS `Departments__active`, Departments.created AS `Departments__created`, Departments.modified AS |
| # |
Jan 9th 2020, 13:58 |
ndm |
I heard everybody loves Upwork ;) |
| # |
Jan 9th 2020, 13:49 |
spriz |
Do you guys know anywhere awesome to post a Cake job? :) |
| # |
Jan 9th 2020, 12:03 |
tibor.hajos |
Great, thank you. I'll see how long it takes for me to get stuck :P |
| # |
Jan 9th 2020, 12:01 |
dereuromark |
Jep, and you can use cake4 branch of sandbox to real life test it. Helped me a lot. |
| # |
Jan 9th 2020, 12:00 |
tibor.hajos |
Cool, I made a note of it. I'll probably need some help in figuring out how to upgrade everything, as Cake is still new for me. Is it best to just pull everything, see what's broken and fix it? |
| # |
Jan 9th 2020, 11:56 |
dereuromark |
Tools, Setup, Tags, Ratings, Geo probably, in that order. rest doesnt seem to be needed for a while^^ |
| # |
Jan 9th 2020, 11:53 |
tibor.hajos |
Sure, I can get some hours in this weekend. Which issue has the best necessity/difficulty ratio? |
| # |
Jan 9th 2020, 11:39 |
dereuromark |
Anyone interested in helping to get the plugins Cache, Tags, Ratings, Geo, Translate, Captcha, Tools, Setup etc ready for Cake4? A little help is needed, I did already most of the hard part here :) Having already upgraded 10+ others, I appreciate the assistance. |
| # |
Jan 9th 2020, 10:33 |
jotpe |
Handle doesn't get passed to the Paginator and the route is obviously not found. |
| # |
Jan 9th 2020, 10:31 |
slackebot |
<jotpe> |
| # |
Jan 9th 2020, 10:31 |
jotpe |
I use BootstrapUI and have a route with 2 variables, but one doesn't get passed: |
| # |
Jan 9th 2020, 10:30 |
jotpe |
Anyone knows how to pass a variable to a the PaginatorHelper? |
| # |
Jan 9th 2020, 10:30 |
jotpe |
THis defines that the `AdministrationUser` Model uses the table `users.` In your db should be a table users then. |
| # |
Jan 9th 2020, 10:28 |
y.skrzypczyk |
There is a databases so no ? |
| # |
Jan 9th 2020, 10:27 |
y.skrzypczyk |
In the plugin I have : <?php /** * UserAdmin Model * * @property Group $Group */ App::uses('AdministrationAppModel', 'Administration.Model'); class AdministrationUser extends AdministrationAppModel { public $useTable = 'users'; /// Utilise la table users |
| # |
Jan 9th 2020, 10:27 |
jotpe |
Well I guess you have to dig a bit then. Maybe the app doesn't even has db access?! Have a look at the links above and figure out how this app works. |
| # |
Jan 9th 2020, 10:22 |
y.skrzypczyk |
I was told that the software worked before ... there are no defaults but there are some other variable |
| # |
Jan 9th 2020, 10:21 |
jotpe |
No credentials, no db access :man-shrugging: |
| # |
Jan 9th 2020, 10:21 |
jotpe |
So then your db access is not configured :) |
| # |
Jan 9th 2020, 10:21 |
y.skrzypczyk |
There is no default |
| # |
Jan 9th 2020, 10:21 |
jotpe |
Also have a look in app/Config/routes.php to see if there're custom routes, otherwise the routing is as follows: https://book.cakephp.org/2/en/development/routing.html#default-routing |
| # |
Jan 9th 2020, 10:20 |
y.skrzypczyk |
Error: The datasource configuration default was not found in database.php. |
| # |
Jan 9th 2020, 10:20 |
y.skrzypczyk |
This is one of the multiples problems : |
| # |
Jan 9th 2020, 10:19 |
jotpe |
So then have a look at app/Config/database.php and search for ```public $default = array(``` there you'll find the db configuration like described here: https://book.cakephp.org/2/en/development/configuration.html#database-configuration |
| # |
Jan 9th 2020, 10:15 |
y.skrzypczyk |
2.4.0 |
| # |
Jan 9th 2020, 10:15 |
y.skrzypczyk |
Yes I think so |