Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MSSQLSERVER Upgrades 7 through 9 are broken

Description

There are bugs in the MSSQLServer upgrade scripts for the openfire enterprise plugin, for versions 3.4.1 and earlier. When upgrading up to version 3.4.1, open enterprise upgrade schemas 7, 8, and 9 have various issues which need to be fixed.

Upgrade 7:
updates to propValue in fpWorkGroupProp and fpAgentProp were breaking when using the REPLACE function since propValue is of an invalid type for the first argument of REPLACE (it cannot take manipulate 'text' type columns).

Upgrade 8:
adding columns to entSipUser did not have the correct syntax: the word 'column' is rejected by sqlserver

Upgrade 9:
when creating table entRRDs, the 'bytes' column should be of type 'image', not 'text'. This error was breaking the application when it tries to populate the round-robin statistics database.

Environment

All

Activity

Show:

Aron Aron November 21, 2007 at 8:27 AM

Fixed:

  • Replaced 'text' with 'image' datatype for table entRRDs.bytes (upgrade 9)

  • Removed 'COLUMN' keyword from alter table statement (upgrade 7), which is rejected by sqlserver

  • Used t-sql stored procedure to get around REPLACE functional limitation on not being able to manipulate columns of type 'text'.

Can successfully upgrade a user from wildfire 323 to trunk with these modifications.

Fixed

Details

Assignee

Reporter

Fix versions

Affects versions

Priority

Created November 21, 2007 at 8:07 AM
Updated November 21, 2007 at 8:27 AM
Resolved November 21, 2007 at 8:27 AM