Confluence 2.2.9 does not work with MySQL version prior to 4.1

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Medium
    • None
    • Affects Version/s: 2.2.9
    • Component/s: None

      A space cannot be deleted. The problem is that Label.hbm.xml -> confluence.label_unused uses a sub select (aka sub query). Sub selects have been introduced in MySQL version 4.1.

      Fix: Rewrite the statement to use a LEFT JOIN:

      select distinct

      {l.*}

      from LABEL l LEFT JOIN CONTENT_LABEL lc ON l.LABELID = lc.LABELID where lc.LABELID IS NULL

      BTW: Regarding to http://confluence.atlassian.com/display/DOC/Confluence+Installation+Guide MySQL version 3.2 is supported.

              Assignee:
              Unassigned
              Reporter:
              Peter Romianowski
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: