Log message #4170668

# At Username Text
# Oct 7th 2018, 10:25 ssalvatori hello
# Oct 7th 2018, 06:49 Wobni A mikrotik is fanless, noisless, and uses 2 watts/hr
# Oct 7th 2018, 06:49 Wobni which one do you eat
# Oct 7th 2018, 06:49 Wobni WiseNoob, if you're powering those leds with external supply there's nothing to worry
# Oct 7th 2018, 06:49 Wobni and dollars.
# Oct 7th 2018, 06:49 Wobni it's also pointing out stuff in mingw's headers lol
# Oct 7th 2018, 05:39 adithya Hi, which is a good plugin to generate PDF's ?
# Oct 7th 2018, 01:49 MiningMarsh lopid: I don't follow at all, unfortunately.
# Oct 7th 2018, 01:49 MiningMarsh haasn: unrelated to haskell, it may also be confusing to find words being reused differently like container names
# Oct 7th 2018, 00:05 mapuwp baxx: operator and operation means different things
# Oct 7th 2018, 00:05 mapuwp and true falsehoods
# Oct 7th 2018, 00:05 mapuwp so they rob an apple store?
# Oct 7th 2018, 00:05 mapuwp yes i guess?
# Oct 7th 2018, 00:05 mapuwp but no way i learn it
# Oct 7th 2018, 00:04 mapuwp may have needed \r or \n\r or something like that, it a bit fuzzy
# Oct 6th 2018, 23:16 Ashleeegv with ipv6
# Oct 6th 2018, 23:16 Ashleeegv it looks up the key you give it in the table you give it and finds the next one
# Oct 6th 2018, 23:15 dereuromark using contain they should afaik. otherwise you need to list them in select too
# Oct 6th 2018, 23:15 rightscoreanalysis can I get the parent/main table fields by default without having to list them all?
# Oct 6th 2018, 23:14 rightscoreanalysis that performs the join but I literally just see the joined model id
# Oct 6th 2018, 23:14 slackebot <rightscoreanalysis>
# Oct 6th 2018, 23:14 rightscoreanalysis Ok I am getting closer
# Oct 6th 2018, 23:09 dereuromark try join and selecting the fields you need
# Oct 6th 2018, 23:08 rightscoreanalysis so should I persist with Contain or Join in this case?
# Oct 6th 2018, 23:08 dereuromark I see. yeah, the joins here are wrong then
# Oct 6th 2018, 23:04 rightscoreanalysis Column not found: 1054 Unknown column 'Rooms.id' in 'where clause'
# Oct 6th 2018, 23:04 rightscoreanalysis the error I got which lead me to believe contain would not work for me in this case is:
# Oct 6th 2018, 23:04 rightscoreanalysis https://gist.github.com/spacebiscuit/13497a100c2f6c453c4f3d097dd78498
# Oct 6th 2018, 23:04 rightscoreanalysis this is what I was attempting with contains:
# Oct 6th 2018, 22:59 rightscoreanalysis Ok let me post my previous contains to see if I can expalin the issue I had
# Oct 6th 2018, 22:56 dereuromark the join probably doesnt without select() field naming. another reason to use relations and contain :slightly_smiling_face: I guess
# Oct 6th 2018, 22:55 rightscoreanalysis but when I debug $result->first() I do not see the model I have joined on
# Oct 6th 2018, 22:53 rightscoreanalysis ok so moving the 'first()' to the end of the query fixes the error I was seeing
# Oct 6th 2018, 22:52 dereuromark find() and count(), all() are closing ones. after that you get a collection, not a query
# Oct 6th 2018, 22:52 dereuromark you need to understand how the orm works.
# Oct 6th 2018, 22:51 rightscoreanalysis ok so find() should be the last thing
# Oct 6th 2018, 22:51 dereuromark you cannot close a query though and then continue doing things on the resulting entity.
# Oct 6th 2018, 22:51 rightscoreanalysis Or Properties / properties
# Oct 6th 2018, 22:51 rightscoreanalysis should it be singlur Property with table named 'properties'
# Oct 6th 2018, 22:50 rightscoreanalysis I am modelling Properties
# Oct 6th 2018, 22:50 dereuromark the error message tells you that (entity vs table/query)