Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-18536

Data too long for column 'nfp_page_only' error when saving a page with 768 characters when it must be added as a filter preference

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 13.2
    • Fix Version/s: None
    • Component/s: Notifications
    • Labels:
      None
    • Environment:
      Windows 10 Pro 64 bit, Edge 89, using a local instance XWiki 13.2 on HSQLDB 2.5.1, MySQL 8, MariaDB 10.5 and PostgreSQL 13, Tomcat
    • Difficulty:
      Unknown
    • Similar issues:

      Description

      STEPS TO REPRODUCE

      1. Click on Notification Bell
      2. Click 'Watch this wiki' toggle to OFF
      3. Go to Notifications Settings
      4. Set 'Automatic page watching' to other option than 'Never' (for ex: 'Every time I make a major modification')
      5. On Home, create a page with 760 characters in its name (e.g. ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt760) to cumulate in total 768 characters
      6. Save the page

      EXPECTED RESULTS
      The page is saved successfully without warnings/errors and is added as a filter preference.

      ACTUAL RESULTS

      The page is saved, but is not added as a filter preference.

      An error is encountered in console, along with some warnings. Here is the stacktrace from MySQL 8/ MariaDB 10.5:

      2021-04-05 12:41:25,675 [http-nio-8080-exec-2 - http://localhost:1115/bin/preview/ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768/WebHome] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1406, SQLState: 22001
      2021-04-05 12:41:25,675 [http-nio-8080-exec-2 - http://localhost:1115/bin/preview/ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768/WebHome] ERROR o.h.e.j.s.SqlExceptionHelper   - Data truncation: Data too long for column 'nfp_page_only' at row 1
      2021-04-05 12:41:25,679 [http-nio-8080-exec-2 - http://localhost:1115/bin/preview/ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768/WebHome] WARN  icationFilterPreferenceManager - Unable save the filter preferences [[hasParent = [false], filterPreference = [DefaultNotificationFilterPreference{id='null', internalId=0, owner='null', filterName='scopeNotificationFilter', providerHint='userProfile', enabled=true, active=false, filterType=INCLUSIVE, notificationFormats=[EMAIL, ALERT], startingDate=Mon Apr 05 12:41:25 GMT 2021, eventTypes=[], user='null', pageOnly='xwiki:ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768.WebHome', page='null', wiki='null'}], scopeReference = [Document xwiki:ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768.WebHome], children = []]] against the provider [userProfile]: [MysqlDataTruncation: Data truncation: Data too long for column 'nfp_page_only' at row 1]
       

      Tested on HSQLDB 2.5.1, MySQL 8, MariaDB 10.5 and PostgreSQL 13.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Date of First Response: