MS SQL Server upgrade script fails

Description

The DB upgrade script version 25 for MS SQL has incorrect syntax. From the forum report;

2019.02.28 13:59:09 org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL:
{{ DROP INDEX IF EXISTS ofMucConvLog_msg_id;}}
{{ 2019.02.28 13:59:09 org.jivesoftware.database.SchemaManager - Must specify the table name and index name for the DROP INDEX statement.}}

Apparently the correct syntax should be

DROP INDEX IF EXISTS ofMucConvLog_msg_id ON ofMucConversationLog;

Environment

None

Activity

Show:
Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created February 28, 2019 at 9:13 AM
Updated October 28, 2020 at 1:26 PM
Resolved April 12, 2019 at 5:58 PM