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

SQL warnings when saving Mail Sending configuration

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 11.5
    • Fix Version/s: None
    • Component/s: Administration, Mail
    • Labels:
    • Environment:
      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)
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: