date modified field is being set to '0000-00-00 00:00:00'

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
Jan Plotnickij
Posts: 1
Joined: 2016-03-04 09:37

date modified field is being set to '0000-00-00 00:00:00'

Post by Jan Plotnickij » 2016-03-04 09:43

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
Attachments
content auto tool view.JPG
content auto tool view.JPG (43.54 KiB) Viewed 3516 times
appgini content auto view.JPG
appgini content auto view.JPG (48.7 KiB) Viewed 3516 times

User avatar
pilandros
Veteran Member
Posts: 93
Joined: 2014-02-13 18:19

Re: date modified field is being set to '0000-00-00 00:00:00'

Post by pilandros » 2016-07-23 18:32

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

grimblefritz
AppGini Super Hero
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'

Post by grimblefritz » 2016-07-24 12:05

I haven't observed the zero dates, but I routinely see this error in the console:

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
No idea if it's related or not.

However, it might be worth keeping the console open and watching for errors.

Post Reply