# |
Jul 1st 2021, 19:10 |
kevin.pfeifer |
well if your not familiar with how a webserver/database/mailserver setup works in linux then you still have a lot of googleing to do ^^ |
# |
Jul 1st 2021, 19:06 |
tyler.adam.lazenby |
i just want it to work |
# |
Jul 1st 2021, 19:06 |
kevin.pfeifer |
and I hope i don't stir up an linux diehards here arguing about arch or something like that ,:) |
# |
Jul 1st 2021, 19:05 |
kevin.pfeifer |
Ubuntu or Mint is the go to distro for me |
# |
Jul 1st 2021, 19:04 |
tyler.adam.lazenby |
it would be my first time using it that way, so which distrubutable would you reccomend? |
# |
Jul 1st 2021, 19:03 |
tyler.adam.lazenby |
With this project I might just do that |
# |
Jul 1st 2021, 19:03 |
kevin.pfeifer |
well then I would just install virtualbox and do everything inside a VM :,) |
# |
Jul 1st 2021, 19:02 |
tyler.adam.lazenby |
I might need a break |
# |
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 |