Uploaded image for project: '{RETIRED} XWiki Enterprise'
  1. {RETIRED} XWiki Enterprise
  2. XE-1332

Debian installer MySQL connection string wrong, causing UTF-8 save problem

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.1
    • Fix Version/s: 5.3-milestone-1, 5.2.1
    • Component/s: Debian packages
    • Labels:
      None
    • Environment:
      Ubuntu Server 12.04 LTS, Java 1.6.0_27, MySQL 5.5.
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      I've used the Debian xwiki-mysql installer to install XWiki 5.1.

      When saving non-latin characters, in either wiki/wysiwyg editor, such as – Ĉ --, the character gets saved to mysql as a "?"(question mark).

      After install, in file:

      /etc/xwiki/hibernate.cfg.xml

      The connection url has double escape of ampersands &amp

      <property name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&amp;amp;useUnicode=true&amp;amp;characterEncoding=UTF-8</property>
      

      Removing the double "amp;" fixes this issue.

      <property name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&amp;useUnicode=true&amp;characterEncoding=UTF-8</property>
      

        Attachments

          Activity

            People

            • Assignee:
              tmortagne Thomas Mortagne
              Reporter:
              andrewmcveigh Andrew Mcveigh
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: