Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-1257

SQLServer syntax error java.sql.SQLException: Incorrect syntax near the keyword 'COLUMN'.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.1.1
    • Component/s: Database
    • Labels:
      None

      Description

      2016.12.27 10:59:31 ERROR [Jetty-QTP-AdminConsole-45]: org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL: ALTER TABLE ofMucRoom ADD COLUMN allowpm INT NULL; 2016.12.27 10:59:31 ERROR [Jetty-QTP-AdminConsole-45]: org.jivesoftware.database.SchemaManager - Incorrect syntax near the keyword 'COLUMN'. java.sql.SQLException: Incorrect syntax near the keyword 'COLUMN'.

      https://msdn.microsoft.com/en-us/library/ms190238.aspx

        Attachments

          Activity

            People

            Assignee:
            akrherz Daryl Herzmann
            Reporter:
            akrherz Daryl Herzmann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: