Log message #4116658

# At Username Text
# 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
# Feb 12th 2018, 21:31 clementcrownrise i deleted the files manually
# Feb 12th 2018, 21:31 clementcrownrise the same error still persists
# Feb 12th 2018, 21:30 admad check the manual on how to run the cake shell on windows
# Feb 12th 2018, 21:29 admad on windoz you probably need to use bin/cake.bat
# Feb 12th 2018, 21:29 clementcrownrise let me follow the manual process
# Feb 12th 2018, 21:29 clementcrownrise i guess that command is not correct
# Feb 12th 2018, 21:29 clementcrownrise Exception: Unknown command `cake orm`. Run `cake --help` to get the list of valid commands. in [C:\wamp\www\wacsapplication\vendor\cakephp\cakephp\src\Console\CommandRunner.php, line 177]
# Feb 12th 2018, 21:28 admad or delete files manually under tmp/cache/models folder
# Feb 12th 2018, 21:28 admad bin/cake orm clear
# Feb 12th 2018, 21:27 clementcrownrise how please, i am new to cakephp
# Feb 12th 2018, 21:27 clementcrownrise please how do I clear my model cache @admad
# Feb 12th 2018, 21:27 admad like is said clear model cach