GemsTracker / gemstracker-library

GEneric Medical Survey Tracker, main library
http://gemstracker.org
BSD 3-Clause "New" or "Revised" License
6 stars 2 forks source link

Source synching gives an error on expired surveys in a newly attached source #750

Closed roelfaber closed 1 year ago

roelfaber commented 1 year ago

A new source was added with surveys of which some were expired. When this source was synchronized: • ERROR!!! • While calling:runTask(Tracker_CheckSurvey,2,413989,,1) • Mysqli statement execute error : Field 'gsu_survey_name' doesn't have a default value • Mysqli statement execute error : Field 'gsu_survey_name' doesn't have a default value

When removing expired date from survey with sid 413989 the sync completes without errors. After that, restoring the expired date gives no errors anymore. (this is the workaround).