search

formtools / module-form_builder

The Form Builder module.
https://docs.formtools.org/modules/form_builder/
15 stars 21 forks source link

Incorrect datetime value: '' for column 'offline_date' #20

Closed lucentminds closed 6 years ago

lucentminds commented 6 years ago
  1. Setup fresh install of Form Tools 3.0.1.
  2. Created my first form and published it.
  3. The form page loaded once. Everything looked ok.
  4. After refreshing the page the form stated that it was offline.
  5. Reloaded form builder and sure enough, the Form is online checkbox is unchecked.
  6. Placed a check in Form is online checkbox.
  7. Clicked SAVE button.
  8. Nothing happened. Form is still offline.
  9. Clicked SAVE button again, but this time with Chrome dev tools open.
  10. Got error message back from /modules/form_builder/code/actions.php That is not shown on the webpage.
  11. Discovered you cannot leave Automatically take form offline on: blank.
[false,"SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '' for column 'offline_date' at row 1"]

Are we not supposed to leave the date blank? I don't want the form to expire ever.