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: