umbraco 刪除版本紀錄

DECLARE @createdDate Datetime = '2012-03-01'

DELETE FROM cmsPropertyData WHERE
    versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND
    contentNodeId IN (SELECT DISTINCT nodeID FROM cmsDocument)
DELETE FROM cmsPreviewXml WHERE
    versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND
    nodeId IN (SELECT DISTINCT nodeID FROM cmsDocument)
DELETE FROM cmsContentVersion WHERE
    versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND
    ContentId  IN (SELECT DISTINCT nodeID FROM cmsDocument)
DELETE FROM cmsDocument WHERE
    versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND
    nodeId IN (SELECT DISTINCT nodeID FROM cmsDocument)

umbraco 設定檔案上傳大小

web.config 設定

<system.web>
    <httpRuntime maxRequestLength="204800" executionTimeout="99999" />
</system.web>
<system.webServer>
    <security>
        <requestFiltering>
            <requestLimits maxAllowedContentLength="204800000"/>
        </requestFiltering>
    </security>
</system.webServer>

umbraco 資料匯入 關閉cache

config/umbracoSettings.config
然後在<content>裡面加上：
<!-- Enable / disable xml content cache -->
   <XmlCacheEnabled>False</XmlCacheEnabled>
   <!-- Update disk cache every time content has changed -->
   <ContinouslyUpdateXmlDiskCache>False</ContinouslyUpdateXmlDiskCache>