Copied to clipboard

Flag this post as spam?

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


  • Richard Thompson 100 posts 336 karma points
    Feb 18, 2019 @ 13:00
    Richard Thompson
    0

    Problems importing RTE content

    Hi,

    I'm using CMS Import 3.7.7 to migrate some content from an Umbraco 6.2.6 site to an Umbraco 7.13.1 site.

    Some of the nodes are failing on the bodyText field (an RTE field). I've stripped back the content to just content that errors, here are some examples:

    <h3>When?</h3>
    <p>Every Tuesday (except 16, 23 Dec and 17 Feb).</p>
    
    <h2>Where?</h2>
    <p>Meet by the potting shed, London Road estate, N10 8LK</p>
    

    I can't see anything that would obviously cause a problem. When I leave the RTE empty these pages import without issue.

    The error I'm getting is

    Error :Conversion failed when converting from a character string to uniqueidentifier.
    

    This is caused by an SQL exception I guess when trying to save the property data.

    Any ideas on this or is there anything I can try?

    Thanks Richard

  • Richard Thompson 100 posts 336 karma points
    Feb 18, 2019 @ 16:02
    Richard Thompson
    0

    I've run the SQL profiler to capture some of the errors that I'm seeing during an import. I'm seeing errors around the following queries

    Select id, text,Path FROm umbracoNode where uniqueID = 'filename.jpg'
    Conversion failed when converting from a character string to uniqueidentifier.
    
    Select propertyEditorAlias from cmsDataType where propertyEditorAlias is null
    Invalid column name 'propertyEditorAlias'.
    
    Select alias from cmsContentType where masterContentType is null
    Invalid column name 'masterContentType'.
    

    That last query is invalid as the cmsContentType table doesn't have a masterContentType column.

  • Richard Soeteman 3827 posts 11858 karma points MVP
    Feb 19, 2019 @ 07:21
    Richard Soeteman
    100

    Hi Richard,

    This was a bug indeed and fixed in a hotfix to be included in 3.7.8 already.

    If you install both packages below the error should be gone.

    Cmismport package : https://www.dropbox.com/s/a2ooybno5qnspw1/cmsimport37_8.zip?dl=0 Umbraco data provider : https://www.dropbox.com/s/p0t0dkhfj2svey8/CMSImport.UmbracoDataProvider.zip?dl=0

    Best,

    Richard

  • Richard Thompson 100 posts 336 karma points
    Feb 19, 2019 @ 13:38
    Richard Thompson
    0

    Hi Richard,

    Thanks for the prompt response.

    I've given the new version a try and I've been able to import content that was previously erroring.

    Thanks

    Richard

  • Richard Thompson 100 posts 336 karma points
    Feb 19, 2019 @ 15:28
    Richard Thompson
    0

    I'm running the import of another document type at the moment and having checked the log file I'm seeing instances again of:

    Conversion failed when converting from a character string to uniqueidentifier.
    

    There is also the following information which hopefully may help:

    Error Number:8169,State:2,Class:16
    
  • Richard Soeteman 3827 posts 11858 karma points MVP
    Feb 19, 2019 @ 15:34
    Richard Soeteman
    0

    The last error doesn;r ring a bell, Sure you are still using the hotfix, no dll's on deploy? There is a tryparse now that checks first if the referenced item is a guid before starting to convert it.

  • Richard Thompson 100 posts 336 karma points
    Feb 19, 2019 @ 15:41
    Richard Thompson
    0

    You're absolutely right. I had originally installed the package via NuGet so when I restarted the site this afternoon it's used the old DLLs from NuGet.

    Thanks again.

Please Sign in or register to post replies

Write your reply to:

Draft