• We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Currently Confluence with MySQL 5.7 is affected by this: https://confluence.atlassian.com/display/CONFKB/%27Page+Not+Found%27+when+navigating+to+Confluence+Questions+due+to+com.mysema.query.QueryException

      Which is caused by this:

      Caused by: com.mysema.query.QueryException: Caught SQLException for delete from `CONTENTPROPERTIES`
      where `CONTENTPROPERTIES`.`PROPERTYID` in (select `PROPERTY_ID`
      from (select `answerProperties`.`PROPERTYID` as `PROPERTY_ID`
      from `CONTENT` `answers`
      join `CONTENTPROPERTIES` `answerProperties`
      on `answerProperties`.`CONTENTID` = `answers`.`CONTENTID`
      left join (select `questionProperties`.`LONGVAL` as `ANSWER_ID`
      from `CONTENT` `questions`
      join `CONTENTPROPERTIES` `questionProperties`
      on `questionProperties`.`CONTENTID` = `questions`.`CONTENTID`
      where `questions`.`PLUGINKEY` = 'com.atlassian.confluence.plugins.confluence-questions:question' and `questions`.`PREVVER` is null and `questionProperties`.`PROPERTYNAME` = 'accepted') as `ACCEPTED_ANSWER_IDS`
      on `answers`.`CONTENTID` = `ANSWER_ID`
      where `answers`.`PLUGINKEY` = 'com.atlassian.confluence.plugins.confluence-questions:answer' and `answers`.`PREVVER` is null and `answerProperties`.`PROPERTYNAME` = 'accepted' and `ANSWER_ID` is null) as `TMP`)
          at com.mysema.query.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:38)
          at com.mysema.query.sql.Configuration.translate(Configuration.java:451)
          at com.mysema.query.sql.dml.SQLDeleteClause.execute(SQLDeleteClause.java:169)
          at com.atlassian.confluence.plugins.questions.internal.upgrade.DuplicatedAcceptedAnswersRemover.deleteDuplicatedAcceptedAnswers(DuplicatedAcceptedAnswersRemover.java:83)
      ...
          at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:67)
          at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32)
          at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:91)
          ... 6 more
      Caused by: java.sql.SQLException: You can't specify target table 'CONTENTPROPERTIES' for update in FROM clause
      

      Different syntax in MySQL 5.7. This seems to only affect Confluence Questions add-on.

      UPDATE: The SQLException above was fixed in Questions for Confluence 1.0.618. If you install the latest version, it won't be a problem.

          Form Name

            [CONFSERVER-40385] Support MySQL 5.7

            Nobuyuki Mukai made changes -
            Remote Link Original: This issue links to "PC-3549 (Atlassian JIRA Extranet - Special Projects)" [ 301973 ] New: This issue links to "PC-3549 (Hello Jira)" [ 301973 ]
            Sen Geronimo made changes -
            Workflow Original: JAC Suggestion Workflow 4 [ 3575054 ] New: JAC Suggestion Workflow 3 [ 4338345 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow 2 [ 3183433 ] New: JAC Suggestion Workflow 4 [ 3575054 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3027256 ] New: JAC Suggestion Workflow 2 [ 3183433 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2526917 ] New: JAC Suggestion Workflow [ 3027256 ]
            Rachel Lin (Inactive) made changes -
            Workflow Original: Confluence Workflow - Public Facing v3 [ 2280806 ] New: Confluence Workflow - Public Facing v4 [ 2526917 ]
            Jenny (Inactive) made changes -
            Fix Version/s New: 6.3.1 [ 72600 ]
            Fix Version/s Original: 6.3.0 [ 72409 ]

            Thanks for the hint. Just upgraded to 6.3.1 - all errors gone

            werner mueller added a comment - Thanks for the hint. Just upgraded to 6.3.1 - all errors gone
            Jenny (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Awaiting Release [ 11372 ] New: Resolved [ 5 ]

            A fix for this issue is now available for Confluence Server customers.
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            Jenny (Inactive) added a comment - A fix for this issue is now available for Confluence Server customers. Upgrade now or check out the Release Notes to see what other issues are resolved.

              abarnes@atlassian.com Adam Barnes (Inactive)
              fsim Foo Sim (Inactive)
              Votes:
              76 Vote for this issue
              Watchers:
              67 Start watching this issue

                Created:
                Updated:
                Resolved: