Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Marco Lusini 176 posts 1370 karma points
    Dec 07, 2009 @ 14:20
    Marco Lusini
    0

    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!)

    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) <>''
      

    Marco

Please Sign in or register to post replies

Write your reply to:

Draft