Okay, so for some reason, that field wasn't marked as a system field in the database. That's bad.
Don't worry about the "2" - the Time field type is just getting confused - that's fine.
So don't do any more editing of the fields within the interface - this is a problem with the field, and updating it further through the UI will only make it worse.
You need to do two things:
1. Do as described in my last post: go into the DB and change the field_type_id for that form field to "9" so it's marked as a Date (just FYI, the Dates field type include datetimes, so once this is all repaired, you can just tell it to output the result in whatever format you want).
2. Also change the field so the "is_system_field" is set to "yes". That will prevent it's field type from being further editable - which is how it SHOULD be.
Also, you'll need to do the same change for the Last Modified field. That's a core field as well and needs the same change.
I looked over the upgrade code and can't see any problems, but obviously I'm missing something.
Q: do you have the database backed up? If so, any chance you could send it to me so I could upgrade it myself to see where things went wrong?
- Ben
Don't worry about the "2" - the Time field type is just getting confused - that's fine.
So don't do any more editing of the fields within the interface - this is a problem with the field, and updating it further through the UI will only make it worse.
You need to do two things:
1. Do as described in my last post: go into the DB and change the field_type_id for that form field to "9" so it's marked as a Date (just FYI, the Dates field type include datetimes, so once this is all repaired, you can just tell it to output the result in whatever format you want).
2. Also change the field so the "is_system_field" is set to "yes". That will prevent it's field type from being further editable - which is how it SHOULD be.
Also, you'll need to do the same change for the Last Modified field. That's a core field as well and needs the same change.
I looked over the upgrade code and can't see any problems, but obviously I'm missing something.
Q: do you have the database backed up? If so, any chance you could send it to me so I could upgrade it myself to see where things went wrong?
- Ben