Site Settings to support versioning?


Started a new site using 1.x and we are trying to use Content Version Records, I did an Admin Settings using it, but upon trying to load it we'll get an exception.

Invalid column name 'ContentItemRecord_id'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'ContentItemRecord_id'.

Source Error:

Line 112: }
Line 113: else if (@event.LockMode == LockMode.None) {
Line 114: @event.Result = ProxyOrLoad(@event, entityPersister, keyToLoad, loadType);
Line 115: }
Line 116: else {

Source File: C:\Work\gitroot\PROJECT\src\Orchard\Data\Providers\AbstractDataServicesProvider.cs Line: 114

The reason is so everything has got a version and we can create an interface to and audit log of users updating settings etc.
Closed Sep 25, 2012 at 8:27 PM by sebastienros


BertrandLeRoy wrote Sep 24, 2012 at 5:01 PM

I'm sorry but "so everything has got a version" doesn't sound very compelling to me. Do you have an actual scenario for that? Logging changes should be possible using publication events, and doesn't require keeping the actual history of site settings.
This may be way to expensive to implement, for a small return on investment.

Sarkie wrote Sep 24, 2012 at 5:44 PM

Yeah we are probably just going to create an Audit Module for this very scenario, so we can store what has changed by certain users.

Didn't know how much work it would've been to fix it.

I'm just trying to be pro-active with any bug I find.

BertrandLeRoy wrote Sep 24, 2012 at 6:41 PM