Log message #4150902

# At Username Text
# Jun 13th 2018, 08:49 lorenzo please open a ticket about it
# Jun 13th 2018, 08:49 lorenzo that’s an interesting side effect
# 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?