| # |
Jul 1st 2021, 19:02 |
 tyler.adam.lazenby |
I am so frustrated with this. I am bout to lose my mind |
| # |
Jul 1st 2021, 19:01 |
tyler.adam.lazenby |
workstation 01 |
| # |
Jul 1st 2021, 19:01 |
tyler.adam.lazenby |
I had the same thing happen to me at work |
| # |
Jul 1st 2021, 18:56 |
kevin.pfeifer |
well **** me, i have a whitespace in my user-path which seems to screw everything up so THANKS WINDOWS :clap: |
| # |
Jul 1st 2021, 18:54 |
tyler.adam.lazenby |
ok now I am getting SOMEWHERE |
| # |
Jul 1st 2021, 18:36 |
tyler.adam.lazenby |
no |
| # |
Jul 1st 2021, 18:36 |
tyler.adam.lazenby |
it says in the assertions that it sent but |
| # |
Jul 1st 2021, 18:36 |
tyler.adam.lazenby |
I don't get it... why is it still not showing up |
| # |
Jul 1st 2021, 18:33 |
tyler.adam.lazenby |
ok thank you |
| # |
Jul 1st 2021, 18:33 |
tyler.adam.lazenby |
ij |
| # |
Jul 1st 2021, 18:33 |
tyler.adam.lazenby |
ohhhh |
| # |
Jul 1st 2021, 18:33 |
admad |
It provides a webui at port 8025 for viewing the mails |
| # |
Jul 1st 2021, 18:31 |
tyler.adam.lazenby |
I am trying to figure that one out but I open it and ijust is a command line thing... |
| # |
Jul 1st 2021, 18:30 |
admad |
@tyler.adam.lazenby mailhog |
| # |
Jul 1st 2021, 18:29 |
tyler.adam.lazenby |
hahha |
| # |
Jul 1st 2021, 18:22 |
kevin.pfeifer |
mhmm, i could try even though i basically refuse to do any coding on windows ,:) |
| # |
Jul 1st 2021, 18:21 |
tyler.adam.lazenby |
Windows 10 |
| # |
Jul 1st 2021, 18:21 |
kevin.pfeifer |
xampp on which OS? |
| # |
Jul 1st 2021, 18:19 |
tyler.adam.lazenby |
I was wondering if there is an easy to set up dummy email server that people knew about |
| # |
Jul 1st 2021, 18:18 |
tyler.adam.lazenby |
the thing is if I disable mercury for example it will just tell me it can't connect to a mail server |
| # |
Jul 1st 2021, 18:18 |
kevin.pfeifer |
use a dummy email address from a real SMTP server? |
| # |
Jul 1st 2021, 18:15 |
tyler.adam.lazenby |
anybody know of an easier solution? |
| # |
Jul 1st 2021, 18:15 |
tyler.adam.lazenby |
What is the easiest way to send email from your local server (so that I can test my email sending in cakephp). I have been trying with xampp mercury for hours and can't even get it to send to root@localhost, even though I can send test emails through the mercury interface |
| # |
Jul 1st 2021, 18:02 |
kevin.pfeifer |
also: shouldn't part of your where function be placed in a `->having()` because you want to filter by grouped data? like the `ResourcesCounts.date BETWEEN etc.` |
| # |
Jul 1st 2021, 17:56 |
staccato123 |
@ndm Ah, thanks. That's not obvious from the docs. |
| # |
Jul 1st 2021, 17:49 |
kevin.pfeifer |
damn that makes sense :see_no_evil: :,) i need more coffee |
| # |
Jul 1st 2021, 17:42 |
ndm |
staccato123: `hasMany` associations are not being joined, they are being retrieved in a separate query. If you want them joined, then you need to join them, not contain them - check `innerJoinWith()` and `leftJoinWith()`. |
| # |
Jul 1st 2021, 16:16 |
staccato123 |
(obviously the JOIN needs an ON clause as well :) ) |
| # |
Jul 1st 2021, 16:16 |
staccato123 |
Fair enough, thanks for looking |
| # |
Jul 1st 2021, 16:13 |
kevin.pfeifer |
can't tell you, sorry :shru |
| # |
Jul 1st 2021, 16:11 |
staccato123 |
Looking at the query log, all the query needs is "JOIN resources_count ResourcesCounts" adding |
| # |
Jul 1st 2021, 16:07 |
staccato123 |
error is "Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ResourcesCounts.date' in 'where clause'" as you would expect |
| # |
Jul 1st 2021, 16:05 |
staccato123 |
https://pastebin.com/YHkq9NZe |
| # |
Jul 1st 2021, 16:04 |
staccato123 |
*there's |
| # |
Jul 1st 2021, 16:04 |
staccato123 |
There's SQL. There no JOIN |
| # |
Jul 1st 2021, 16:01 |
kevin.pfeifer |
or do you get an error? |
| # |
Jul 1st 2021, 16:00 |
kevin.pfeifer |
is there SQL generated when you look into it via debug kit? |
| # |
Jul 1st 2021, 15:59 |
kevin.pfeifer |
:thinking_face: so you don’t need to set the extra `className` property because the alias (1st parameter) is the same as the TableObject name |
| # |
Jul 1st 2021, 15:55 |
staccato123 |
yes |
| # |
Jul 1st 2021, 15:55 |
kevin.pfeifer |
but the resources_counts Table Class is called `ResourcesCountsTable`? |
| # |
Jul 1st 2021, 15:18 |
staccato123 |
The only unusualness is that the table for ResourcesCounts is resources_count rather than resources_counts, but I've done a setTable |