| # |
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 |
| # |
Feb 12th 2018, 21:26 |
clementcrownrise |
the issue is that, i just created this field , after I have backed my application , and I also added the field to the database and form |
| # |
Feb 12th 2018, 21:26 |
admad |
clear model cache |
| # |
Feb 12th 2018, 21:26 |
clementcrownrise |
yes, it is set |
| # |
Feb 12th 2018, 21:25 |
admad |
ensure that field is always set when creating new record or set a default value for it in db. |
| # |
Feb 12th 2018, 21:24 |
clementcrownrise |
please why am I having this error Error: SQLSTATE[HY000]: General error: 1364 Field 'monthofexaminationpassed' doesn't have a default value |
| # |
Feb 12th 2018, 21:23 |
clementcrownrise |
is anyone in the room |
| # |
Feb 12th 2018, 21:23 |
clementcrownrise |
hello |
| # |
Feb 12th 2018, 20:52 |
ank068 |
File uploaded https://cakesf.slack.com/files/U91GR08DV/F982JQZ7F/-.txt / https://slack-files.com/T053DPNCM-F982JQZ7F-6810101081 - Anyone know what this error means? and what kind of objects or code i should be looking at? |