Fixed
Details
Assignee
Greg ThomasGreg ThomasReporter
Greg ThomasGreg ThomasComponents
Fix versions
Affects versions
Priority
Major
Details
Details
Assignee
Greg Thomas
Greg ThomasReporter
Greg Thomas
Greg ThomasComponents
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
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;