Weird survey submission bug

cis498-g4 / GuestBook

Guest book and feedback system for events

1 stars 1 forks source link

Weird survey submission bug #8

Closed mikemolenda closed 7 years ago

mikemolenda commented 7 years ago

Occasionally submitting a survey will return SQL error code 1292 (incorrect date value). Affected: ShowSurveyForm.java, survey.jsp, list-surveys-guest.jsp

mikemolenda commented 7 years ago

Perhaps a MySQL server setting? (http://bit.ly/2op9lq0)

mikemolenda commented 7 years ago

Something fucked up with the LocalDateTime value that is getting passed. This one came from an error condition: 2017-04-24 16:00:65. May be a DateTimeFormatter issue on the write operation.

mikemolenda commented 7 years ago

Fixed: Appears to have been an issue where DateTimeFormatter fraction of seconds ("SS") was being passed instead of seconds ("ss") in SurveyDataAccess.insertSurvey()