| # |
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? |
| # |
Feb 12th 2018, 20:49 |
saeideng |
cake ver: 3.5.12 |
| # |
Feb 12th 2018, 20:48 |
saeideng |
for your plugin https://github.com/lorenzo/cakephp-email-queue |
| # |
Feb 12th 2018, 20:46 |
slackebot1 |
/var/www/html/site/vendor/cakephp/cakephp/src/Console/Shell.php(507): EmailQueue\Shell\PreviewShell->main() #5 /var/www/html/site/vendor/cakephp/cakephp/src/Console/CommandRunner.php(141): Cake\Console\Shell->runCommand(Array, true) #6 /var/www/html/site/bin/cake.php(12): Cake\Console\CommandRunner->run(Array) #7 {main} ``` |
| # |
Feb 12th 2018, 20:46 |
slackebot1 |
#1 /var/www/html/site/vendor/cakephp/cakephp/src/Mailer/Email.php(1569): Cake\Mailer\Email->setTransport('Debug') #2 /var/www/html/site/vendor/lorenzo/cakephp-email-queue/src/Shell/PreviewShell.php(56): Cake\Mailer\Email->transport('Debug') #3 /var/www/html/site/vendor/lorenzo/cakephp-email-queue/src/Shell/PreviewShell.php(38): EmailQueue\Shell\PreviewShell->preview(Object(Cake\ORM\Entity)) #4 |
| # |
Feb 12th 2018, 20:46 |
saeideng |
``` Email : Exception: Transport config "Debug" is missing. in [/var/www/html/site/vendor/cakephp/cakephp/src/Mailer/Email.php, line 1582] 2018-02-12 20:42:04 Error: [InvalidArgumentException] Transport config "Debug" is missing. in /var/www/html/site/vendor/cakephp/cakephp/src/Mailer/Email.php on line 1582 Stack Trace: #0 /var/www/html/site/vendor/cakephp/cakephp/src/Mailer/Email.php(1523): Cake\Mailer\Email->_constructTransport('Debug') |
| # |
Feb 12th 2018, 20:45 |
saeideng |
# bin/cake EmailQueue.preview |