# |
Jun 13th 2018, 08:49 |
josbeir |
morning all |
# |
Jun 13th 2018, 08:49 |
lorenzo |
the newer time class has support for microseconds |
# |
Jun 13th 2018, 08:48 |
lorenzo |
ah, yes |
# |
Jun 13th 2018, 08:46 |
rudy1976s |
@lorenzo it seems that setting SQLServer column type from "datetime" to "datetime2" fixed the problem: does the timestamp behavior changes the way it handles data in the last version of cake ? Datetime2 differs from Datetime in several ways , first of all ability to store bigger information in lesser space reading from Microsoft official docs and the date stored in DB is like the following : 2018-06-13 10:40:43.0000000 |
# |
Jun 13th 2018, 08:28 |
slackebot |
Action: admad put on "Another brick in the wall" |
# |
Jun 13th 2018, 08:28 |
admad |
i guess it's spelled "laddie" |
# |
Jun 13th 2018, 08:26 |
admad |
moin, get to work laddy :slightly_smiling_face: |
# |
Jun 13th 2018, 08:23 |
neon1024 |
Morning |
# |
Jun 13th 2018, 08:22 |
lorenzo |
so we can fix it |
# |
Jun 13th 2018, 08:22 |
lorenzo |
try to create a small reproducible example of your problem and open a ticket about it |
# |
Jun 13th 2018, 07:44 |
rudy1976s |
same of all |
# |
Jun 13th 2018, 07:44 |
rudy1976s |
same basecode |
# |
Jun 13th 2018, 07:44 |
rudy1976s |
this problem afflicts only SQLServer while the upgrade does not create issue on mysql server |
# |
Jun 13th 2018, 07:42 |
rudy1976s |
both in create and edit |
# |
Jun 13th 2018, 07:41 |
rudy1976s |
and if I put the timestamo behavior off from the table no error |
# |
Jun 13th 2018, 07:40 |
rudy1976s |
this happened only after update to 3.6.5 |
# |
Jun 13th 2018, 07:40 |
rudy1976s |
Hi lorenzo |
# |
Jun 13th 2018, 07:38 |
lorenzo |
or maybe you have a custom getter for the property in the entity |
# |
Jun 13th 2018, 07:38 |
lorenzo |
Likely because you are setting the field directly in the entity |
# |
Jun 13th 2018, 07:38 |
lorenzo |
You are saving a string as a date |
# |
Jun 13th 2018, 07:36 |
rudy1976s |
my sql server column tipe for created and modified is Datetime and all worked before update |
# |
Jun 13th 2018, 07:35 |
rudy1976s |
a conversion of a nvarchar data type into datetime has generated a value that is outside the range of allowed values |
# |
Jun 13th 2018, 07:35 |
rudy1976s |
the error in english is |
# |
Jun 13th 2018, 07:35 |
rudy1976s |
is there any important change to timestamp behavior ? |
# |
Jun 13th 2018, 07:34 |
rudy1976s |
Error: SQLSTATE[22007]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]La conversione di un tipo di dati nvarchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti. |
# |
Jun 13th 2018, 07:34 |
rudy1976s |
I have updated cake to last version and after that every table with TimeStamp behavior will cause on my SQLServer database the following error |
# |
Jun 13th 2018, 07:34 |
willem |
on my online server i get this error quite a lot when enabling debugging : `SQLSTATE[HY000]: General error: 11 database disk image is malformed` . Deleting the sqlite file fixes this error, but it will come back eventually. I could not find _why_ this is happening. Anybody? |
# |
Jun 13th 2018, 07:34 |
rudy1976s |
good mornign to all |
# |
Jun 13th 2018, 06:51 |
thomasnucleus |
Thanks for your help @admad |
# |
Jun 13th 2018, 06:51 |
thomasnucleus |
I cooked it, had the line commented... |
# |
Jun 13th 2018, 06:47 |
admad |
@thomasnucleus ^ |
# |
Jun 13th 2018, 06:45 |
admad |
"I've tried setting 'timestamp' => 'force', in app.php but no luck" that should be enough. Doing so would include the file's last modified timestamp in querystring for asset URLs. So when you update a file the timestamp would be updated and browser would download file again. |
# |
Jun 13th 2018, 06:25 |
thomasnucleus |
How can I ensure people that visit my site are downloading the latest js and css files from webroot? I'm getting a lot of errors in error.log for old js/css files I removed a while ago. I believe client's browser cache's are still trying to access these files? Not sure what to do. I've tried setting 'timestamp' => 'force', in app.php but no luck. Anyone know what's happening? |
# |
Jun 13th 2018, 02:08 |
genellern |
Nicely done, pretty ROR like |
# |
Jun 13th 2018, 02:08 |
genellern |
Never mind, I found out about Json and XML views |
# |
Jun 13th 2018, 02:05 |
genellern |
Hi guys, returning to Cakephp after awhile, when using a json ext page it's asking me for a json template, is it a new behavior in v3.6.5 ? |
# |
Jun 12th 2018, 22:30 |
jaynoco |
i see. heh |
# |
Jun 12th 2018, 22:27 |
dereuromark |
https://github.com/alt3/cakebox (something) |
# |
Jun 12th 2018, 22:27 |
jaynoco |
what is sth? |
# |
Jun 12th 2018, 22:26 |
jaynoco |
i’ll look into cakebox |
# |
Jun 12th 2018, 22:26 |
dereuromark |
most people use cakebox or sth which provides all out of the box |