FOUR-12885: Added migration to convert status column from enum to varchar by runyan-co · Pull Request #5872 · ProcessMaker/processmaker
Issue
The status column in the users table is sometimes registered as an enum() when is should be a varchar. This PR converts that column to varchar if it finds it that way.
Reproduction Steps
- Log in with admin user
- Create a user
- Go to profile of new user
- Go to admin tab
- Search new user and edit
First scenario:
- Go to Settings
- Select Out of Office in Status list
- Click on Save button
- Reload page
Second scenario:
- Go to Settings
- Select Scheduled in Status list
- Click on Save button
- Reload page
Solution
- Add a database migration to convert the status column to varchar
How to Test
The reproduction steps should not reproduce the issue.
Related Tickets & Packages
Code Review Checklist
- I have pulled this code locally and tested it on my instance, along with any associated packages.
- This code adheres to ProcessMaker Coding Guidelines.
- This code includes a unit test or an E2E test that tests its functionality, or is covered by an existing test.
- This solution fixes the bug reported in the original ticket.
- This solution does not alter the expected output of a component in a way that would break existing Processes.
- This solution does not implement any breaking changes that would invalidate documentation or cause existing Processes to fail.
- This solution has been tested with enterprise packages that rely on its functionality and does not introduce bugs in those packages.
- This code does not duplicate functionality that already exists in the framework or in ProcessMaker.
- This ticket conforms to the PRD associated with this part of ProcessMaker.