• Registered: 2010-07-20
  • Posts: 2

Topic: Trouble with Custom fields being required and I can't change it.

I've searched around the forums and can't find anyone else having this issue.  All custom fields are required by default.

I go to Admin --> Custom Fields and create a new custom field.  Then before saving, I check enabled and save without "required" checked.  Even though I don't select "required", the custom field is still marked as "required".  Nothing I do can change this.  Even if I edit the custom field and uncheck the "required" selection, the box still remains checked (or rechecks) after I save.

I checked in the database and found that the table "Custom_Field" has a "1" in the "active_flag" column and "0" in the "required_flag" column.  Despite this being correct in the database, the application still treats the custom field as both required and active.

Platform: Mac OSX 10.4.11
PHP: 5.3.2
MySQL: 5.1.44-log
WebServer: Apache 2.0.63

PHP, MySQL, and Apache all installed through MAMP version 1.9

tracmor version: 0.3.0

Browser: Firefox 3.6.6

  • Registered: 2010-07-20
  • Posts: 2

Re: Trouble with Custom fields being required and I can't change it.

Well, I got it to work just after posting this topic.  However, I'm not sure if my fix is really the solution.

My fix... I changed the data type in MySQL for both "custom_field.active_flag" and "custom_field.required_flag" from "bit(1)" to "tinyint(1)".  Now everything works just fine with Custom Fields.

However, I did testing and found this issue in other areas of the software, everywhere a check box is used.  I'll use my fix where needed for now, just to get the most necessary check boxes working.

What do you think about this problem?

-Corey.