Bug #23577 Bug Fixed

SQL error after changing existing member custom field to “date” type

Version: 4.2.0 Reporter: Derek Jones

If you create a custom member field as one type, say “text”, but then later change it to “date”, the table schema is not updated to accommodate the date field, leading to a SQL error:

>>> Unknown column ‘Member_field_id_#.m_field_dt_#’ in ‘field list’

To resolve this, add an m_field_dt_# column to the table, varchar(50) default null

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases