Yet another bug. After creating TVs (which contain @SELECT) and adding them to documents I make sure they are working. After clicking property set on any one of them and closing the window with Cancel TVs become uneditable. It looks like this: after editing saving is successful, but the web page looks like the thing never got saved in the database. Oh, and btw, i got error.log full of these things:
(ERROR @ /Revo/manager/index.php) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 156
[2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword ’constraint’.
)
The only way I can overcome this is deleting all TVs and recreating them which is ...
My configuration is: MODX Revo 2.1rc4 Traditional, OS is Win Server 2008 R2, IIS 7.5, on SQL Server database 2008 express, PHP is 5.3.6. I know this is RC, but I basically doesn’t work with SQL server. Hopefully someone reads this.
Edit: I broke it again. Tried to add property via [[*TVname?property=`value`]].
Here is error.log:
(ERROR @ /Revo/connectors/element/tv.php) modTemplateVarTemplate: Attempt to set NOT NULL field rank to NULL
