Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-125328

No character limit for phone number in Account Address creation

    Details

      Description

      Steps to reproduce:

      1. Add a business account
      2. Go to addresses tab
      3. Add an address
      4. In the phone number field, enter number more than 75 characters
      5. Save

      Expected results: There is a character limit. No character can be added after the 75th character

      Actual results:

      • Character can be added after the 75th
      • Changes are not saved, no error message, and user is navigated to Accounts list
      2020-12-23 23:02:46.153 ERROR [http-nio-8080-exec-9][JDBCExceptionReporter:234] Data truncation: Data too long for column 'number_' at row 1
      
      2020-12-23 23:02:46.236 ERROR [http-nio-8080-exec-9][PortletServlet:119] javax.portlet.PortletException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into Phone (mvccVersion, uuid_, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, number_, extension, typeId, primary_, phoneId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: Could not execute JDBC batch update
      

      Reproduced on:
      Tomcat 9.0.33 + MySQL 5.7
      Portal master GIT ID: b265d851edce5207d5da8198f1f01d96554e8499

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sharry.shi Sharry Shi
              Reporter:
              patricia.perez Patricia Perez
              Participants of an Issue:
              Recent user:
              Rafaela Nascimento
              Engineering Assignee:
              Bruno Queiroz
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                16 weeks, 1 day ago

                  Packages

                  Version Package
                  7.4.1 CE GA2 DXP 7,4
                  Master