| # |
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: |
| # |
Dec 30th 2019, 16:49 |
dsar |
Pretty evil |
| # |
Dec 30th 2019, 16:48 |
dsar |
_May not always be the same value as calendar year._ |
| # |
Dec 30th 2019, 16:48 |
dsar |
https://unicode-org.github.io/icu-docs/apidoc/released/icu4c/classSimpleDateFormat.html#details |
| # |
Dec 30th 2019, 16:46 |
admad |
ICU placeholders are pretty funky |
| # |
Dec 30th 2019, 16:41 |
kevin.pfeifer |
still strange why it wasn't wrong for created but :man-shrugging: |
| # |
Dec 30th 2019, 16:40 |
kevin.pfeifer |
thx for the help guys |
| # |
Dec 30th 2019, 16:40 |
kevin.pfeifer |
@admad thx :) |
| # |
Dec 30th 2019, 16:40 |
kevin.pfeifer |
according to http://userguide.icu-project.org/formatparse/datetime "YYYY" is wrong |
| # |
Dec 30th 2019, 16:40 |
admad |
@kevin.pfeifer use yyyy to fix your year |
| # |
Dec 30th 2019, 16:39 |
kevin.pfeifer |
thats what confused me |
| # |
Dec 30th 2019, 16:39 |
kevin.pfeifer |
yap |
| # |
Dec 30th 2019, 16:39 |
dsar |
It's still weird, because it works for created field |
| # |
Dec 30th 2019, 16:38 |
ricksaccous |
i think it doesn't use standard date() format |
| # |
Dec 30th 2019, 16:38 |
ricksaccous |
haha yeah i always have to look formatting up |
| # |
Dec 30th 2019, 16:37 |
kevin.pfeifer |
i think my format is wrong^^ |
| # |
Dec 30th 2019, 16:36 |
kevin.pfeifer |
wait |
| # |
Dec 30th 2019, 16:36 |
kevin.pfeifer |
ohh |
| # |
Dec 30th 2019, 16:36 |
kevin.pfeifer |
thats it |
| # |
Dec 30th 2019, 16:36 |
kevin.pfeifer |
yop |
| # |
Dec 30th 2019, 16:35 |
kevin.pfeifer |
lets try that custom date formatter on my barebones cake |