Copied to clipboard

Flag this post as spam?

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


  • singer777 69 posts 80 karma points
    Dec 15, 2011 @ 19:36
    singer777
    0

    Invalid object name 'CMSImportRelation'. error when importing

    On my first .csv import for the Pro version I got the following error on all records:

    Invalid object name 'CMSImportRelation'.

    I looked at formatting of my csv fields and they look OK.

    For the record, very similar files went successfully into the trial version of CMS Import.

    Thanks in advance for your help!

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Dec 15, 2011 @ 19:40
    Richard Soeteman
    0

    The CmsImportRelation is a database table. Could you check if the cmsimportrelation table is available in the database and can be accessed by the database user?

    Thanks,

    Richard

  • singer777 69 posts 80 karma points
    Dec 15, 2011 @ 20:37
    singer777
    0

    I checked in the main database (the one I create while installing Umbraco) and there is no table with that name. For your second question, I believe all read/write permissions are granted, if that's what you are asking.

    Thanks!

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Dec 15, 2011 @ 20:52
    Richard Soeteman
    0

    Hi Jonathan,

    Ok so the installer failed to install the database tables. You can solve this by installing the sql manually. Run the script as shown in section 10.2 of the documentation then it should work. Please let me know if you need more info.

    Thanks,

    Richard

  • singer777 69 posts 80 karma points
    Dec 15, 2011 @ 23:28
    singer777
    0

    Thanks. Can you e-mail that script code to me? Copying it out of the PDF is tough. Thanks!

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Dec 16, 2011 @ 10:19
    Richard Soeteman
    0

    Sure, Just send you the sql.

    Cheers,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft