Log message #4116677

# At Username Text
# Feb 13th 2018, 02:53 savant elephantguy: yeah they are being produced
# Feb 13th 2018, 02:08 elephantguy i ordered the preorder in august last year, still hoping it happens https://swag.cakephp.org/products/cakephp-elephpant?variant=43020313236
# Feb 13th 2018, 02:07 elephantguy anyone know if the cakephp elephpants are getting produced?
# Feb 13th 2018, 01:34 aro im trying to add it as a subquery, but cake keeps executing it
# Feb 13th 2018, 01:32 aro how do i make cake select this as a field in a paginate? ``` (SELECT COUNT(*) FROM tags_tags as T LEFT JOIN tags_tagged TT ON T.id = TT.tag_id WHERE TT.fk_model = 'Proposals' AND TT.fk_id = Proposals.id AND TT.tag_id IN (6,1)) as matches,```
# Feb 13th 2018, 01:20 ahmed_bodi atleast it shouldnt be showing errors in production. Although you may have display errors enabled
# Feb 13th 2018, 01:19 ahmed_bodi and display that page
# Feb 13th 2018, 01:18 ahmed_bodi on production it'll throw a HTTP 500
# Feb 13th 2018, 01:18 meder hahahaha
# Feb 13th 2018, 01:18 ahmed_bodi lol
# Feb 13th 2018, 01:18 ahmed_bodi ohhh
# Feb 13th 2018, 01:18 meder lol i was actually asking my own question
# Feb 13th 2018, 01:18 ahmed_bodi instead its /admin/en/users
# Feb 13th 2018, 01:18 ahmed_bodi i expected to have a url like /en/admin/users
# Feb 13th 2018, 01:18 ahmed_bodi @meder managed to get it. For some reason the prefix is fucking things up
# Feb 13th 2018, 01:00 meder on development i dont get anything if i have a controller with a missing template file, but in production it throws a missing plugin etc
# Feb 13th 2018, 00:59 meder in production/non-debug, does it throw an error moreso if you're missing a template for a controller file?
# Feb 13th 2018, 00:43 ahmed_bodi its like its not applying the language changes on the fallback routes
# Feb 13th 2018, 00:41 ahmed_bodi I'm looking for a way to add i18n routing to my site, i want all the pages prefixed with the language which i can handle. But its the routing which is confusing me, I've tried admad's plugin and that just makes them all give me route not found errors
# Feb 12th 2018, 23:13 ahmed_bodi Hi guys, has anyone used cakephp-translate plugin?
# Feb 12th 2018, 22:38 aro ok, so i found what i need to do, but i am getting an error
# Feb 12th 2018, 22:28 john Admittingly, I'm more experienced in CakePHP 2 than 3. You may want to ask the general channel how to do that.
# Feb 12th 2018, 22:23 xapak Hello.
# Feb 12th 2018, 22:03 aro how do you execute a subquery as a field select?
# Feb 12th 2018, 22:02 aro hmm
# Feb 12th 2018, 22:00 john The count should include only the affected tags in the result set, not all tags in the relationship
# Feb 12th 2018, 22:00 aro the relation is included
# Feb 12th 2018, 21:59 aro but yes
# Feb 12th 2018, 21:59 aro i was doinga left join
# Feb 12th 2018, 21:58 john If you're inner joining, are you including the HABTM in the query conditions?
# Feb 12th 2018, 21:57 aro see what i mean?
# Feb 12th 2018, 21:57 aro id onlky want the count of record A to match 3, not 4 (being the total count of tags that exist)
# Feb 12th 2018, 21:57 aro if i query ABC
# Feb 12th 2018, 21:56 aro and C has [b,c,e]
# Feb 12th 2018, 21:56 aro record B has [a,c]
# Feb 12th 2018, 21:56 aro say record A has tags [a,b,c,d]
# Feb 12th 2018, 21:56 aro in theory yes, but that will return the count of the # of tags the record has, not the # that were matched as part of the query
# Feb 12th 2018, 21:54 john Could you group by the record ID, and add `COUNT(records.id)` to the selected fields?
# Feb 12th 2018, 21:53 john I've had good luck with it for investigating why some requests are slow.
# Feb 12th 2018, 21:52 john New Relic offers a free tier for application monitoring (at least, according to https://discuss.newrelic.com/t/is-there-still-free-apm-lite-plan/43076/2 it's still offered)
# Feb 12th 2018, 21:48 aro so what would i group by?