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

SQL warnings when updating Mentions colors from Administration in HSQLDB

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 12.5-rc-1
    • Fix Version/s: None
    • Component/s: Mentions
    • Labels:
      None
    • Environment:
      Windows 10 Pro 64 bit, IE11, using a local instance of XWiki 12.5 RC1 on Jetty/HSQLDB
    • Difficulty:
      Unknown
    • Similar issues:

      Description

      STEPS TO REPRODUCE

      1. Unzip a fresh instance of XWiki 12.5 RC1 (Jetty/HSQLDB)
      2. Start the instance
      3. Go to Administer Wiki > Other > Mentions
      4. Change the colors on MENTIONS COLOR and SELF MENTIONS COLOR (e.g. put #FF0000CC and #32CD3266)
      5. Click 'Save'

      EXPECTED RESULTS

      No warnings/errors are displayed.

      ACTUAL RESULTS

      In console, with each save there are displayed warnings like:

      2020-06-25 16:54:01,231 [qtp1422222071-24 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
      2020-06-25 16:54:01,231 [qtp1422222071-24 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
      2020-06-25 16:55:06,718 [qtp1422222071-89 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
      2020-06-25 16:55:06,718 [qtp1422222071-89 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
      2020-06-25 16:58:05,688 [qtp1422222071-16 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
      2020-06-25 16:58:05,688 [qtp1422222071-16 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
      2020-06-25 16:58:46,745 [qtp1422222071-195 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
      2020-06-25 16:58:46,745 [qtp1422222071-195 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
      2020-06-25 17:01:34,951 [qtp1422222071-200 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
      2020-06-25 17:01:34,951 [qtp1422222071-200 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
      2020-06-25 17:02:31,797 [qtp1422222071-17 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
      2020-06-25 17:02:31,798 [qtp1422222071-17 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
      2020-06-25 17:05:23,274 [qtp1422222071-90 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
      2020-06-25 17:05:23,275 [qtp1422222071-90 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
      2020-06-25 17:27:19,714 [qtp1422222071-200 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
      2020-06-25 17:27:19,715 [qtp1422222071-200 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data

      The issue was reproduced so far only on Jetty/HSQLDB.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tmortagne Thomas Mortagne
                Reporter:
                iandriuta Ilie Andriuta
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Date of First Response: