Issues
- MSSQLSERVER Upgrades 7 through 9 are brokenENT-284Resolved issue: ENT-284Aron Aron
- Openfire Enterprise Archive search breaks if you don't specify a date range endENT-271Resolved issue: ENT-271Gaston Dombiak
- Add MultiUserChat support to SparkwebENT-244Resolved issue: ENT-244David Smith
- Login dialog appears focused at load but actually isn'tENT-243Resolved issue: ENT-243David Smith
- Move buttons and search field around to match SparkENT-241Resolved issue: ENT-241David Smith
- Backport delayed message timestamp supportENT-240Resolved issue: ENT-240David Smith
- Cannot setup SparkWeb when anonymous login is disabled.ENT-237Resolved issue: ENT-237Gaston Dombiak
- Add clustering support to chat archivingENT-236Resolved issue: ENT-236Gaston Dombiak
- System properties should be updated across the clusterENT-235Resolved issue: ENT-235Gaston Dombiak
- Conversation transcript fails to export to PDFENT-234Resolved issue: ENT-234Gaston Dombiak
- Account creation on ignite causes spurious error messagesENT-233Resolved issue: ENT-233David Smith
- Scrollbar consistencyENT-232Resolved issue: ENT-232David Smith
- Inconsistent and non-cross-platform font choicesENT-231Resolved issue: ENT-231David Smith
- Improve the use of the page title for notifications, etc...ENT-230Resolved issue: ENT-230David Smith
- Use sparkweb for the favicon, not openfireENT-229Resolved issue: ENT-229David Smith
- Text on background tabs is almost unreadableENT-227Resolved issue: ENT-227David Smith
- Contact list search isn't applied to people newly signing onENT-226Resolved issue: ENT-226David Smith
- When searching, the group population numbers should reflect the filtered total not the originalENT-224Resolved issue: ENT-224David Smith
- Expand groups while searching, remember which to collapse when done searchingENT-223Resolved issue: ENT-223David Smith
- Replace 'view profile' menu item with spark-style tooltipsENT-222Resolved issue: ENT-222David Smith
- Reduce avatar size in contact list rowsENT-221Resolved issue: ENT-221David Smith
- Contact list group header stylingENT-220Resolved issue: ENT-220David Smith
- Search field placeholder text not restored when unfocused & emptyENT-219Resolved issue: ENT-219David Smith
- Alternating row style for contact listENT-218Resolved issue: ENT-218David Smith
- Contact list is too wide by defaultENT-217Resolved issue: ENT-217David Smith
- Add "powered by" to the bottom of the windowENT-216Resolved issue: ENT-216David Smith
- Gap between sparkweb icon and top of login window is too smallENT-215Resolved issue: ENT-215David Smith
- Change login window in sparkweb to ask for a JID instead of just usernameENT-210Resolved issue: ENT-210David Smith
- Add security protection to sparkwebENT-209Resolved issue: ENT-209David Smith
- Reduce size of sparkwebENT-208Resolved issue: ENT-208David Smith
- Sparkweb should be included in enterprise.jarENT-207Resolved issue: ENT-207Gaston Dombiak
- Fastpath should only be actually provided by the senior cluster memberENT-206Resolved issue: ENT-206Gaston Dombiak
- Table entConParticipant fails to be created in MySQL when using charset utf8ENT-205Resolved issue: ENT-205Gaston Dombiak
- Fix typo in statistic sever_sessionsENT-199Resolved issue: ENT-199Gaston Dombiak
- Cluster summary is sometimes failing to show node detailENT-198Resolved issue: ENT-198Gaston Dombiak
35 of 35
MSSQLSERVER Upgrades 7 through 9 are broken
Fixed
Description
Environment
All
Details
Assignee
Aron AronAron AronReporter
Aron AronAron AronFix versions
Affects versions
Priority
Major
Details
Details
Assignee
Aron Aron
Aron AronReporter
Aron Aron
Aron AronFix versions
Affects versions
Priority
MajorCreated November 21, 2007 at 8:07 AM
Updated November 21, 2007 at 8:27 AM
Resolved November 21, 2007 at 8:27 AM
Activity
Show:
Aron AronNovember 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.
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.