Log message #4267872

# At Username Text
# Jul 18th 2021, 20:47 kevin.pfeifer no problem, just type it in and someone will help you :)
# Jul 18th 2021, 20:32 kevin.pfeifer :thinking_face: then you should regenerate the model cache i guess ```bin/cake cache clear_all```
# Jul 18th 2021, 20:26 kevin.pfeifer well you should get used to it ;)
# Jul 18th 2021, 20:26 kevin.pfeifer `chmod +w -R /var/www/clients/client2/web2/web/tmp/`
# Jul 18th 2021, 20:25 kevin.pfeifer well you tmp directory doesn't seem to be writeable
# Jul 18th 2021, 20:13 kevin.pfeifer to test it you can just add `$this->Authorization->skipAuthorization();` at the start of the function you want to test
# Jul 18th 2021, 20:04 kevin.pfeifer leave everything else just like https://github.com/cakephp/app/blob/master/config/routes.php#L58 so basically you only have `$builder->fallbacks();` in there
# Jul 18th 2021, 20:04 slackebot2 function```
# Jul 18th 2021, 20:04 kevin.pfeifer remove/comment out both ```$builder->connect('/', ['controller' => 'Pages', 'action' => 'display', 'home']); $builder->connect('/pages/*', 'Pages::display');``` the fact that you have a pages table remove that default functionality After that you should be able to go to ```/pages => index function /pages/add => add function /pages/edit/<ID> => edit function /pages/view/<ID> => view function /pages/delete/<ID> => delete
# Jul 18th 2021, 19:55 kevin.pfeifer index => table of all present entries view => detail view of one entry add => form to add an entry edit => form to edit an entry delete => just functionality to delete a function These functions are auto-generated from the bake CLI tool inside your controller
# Jul 18th 2021, 19:53 kevin.pfeifer the display method is only used in the Pages Controller for "static" page-templates which are set in the `templates/pages` directory What you want is the index function if you want a table of all present entries for the `pages` table (exactly what the bake CLI tool auto-generates for you)
# Jul 18th 2021, 19:41 kevin.pfeifer if you call that url normally at least GET should be in there
# Jul 18th 2021, 19:41 kevin.pfeifer not the functions in your controllers
# Jul 18th 2021, 19:41 kevin.pfeifer `$this->request->allowMethod` should have one of the HTTP Methods like GET, POST, PUT, DELETE etc.
# Jul 18th 2021, 19:28 kevin.pfeifer well what url are you calling when that error occurs
# Jul 18th 2021, 19:27 kevin.pfeifer or do you actually have a table called `pages` where you want to show entries like any other table?
# Jul 18th 2021, 19:20 kevin.pfeifer usually `/pages/*` is routed to the display function of the Display Controller https://github.com/cakephp/app/blob/master/config/routes.php#L58 Is that still the way how you have pages implemented in your code?
# Jul 18th 2021, 16:15 cnizzardini Now this really depends on your application if this is even possible. Seems best for APIs.
# Jul 18th 2021, 16:15 cnizzardini ^ Next time I need to rewrite something I am trying this approach.
# Jul 18th 2021, 16:14 cnizzardini https://martinfowler.com/bliki/StranglerFigApplication.html
# Jul 18th 2021, 11:08 kevin.pfeifer expecting that your database structure follows the cakephp naming schema
# Jul 18th 2021, 11:08 kevin.pfeifer I would start a new one, use the `bin/cake bake` tool as much as possible to auto-generate the code which can be derived from the table and column names and copy-paste the custom code (where you probably have to adjust a bit more)
# Jul 18th 2021, 11:02 vikas *Suggestions*: Will it be advisable to upgrade a legacy cake2 application to cake4 or completely rewrite the whole stuff??
# Jul 18th 2021, 08:25 hmic the default pathPrefix is files/
# Jul 18th 2021, 08:25 hmic lzz: https://book.cakephp.org/4/en/views/helpers/html.html#linking-to-videos-and-audio-files
# Jul 18th 2021, 07:08 lzz Where/What folder should I create for video? $this->Html->media()? I tried media and files inside webroot but I get 404 for both of them.
# Jul 17th 2021, 21:54 alamnaryab thank you @kevin.pfeifer this worked
# Jul 17th 2021, 21:41 slackebot2 ->where(['FeeRates.status'=>1,'FeeRates.academic_session_id'=> $s_id ]) ->order(['FeeRates.sort'=>'asc']); } ]) ->all();```
# Jul 17th 2021, 21:41 kevin.pfeifer you need to pass that variable inside that anonymous function via `use` https://www.php.net/manual/en/functions.anonymous.php ```$s_id = 1; $school_classes = $this->SchoolClasses->find() ->where(['SchoolClasses.status'=>1]) ->order(['SchoolClasses.sort'=>'asc']) ->contain([ 'FeeRates'=>function($q) use ($s_id){ return $q
# Jul 17th 2021, 21:27 slackebot2 ->where(['FeeRates.status'=>1,'FeeRates.academic_session_id'=> $s_id ]) ->order(['FeeRates.sort'=>'asc']); } ]) ->all();``` How can I do it. or any other alternate.
# Jul 17th 2021, 21:27 alamnaryab I want to make condition on inside `contain` but external variable is not accessable ```$s_id = 1; /**** this variable is not accessable inside contain */ $school_classes = $this->SchoolClasses->find() ->where(['SchoolClasses.status'=>1]) ->order(['SchoolClasses.sort'=>'asc']) ->contain([ 'FeeRates'=>function($q){ return $q
# Jul 17th 2021, 21:22 alamnaryab Hi frinds
# Jul 17th 2021, 13:15 kevin.pfeifer I know that tables !== complexity of the project but still its something countable :)
# Jul 17th 2021, 13:14 kevin.pfeifer how many tables?
# Jul 17th 2021, 13:01 neothermic (I honestly sometimes ponder if it's the largest cake2 project in production..)
# Jul 17th 2021, 12:54 kevin.pfeifer well then good luck :)
# Jul 17th 2021, 12:53 neothermic it is an eventual goal to upgrade the work stuff to 7.4, but since works' codebase is a frigging gigantic cakephp2 project, that's not quick :P
# Jul 17th 2021, 12:52 neothermic I should really create a new VM to match my personal stuff, as that's on 7.2 at least..
# Jul 17th 2021, 12:51 kevin.pfeifer ah^^
# Jul 17th 2021, 12:51 neothermic my local vagrant is also my work replication setup, and that's still on 7.1, so can't run 4.x :)
# Jul 17th 2021, 12:51 kevin.pfeifer anyway, is there a specific reason why you start with 3.8 instead of 4.2?