Hi There,
I seem to be having this issue appearing randomly where date modified field is being set to the actual current time, however if I apply any changes to the record and save it, the field is set to '0000-00-00 00:00:00'. If I do apply some more changes, it may switch to the current date again, however I was unable to figure the root cause of this.
Please see attached screenshots.
Could you advise any resolution or workaround to this issue?
Thanks
Jan
date modified field is being set to '0000-00-00 00:00:00'
-
- Posts: 1
- Joined: 2016-03-04 09:37
date modified field is being set to '0000-00-00 00:00:00'
- Attachments
-
- content auto tool view.JPG (43.54 KiB) Viewed 3525 times
-
- appgini content auto view.JPG (48.7 KiB) Viewed 3525 times
Re: date modified field is being set to '0000-00-00 00:00:00'
I am also having several issues using date-time fields. (I am using ver 5.50)
including the '0000-00-00 00:00:00' you exposed. Most likely this "0" value is set when database does not accept the date-time format your scripts are trying to submit.
AppGini does NOT handle any datetime type fields with a nice user interface. If you don't need the javascript calendar and time utilities included in AppGini to be used in date and time fields, not the datetime type, then is ok to use them.
But if you need to use a nice user interface to grab date & time data you better go with separate type fields.
I tryed everything and I gave up on this date-time issue. The easiest workaround I took was to use separate fields, for date and time and if you must have a date-time fields in your table, you may do so and hide them from user windows and do some customized scripting to fill them using the hooks carpet modifying the "xtable.php" to include the expressions to create the values for date-time fields each time you update the database.
Hope this helps
including the '0000-00-00 00:00:00' you exposed. Most likely this "0" value is set when database does not accept the date-time format your scripts are trying to submit.
AppGini does NOT handle any datetime type fields with a nice user interface. If you don't need the javascript calendar and time utilities included in AppGini to be used in date and time fields, not the datetime type, then is ok to use them.
But if you need to use a nice user interface to grab date & time data you better go with separate type fields.
I tryed everything and I gave up on this date-time issue. The easiest workaround I took was to use separate fields, for date and time and if you must have a date-time fields in your table, you may do so and hide them from user windows and do some customized scripting to fill them using the hooks carpet modifying the "xtable.php" to include the expressions to create the values for date-time fields each time you update the database.
Hope this helps
-
- AppGini Super Hero
- Posts: 336
- Joined: 2015-12-23 16:52
Re: date modified field is being set to '0000-00-00 00:00:00'
I haven't observed the zero dates, but I routinely see this error in the console:
No idea if it's related or not.
However, it might be worth keeping the console open and watching for errors.
Code: Select all
datepicker.packed.js:38
GET http://smisco.org/scrapgini/hooks/resources/datepicker/js/lang/en.js
(anonymous function) @ datepicker.packed.js:38
(anonymous function) @ datepicker.packed.js:167
However, it might be worth keeping the console open and watching for errors.