Sign in Register
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!

    Copy Link
  • 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

    Copy Link
  • 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!

    Copy Link
  • 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

    Copy Link
  • 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!

    Copy Link
  • 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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft