# |
Jul 19th 2021, 16:41 |
tyler.adam.lazenby |
help |
# |
Jul 19th 2021, 16:33 |
tyler.adam.lazenby |
```2021-07-19 10:32:35 Error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'QueuedJobs.job_task' in 'where clause' in C:\xampp\htdocs\ezBusinessManager\vendor\cakephp\cakephp\src\Database\Statement\MysqlStateme nt.php on line 39``` |
# |
Jul 19th 2021, 16:16 |
dereuromark |
As for the naming, I see an issue of `implements addInterface` vs AddInterface (casing matters), but it might not be relevant for this case. |
# |
Jul 19th 2021, 16:16 |
dereuromark |
Tip: upgrade to v6, it has a few better ways to directly detect issues with e.g. naming |
# |
Jul 19th 2021, 16:15 |
tyler.adam.lazenby |
https://pastebin.com/SBWFhtzm |
# |
Jul 19th 2021, 16:14 |
tyler.adam.lazenby |
https://pastebin.com/ifdkDas5 |
# |
Jul 19th 2021, 16:13 |
tyler.adam.lazenby |
ok \ |
# |
Jul 19th 2021, 16:12 |
dereuromark |
You might need to "pastebin" the whole code, incl path, maybe someone sees your mistake |
# |
Jul 19th 2021, 16:11 |
tyler.adam.lazenby |
and I have run the phpstorm generate and the annotate all |
# |
Jul 19th 2021, 16:11 |
tyler.adam.lazenby |
yes |
# |
Jul 19th 2021, 16:11 |
dereuromark |
something, usually a typo somewhere, or missing use statement. are you using PHPStorm or a high level IDE? |
# |
Jul 19th 2021, 16:10 |
tyler.adam.lazenby |
what did you mean the sth? @dereuromark |
# |
Jul 19th 2021, 16:10 |
tyler.adam.lazenby |
I am still not finding the issue |
# |
Jul 19th 2021, 15:50 |
slackebot2 |
year due to various tweaks to “bake” and the IDE Helper. |
# |
Jul 19th 2021, 15:50 |
ewbarnard |
General comment - I use the @dereuromark IdeHelper now as part of my workflow and it surely does help PhpStorm to help me. I’ve decided to rely entirely on “bake” code generator for Entity/Table class generation followed by invoking illuminator + annotate. My own Model-related code goes in a Repository/ folder specific to the feature I’m developing. I’m pretty sure this approach only became possible over the past |
# |
Jul 19th 2021, 15:42 |
dereuromark |
you might not properly implement the base task or sth. Make sure to always use the IdeHelper autocomplete as well, it will also give you hints about invalid task setup. |
# |
Jul 19th 2021, 15:41 |
tyler.adam.lazenby |
But for some reason, this task won't run when I use `bin/cake queue runworker` |
# |
Jul 19th 2021, 15:40 |
tyler.adam.lazenby |
```^C-bash-4.2$ env PATH="/opt/plesk/php/8.0/bin:$PATH" bin/cake queue stats Total unfinished jobs: 1 Running workers (processes): 0 Server name: plesk04.eznettools.net --------------------------------------------------------------- Jobs currently in the queue: - AddContacts : 1 --------------------------------------------------------------- Finished job statistics:``` |
# |
Jul 19th 2021, 15:40 |
tyler.adam.lazenby |
@dereuromark I can't seem to figure out why this task isn't being picked up by the runner |
# |
Jul 19th 2021, 14:16 |
admad |
@isvyas well than my 1st question stands :) |
# |
Jul 19th 2021, 13:00 |
greg138 |
@rudy1976s, what does your fixture look like? And what does "not able to work" mean? |
# |
Jul 19th 2021, 12:45 |
isvyas |
@admad No, it's the components directory for Vue or JS specific code. |
# |
Jul 19th 2021, 12:18 |
admad |
Is `resources/js/components/AppGreet.vue` withing `ROOT/templates` too? |
# |
Jul 19th 2021, 12:17 |
admad |
Overtime I imagine I would be trying to remember whether a chunk of HTML is coming from a Cake template or a .vue file. |
# |
Jul 19th 2021, 12:16 |
admad |
@isvyas what's the benefit of having the layout and `templates/Pages/greet.php` generated through Cake? Having some on your HTML as Cake templates and that for components as pure .vue files doesn't seem very good for management. |
# |
Jul 19th 2021, 11:37 |
rudy1976s |
Hello !!! I am writing a text for a table which has a json column. I have warnings by phpunit related : it seems that fixture is not able to work with json data. is that possible ? is there something to know about it ? |
# |
Jul 19th 2021, 11:31 |
isvyas |
Hi Guys, Checkout my latest blog post on how to integrate Vue.js with CakePHP: https://ishanvyas.hashnode.dev/integrate-vuejs-with-cakephp-framework Feedback appreciated :raised_hands::skin-tone-3: Let me know if I'm missing anything. Also, suggest the topics in which you guys need blog posts so if I have knowledge about it I can create an article on it. |
# |
Jul 19th 2021, 11:24 |
admad |
@slack1780 this->element('nav', ['id' => $identity]) |
# |
Jul 18th 2021, 22:38 |
kevin.pfeifer |
yes, the identity object is not automatically set in the view either you get it via the request object (same way as in controller) inside your template or set the identity variable in the appcontroller so its present everywhere without going through the request everytime |
# |
Jul 18th 2021, 21:22 |
kevin.pfeifer |
there is also this plugin https://github.com/icings/menu which uses the KnpMenu But I never used it so :man-shrugging: |
# |
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) |