# |
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 |
# |
Jan 9th 2020, 10:15 |
jotpe |
This one should be used by the framework |
# |
Jan 9th 2020, 10:15 |
jotpe |
Have a look at Cake folder |
# |
Jan 9th 2020, 10:15 |
y.skrzypczyk |
I can't do it ... but I would like |
# |
Jan 9th 2020, 10:14 |
jotpe |
Thought about trashing it and rebuild? ;) |
# |
Jan 9th 2020, 10:13 |
y.skrzypczyk |
Yes I know |
# |
Jan 9th 2020, 10:12 |
y.skrzypczyk |
There are 4 directories : Cake, Cake2.2, Cake2.3, Cake2.7.1 |
# |
Jan 9th 2020, 10:08 |
jotpe |
@y.skrzypczyk This shounds like a Cake2.x App. Have a look at lib/Cake/VERSION.txt to check the version. Then check the corresponding Docs: https://book.cakephp.org/2/en/development/configuration.html#database-configuration |
# |
Jan 9th 2020, 10:01 |
y.skrzypczyk |
In the /app/Config folder I have a database.php file with several configuration variables. How to know which one is used by the plugin? |
# |
Jan 9th 2020, 09:58 |
y.skrzypczyk |
Dans le dossier /app/Config j'ai bien un fichier database.php |
# |
Jan 9th 2020, 09:52 |
neon1024 |
Database credentials are stored in the `/config/app.php` file under the `Datasources` configuration key |
# |
Jan 9th 2020, 09:49 |
slackebot |
connection to the database yet I have the templates. |
# |
Jan 9th 2020, 09:49 |
y.skrzypczyk |
First I just need some advice. To try to summarize the problem. There is a first application made on Symfony to connect with the creation of a JWT cookie. After that we can access this second application on cakephp that retrieves the cookie and checks the JWT. If I understand it developed a plugin on cakephp for the access part to the user database: /app/Plugin/Administration/... but in this plugin I do not find any information of |
# |
Jan 9th 2020, 09:42 |
neon1024 |
@y.skrzypczyk It sounds like you need to hire a Cake developer to help you. Have you thought about asking CakeDC for help? You might be able to hire them to help you |