| # |
Dec 30th 2019, 21:19 |
 phpnut |
cberdata" |
| # |
Dec 30th 2019, 21:19 |
phantomwatson |
Duh. Not sure why my first instinct was to blame the core. :slightly_frowning_face: |
| # |
Dec 30th 2019, 21:17 |
phantomwatson |
Oh crap, the `queue_processes` table from the `Queue` plugin has a field by that name. |
| # |
Dec 30th 2019, 21:17 |
ndm |
https://github.com/dereuromark/cakephp-queue/blob/4.2.2/src/Model/Table/QueueProcessesTable.php#L77-L82 |
| # |
Dec 30th 2019, 21:16 |
phantomwatson |
Yeah, that's what I'm saying. There's no reference to a field by that name in any first-party code for this application. |
| # |
Dec 30th 2019, 21:16 |
ndm |
Maybe it's from a plugin, the queue stuff seems 3rd party |
| # |
Dec 30th 2019, 21:16 |
phpnut |
or 'server.cberdata |
| # |
Dec 30th 2019, 21:15 |
phpnut |
@phantomwatson search the code for 'server. |
| # |
Dec 30th 2019, 21:14 |
phantomwatson |
Yeah, I can't quite make sense of it. There is no field named `server` in any of this application's tables, and there's no reference to a field by that name in any code under `/src` or `/config`. |
| # |
Dec 30th 2019, 21:12 |
ndm |
Well I don't how how any of that might be related, but that query is clearly triggered by a validation rule for a field named `server`. |
| # |
Dec 30th 2019, 21:06 |
phantomwatson |
I'm assuming this has something to do with my datasource configuration, but I'm not sure how. I had just updated an Elasticsearch index and disabled Kibana, but I wouldn't expect that to prevent CakePHP from being able to access it. |
| # |
Dec 30th 2019, 21:04 |
slackebot |
/home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Console/CommandRunner.php(385): Cake\Console\Shell->runCommand(Array, true) #19 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Console/CommandRunner.php(162): Cake\Console\CommandRunner->runShell(Object(Queue\Shell\QueueShell), Array) #20 /home/okbvtfr/public_html/school/bin/cake.php(12): Cake\Console\CommandRunner->run(Array) #21 {main}``` |
| # |
Dec 30th 2019, 21:04 |
slackebot |
/home/okbvtfr/public_html/school/vendor/dereuromark/cakephp-queue/src/Shell/QueueShell.php(686): Queue\Model\Table\QueueProcessesTable->add('8635', '9932243dbdfc163...') #16 /home/okbvtfr/public_html/school/vendor/dereuromark/cakephp-queue/src/Shell/QueueShell.php(162): Queue\Shell\QueueShell->_initPid() #17 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Console/Shell.php(517): Queue\Shell\QueueShell->runworker() #18 |
| # |
Dec 30th 2019, 21:04 |
slackebot |
/home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/ORM/Marshaller.php(182): Cake\ORM\Marshaller->_validate(Array, Array, true) #13 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/ORM/Table.php(2645): Cake\ORM\Marshaller->one(Array, Array) #14 /home/okbvtfr/public_html/school/vendor/dereuromark/cakephp-queue/src/Model/Table/QueueProcessesTable.php(129): Cake\ORM\Table->newEntity(Array) #15 |
| # |
Dec 30th 2019, 21:04 |
slackebot |
/home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Database/Connection.php(333): Cake\Database\Statement\MysqlStatement->execute() #2 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php(67): Cake\Database\Connection->Cake\Database\{closure}() #3 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Database/Connection.php(336): Cake\Core\Retry\CommandRetry->run(Object(Closure)) #4 |
| # |
Dec 30th 2019, 21:04 |
slackebot |
Cake\Validation\ValidationRule->process('server.cberdata...', Array, Array) #10 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Validation/Validator.php(202): Cake\Validation\Validator->_processRules('server', Object(Cake\Validation\ValidationSet), Array, true) #11 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/ORM/Marshaller.php(260): Cake\Validation\Validator->errors(Array, true) #12 |
| # |
Dec 30th 2019, 21:04 |
slackebot |
/home/okbvtfr/public_html/school/vendor/dereuromark/cakephp-queue/src/Model/Table/QueueProcessesTable.php(98): Cake\ORM\Query->count() #8 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Validation/ValidationRule.php(139): Queue\Model\Table\QueueProcessesTable->validateCount('server.cberdata...', Array) #9 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Validation/Validator.php(2612): |
| # |
Dec 30th 2019, 21:04 |
slackebot |
/home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Database/Query.php(218): Cake\Database\Connection->run(Object(Cake\ORM\Query)) #5 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/ORM/Query.php(956): Cake\Database\Query->execute() #6 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/ORM/Query.php(906): Cake\ORM\Query->_performCount() #7 |
| # |
Dec 30th 2019, 21:04 |
phantomwatson |
Yeah, here it is: ```2019-12-30 20:46:58 Error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'server' in 'where clause' in /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 38 Stack Trace: #0 /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php(38): PDOStatement->execute(NULL) #1 |
| # |
Dec 30th 2019, 20:59 |
ndm |
There should be a stacktrace for that error |
| # |
Dec 30th 2019, 20:45 |
phantomwatson |
This seems to be a core thing, as I don't think any of my queries include a `server` field. |
| # |
Dec 30th 2019, 20:44 |
phantomwatson |
Anyone know what this might be about? ```Error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'server' in 'where clause' in /home/okbvtfr/public_html/school/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 38``` |
| # |
Dec 30th 2019, 19:26 |
ricksaccous |
ballerrrrr |
| # |
Dec 30th 2019, 19:25 |
admad |
`$Foo->updateAll('fld = fld + 1', $someCondition)` |
| # |
Dec 30th 2019, 19:25 |
admad |
`$Foo->updateAll('fld = fld + ', $someCondition)` |
| # |
Dec 30th 2019, 19:25 |
charolastra |
without the ORM part |
| # |
Dec 30th 2019, 19:25 |
ricksaccous |
do you mean save in db without building entities? |
| # |
Dec 30th 2019, 19:24 |
kevin.pfeifer |
what do you mean access the table without building entities? |
| # |
Dec 30th 2019, 19:22 |
charolastra |
suspected Cake\ORM\Table to handle that but seems not. how the access the able without building entities? |
| # |
Dec 30th 2019, 19:11 |
kevin.pfeifer |
i would also suggest you use a table for that |
| # |
Dec 30th 2019, 19:08 |
ricksaccous |
if it doesn't need to be persisted you could use cache or session |
| # |
Dec 30th 2019, 19:08 |
charolastra |
actually just by a cron console command for now |
| # |
Dec 30th 2019, 19:08 |
ricksaccous |
table seems fine to me, especially if the data needs to be persisted even after the user enters and exits the site |
| # |
Dec 30th 2019, 19:07 |
ricksaccous |
in what situation do they get incremented |
| # |
Dec 30th 2019, 19:05 |
kevin.pfeifer |
should these settings be editable via the webinterface? |
| # |
Dec 30th 2019, 18:59 |
charolastra |
how to handle configurations settings or values that get incremented. a whole model seems overkill, even a table if i just store e.g. 5 values |
| # |
Dec 30th 2019, 17:47 |
tibor.hajos |
@ndm Great, thank you! |
| # |
Dec 30th 2019, 16:57 |
kevin.pfeifer |
ahhh gotcha, thx for the clarification |
| # |
Dec 30th 2019, 16:55 |
dsar |
@kevin.pfeifer just to understand what happened, the problem lies in the fact that the field 'modified' is near to the end of year and YYYY uses a different way to count years (weeks instead of days), so it went to the next year |
| # |
Dec 30th 2019, 16:54 |
ndm |
@tibor.hajos You'll have to ditch the interface and use the old style `__invoke()` handler just like the other middlewars do in 3.x |
| # |
Dec 30th 2019, 16:51 |
kevin.pfeifer |
well... the fact that we have/need different formats for so many things is quite frustrating... but thats a discussion I dont want to start^^ But still thank you guys for the help :D :pray: |