Single Select Color Configuration Not Persisting in MySQL Integration

Issue Description

When configuring colors for MySQL ENUM fields in single select components, the system:

  1. Initially shows all possible ENUM options during configuration
  2. Fails to save color configurations consistently
  3. Sometimes loses options beyond those currently in use
  4. Assigns random colors to new instances instead of using configured colors

Environment

  • Database: MySQL
  • Field Type: ENUM (used for status and state fields)
  • Application: Production Management System for order/task tracking

Impact

Unable to maintain consistent color-coding for status and state fields, making visual tracking difficult and configuration time-consuming.