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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.3-milestone-1, 5.2.1
    • 5.1
    • Debian packages
    • None
    • Ubuntu Server 12.04 LTS, Java 1.6.0_27, MySQL 5.5.
    • N/A
    • N/A

    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

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

            Dates

              Created:
              Updated:
              Resolved: