2 ms·
SQL error when saving a record, 0000-00-00 in end date (there was no end date in the document)
by draugadrotten 6y ago
SQL error when saving a record, 0000-00-00 in end date (there was no end date in the document)
- justinclift 6y agoYeah, same here. Can't really help them until they've worked out the problems with data input. :(
- fuzzfactor 6y agoThe drop-down mouse-select calendars themselves are nonideal. They require that you select full Y,M,D in that order even though random choice is implied and possible. If you try to enter DEC 31 1999 you get 2020-12-31 [0] before there is a chance to select the 1999. If you notice that situation, then try to correct only the year, there is complete failure to update the data entry field, correctly or otherwise. Not every century can have the most advanced UI/UX. . [0] this date is illogical because it is in the future and in the future it will not be possible to party like it's 1999. Any date subsequent to the date of the database snapshot should not be admitted into the field.
- thenickdude 6y agoIf you're using MySQL you can permit the insertion of zero dates by removing the NO_ZERO_DATE flag from the SQL mode: https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmode_no_zero_date https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmod...