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

SQL warnings when saving Mail Sending configuration

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Minor
    • None
    • 11.5
    • Administration, Mail
    • Windows 10 Pro 64 bit, IE11, using a local instance of XWiki 11.5, on MySQL 5.7 and HSQL 2.5.0 (tested on JAVA 8 and JAVA 11)
    • Unknown
    • N/A
    • N/A

    Description

      STEPS TO REPRODUCE

      1. Login as Admin
      2. Go to Administer Wiki > Mail > Mail Sending
      3. Fill in the information on fields (e.g. in 'Email address to send from', 'Email Server', 'Email Server Port', 'Email Sever Username', 'Email Server Password', 'Additional Properties')
      4. Click 'Save'

      EXPECTED RESULTS

      The configuration is saved without any warnings/errors.

      ACTUAL RESULTS

      When saving the page, there are some warnings encountered in console:

      2019-07-02 15:43:58,398 [http://localhost:1150/xwiki/bin/admin/XWiki/XWikiPreferences?editor=globaladmin&section=emailSend] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2019-07-02 15:43:58,399 [http://localhost:1150/xwiki/bin/admin/XWiki/XWikiPreferences?editor=globaladmin&section=emailSend] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
2019-07-02 15:44:18,229 [http://localhost:1150/xwiki/bin/saveandcontinue/Mail/MailConfig] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2019-07-02 15:44:18,230 [http://localhost:1150/xwiki/bin/saveandcontinue/Mail/MailConfig] WARN  o.h.e.j.s.SqlExceptionHelper   - no data

      However, the information seems to be saved when returning to page and sharing a page by mail works (tested on JAVA 8 and JAVA 11).

      The issue could not be reproduced on XWiki 11.4.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-17465 Superfluous SQL warnings in the xwiki logs

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-17618 SQL Warning in the logs when saving XWiki.Notifications.Code.NotificationAdministration document in HSQLDB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              vmassol Vincent Massol
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: