Fixing "Unknown column CREATED_ON_DATE"

Error:

Unknown column 'CREATED_ON_DATE' in 'catissue_specimen'

Resolution:

The above mentioned error occurs when the specimens table CATISSUE_SPECIMEN has the required column with the right name - CREATED_ON

The solution is to rename this column back to CREATED_ON_DATE that the schema script is anticipating.

alter table catissue_specimen change created_on created_on_date timestamp null;

On successfully renaming the column, restart OpenSpecimen.