if you want upgrade from 1.0 to 1.1 you may need to update your DB to migrate your previous data from Ntext to Int.
In such a case you may find this query useful:
(BE SURE TO MAKE A BACKUP FIRST, MESSING WITH THE DB CAN BE VERY HARMFUL!)
UPDATE cmsPropertyData SET dataInt = CAST(CAST(dataNtext AS NVARCHAR) AS INT), dataNtext = null WHERE propertytypeid IN ( SELECT id FROM cmsPropertyType INNER JOIN cmsDataType ON dataTypeId = nodeId WHERE controlId = '{EA369650-AA32-4035-9C0D-1C1698F91DA9}' ) AND dataNtext IS NOT NULL AND CAST(dataNtext AS VARCHAR) <>''
Upgrading from 1.0 to 1.1
Hi,
if you want upgrade from 1.0 to 1.1 you may need to update your DB to migrate your previous data from Ntext to Int.
In such a case you may find this query useful:
(BE SURE TO MAKE A BACKUP FIRST, MESSING WITH THE DB CAN BE VERY HARMFUL!)
Marco
is working on a reply...