Global Statistics Plugin - incorrect SQL statement

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 2.2.10
    • Affects Version/s: 2.3
    • Component/s: None

      2006-09-13 11:37:40,692 ERROR [confluence.extra.globalstats.GlobalStatisticsManager] doSqlCountQuery Unable to perform query [select count(c.*) from CONTENT as c where c.SPACEID = 15 and c.PREVVER is null and c.CONTENTTYPE = 'BLOGPOST']: java.sql.SQLException: Line 1: Incorrect syntax near '*'.
      java.sql.SQLException: Line 1: Incorrect syntax near '*'.

      Some databases do not recognise the 'AS' keyword in that statement, hence returning 0 in the column when statistics ran . Needs to be fixed to '...from CONTENT c where...'

              Assignee:
              Unassigned
              Reporter:
              Ivan Benko [Atlassian]
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: