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

There is no length validation on note titles

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 4.3.0
        • Fix Version/s: 4.7.1
        • Component/s: Staff Interface
        • Labels:
          None

          Description

          When creating a note, it's possible to get a white screen / error when providing a title length that exceeds the field limit. Presumably this is varchar 255. An error is logged:

          general.ERROR: exception 'PDOException' with message 'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'title' at row 1' in /home/user/public_html/vendors/minphp/db/src/PdoConnection.php:196...

          We should be doing some validation and provide a proper error response if the field is too long.

            Activity

            Ascending order - Click to sort in descending order
            admin Paul Phillips created issue -
            admin Paul Phillips made changes -
            Field Original Value New Value
            Rank Ranked higher
            admin Paul Phillips made changes -
            Rank Ranked lower
            tyson Tyson Phillips (Inactive) made changes -
            Sprint 4.8.0 Sprint 1 [ 92 ]
            tyson Tyson Phillips (Inactive) made changes -
            Rank Ranked higher
            jonathan Jonathan Reissmueller made changes -
            Assignee Jonathan Reissmueller [ jonathan ]
            jonathan Jonathan Reissmueller made changes -
            Fix Version/s 4.7.1 [ 11126 ]
            Automated transition triggered when Jonathan Reissmueller created a branch in Stash -
            Status Open [ 1 ] In Progress [ 3 ]
            Automated transition triggered when Jonathan Reissmueller created pull request #735 in Stash -
            Status In Progress [ 3 ] In Review [ 5 ]
            Resolution Fixed [ 1 ]
            jonathan Jonathan Reissmueller made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 10 minutes [ 600 ]
            Worklog Id 12579 [ 12579 ]
            jonathan Jonathan Reissmueller made changes -
            Fix Version/s Short Term [ 10800 ]
            Original Estimate 0 minutes [ 0 ]
            Automated transition triggered when Tyson Phillips (Inactive) merged pull request #735 in Stash -
            Status In Review [ 5 ] Closed [ 6 ]

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  24/Sep/19

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 10 minutes
                  10m

                    Agile