Server error occurs when editing projects or tasks
Symptoms
"Invalid length parameter passed to the LEFT or SUBSTRING function" server error occurs when editing a project or task.
Reason
Project phases that are required for project workflow were entered incorrectly.
The current project phase is determined for each project based on a numeric prefix in the project phase name. Therefore, you must add a prefix consisting of a number and a period before the phase name, for example:
01. Design
02. Code
03. Test
Important: Ensure that all numeric prefixes include the same number of digits as the highest phase number so that the project phases sort correctly.
Resolution
Delete the incorrect project phases or rename them according to the required format.