Copied to clipboard

Flag this post as spam?

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


  • Ben Schlaepfer 74 posts 101 karma points
    Jun 20, 2013 @ 19:02
    Ben Schlaepfer
    0

    Invalid object name 'umbracoAppTree' when creating tables from script

    Hi there,

    UMBRACO 6.0.6 / CMS IMPORT 2.3.3 / WINDOWS AZURE

    Not sure if this is a Bug or a Feature...

    I've installed the free version of CMS Import and after some Googling have manually created the database tables and carried out my first successful import. YAY!  

    This has worked well but there was a SQL error in updating the umbracoAppTree (circa Line 80 onwards).

    INSERT [umbracoAppTree] ([treeSilent], [treeInitialize], [treeSortOrder], [appAlias], 
    [treeAlias], [treeTitle], [treeIconClosed], [treeIconOpen], [treeHandlerAssembly], 
    [treeHandlerType], [action]) VALUES (0, 1, 10, N'developer', N'CMSImportWizard', N'CMSImport', 
    N'folder.gif', N'folder_o.gif', N'CMSImportLibrary', N'ApplicationTree.CMSImportTree', N'')
    INSERT [umbracoAppTree] ([treeSilent], [treeInitialize], [treeSortOrder], [appAlias], 
    [treeAlias], [treeTitle], [treeIconClosed], [treeIconOpen], [treeHandlerAssembly], 
    [treeHandlerType], [action]) VALUES (0, 0, 11, N'developer', N'CMSImportWizardSaveImportTree', 
    N'Saved Imports', N'folder.gif', N'folder_o.gif', N'CMSImportLibrary', 
    N'ApplicationTree.SavedImportTree', N'')
    INSERT [umbracoAppTree] ([treeSilent], [treeInitialize], [treeSortOrder], [appAlias], 
    [treeAlias], [treeTitle], [treeIconClosed], [treeIconOpen], [treeHandlerAssembly], 
    [treeHandlerType], [action]) VALUES (0, 0, 15, N'developer', 
    N'CMSImportWizardScheduleImportTree', N'Scheduled Imports', N'folder.gif', N'folder_o.gif', 
    N'CMSImportLibrary', N'ApplicationTree.ScheduledTaskTree', N'')

    The error message shown is 

    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'umbracoAppTree'.


    I believe that the effect this has is that the nodes below the CMS Import icon in the developer section around scheduling etc. do not appear - so I am not sure if I can import child nodes or schedule imports?

     

    Maybe this is because I am on the free version? 

    Any advice or pointers gratefully received.

    Best wishes
    Ben

     

     

  • Richard Soeteman 4035 posts 12842 karma points MVP
    Jun 20, 2013 @ 19:34
    Richard Soeteman
    0

    Hi Ben,

    Sorry the sql script is old. Please ignore the AppTree sql from what I can see the tree got configured ok. Yes scheduling etc will not work in the Free mode. Also child import and save/updates is disabled in the free version.

    Thanks,

    Richard

     

  • Ben Schlaepfer 74 posts 101 karma points
    Jun 20, 2013 @ 19:37
    Ben Schlaepfer
    0

    Hi Richard,

    Many thanks for your speedy reply. I'll carry on with some testing today, and if successful, will purchase.

    Best wishes,

    Ben 

  • Richard Soeteman 4035 posts 12842 karma points MVP
    Jun 21, 2013 @ 08:40
    Richard Soeteman
    0

    Hi Ben,

    Great to hear. Hope the test passed, if not please let me know.

    Thanks,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft