#273 SqlStore TopicLocking Issues

[John Davidson]

FlexWiki 2.0 shipped without support for TopicLocking. The check for IsTopicReadOnly was supposed to return false in all cases for topics in SqlStores, but had a bug in the implementation.

This bug prevents the LeftBorder from displaying when logged in to FlexWiki as a user with HasManageNamespacePermission.

[John Davidson]

Logged In: YES
user_id=1602893
Originator: YES

Build 2.0.0.196 includes revised code that fixes the issue in all regards. IstopicreadOnly now works correctly in the SqlStore and the TopicLock/Unlock capability has been implemented for the SqlStore.

The SqlStore requires 2 new Stored Procedures (WriteTopicLock and WriteTopicUnlock) which have been included in the appropriate script to build a complete SqlStore with these procedures. Additionally an update script has been included in the tools distribution under the directory UpdateScript in both the GUI and the Console application to add these stored procedures to an existing SqlStore. The revised main script should be bound into the SqlStoreManagerLib.dll, but an issue with versioning of this assembly is preventing it from being rebuilt with the new script detail included. (A separate bug will be raised for this issue).

A site wishing to create a new SqlStore needs to run the current GUI or Console app to create the store and then apply the sql script to update the database to include the 2 new stored procedures.

[John Davidson]

Logged In: YES
user_id=1602893
Originator: YES

Build 2.0.0.199 now has a correctly built version of the tools. New builds of the SqlStore should now include the new Stored Procedures for WriteTopicLock and WriteTopicUnlock. Existing sql implementations should run the separate update script _ONLY_.