Log message #4116670

# At Username Text
# 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?
# Feb 12th 2018, 21:47 aro say i have three records (all habtm tags) - Record A, B and C. Record A has 2 tags, record B has 3, record C has 1. When i do a query, id like to have record B, A, C
# Feb 12th 2018, 21:47 meder anyone have any tips for profiling on a production server? my app is solid / fast in dev/staging but super slow in production. hardware seems consistent
# Feb 12th 2018, 21:47 john Other than a COUNT() and group by ?
# Feb 12th 2018, 21:40 aro is there a way to do a search on join to a habtm and sort by descending order of the number of matches? like if you are searching tags
# Feb 12th 2018, 21:35 clementcrownrise i still have the same error
# Feb 12th 2018, 21:33 clementcrownrise so let me try and submit the form again
# Feb 12th 2018, 21:33 clementcrownrise ok, i have used cake orm_cache clear