| # |
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 |
| # |
Jun 12th 2018, 22:26 |
dereuromark |
bake itself is not the prob, any connection to db from CLI will be. you need to fix it |
| # |
Jun 12th 2018, 22:24 |
jaynoco |
@dereuromark I see. Might there be an alternative method the cake bake, if I’m having trouble installing these modules via the command line? (Metajake from IRC). |
| # |
Jun 12th 2018, 22:21 |
lorenzo |
@itmpls https://github.com/lorenzo/audit-stash/releases/tag/2.0.0 |