Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-4658

Support Manager: Fatal error on department add/edit with empty port

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.5.0-b1
    • Component/s: None
    • Labels:
      None

      Description

      To reproduce:

      1. Add department
      2. Enter details
      3. Update the "Email Handling" field to IMAP
      4. Enter a number in the "Port" field (ex. 110)
      5. Update "Email Handling" to None
      6. Check "Automatically transition ticket status on admin reply"
      7. Save the department
      8. Receive fatal error

        General error: 1366 Incorrect integer value: '' for column 'port' at row 1.

      This also happens when trying to edit a support department imported from WHMCS that didn't have email configured.

        Activity

        jonathan Jonathan Reissmueller created issue -
        jonathan Jonathan Reissmueller made changes -
        Field Original Value New Value
        Rank Ranked higher
        jonathan Jonathan Reissmueller made changes -
        Sprint 5.5.0 Sprint 4 [ 157 ]
        jonathan Jonathan Reissmueller made changes -
        Rank Ranked higher
        jonathan Jonathan Reissmueller made changes -
        Rank Ranked lower
        jonathan Jonathan Reissmueller made changes -
        Sprint 5.5.0 Sprint 4 [ 157 ] 5.5.0 Sprint 4, 5.5.0 Sprint 5 [ 157, 159 ]
        jonathan Jonathan Reissmueller made changes -
        Rank Ranked higher
        jonathan Jonathan Reissmueller made changes -
        Assignee Jonathan Reissmueller [ jonathan ]
        jonathan Jonathan Reissmueller made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        jonathan Jonathan Reissmueller made changes -
        Status In Progress [ 3 ] In Review [ 5 ]
        Resolution Fixed [ 1 ]
        jonathan Jonathan Reissmueller made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 1 hour, 3 minutes [ 3780 ]
        Worklog Id 15757 [ 15757 ]
        abdy Abdy Franco made changes -
        Time Spent 1 hour, 3 minutes [ 3780 ] 1 hour, 49 minutes [ 6540 ]
        Worklog Id 15763 [ 15763 ]
        jonathan Jonathan Reissmueller made changes -
        Status In Review [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            jonathan Jonathan Reissmueller
            Reporter:
            jonathan Jonathan Reissmueller
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              29/Jun/22

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 1 hour, 49 minutes
              1h 49m

                Agile