Server Error in '/' Application.

---

Hi

Does this happen during the install or is it happening when you log into the Umbraco backend after the installation has finished?

/Jan

This happens when you go into the umbraco cms management pages, after a successful install, and click on (or initially land on) the "Content" root node.  There seems to be something jacked up with the starter kits... as this happens with (at least) the Business and Personal kits.

Hi Tom

Hmm, yeah this sounds like it could be a possible bug. It does not happen on a clean install?

/Jan

If by "clean install" you mean one not utilizing a starter kit... I do not think this happens with those installations.  A friend of mine, also new to using Umbraco, has not reported this behavior on a clean, new install that he did - and he did not use a starter kit.

It sounds to me like it might be coming from a Dashboard Control included in a starter kit that might have a problem with SQL CE.  As a workaround you could try removing that control from /config/dashboard.config.

Hi

This happens with the Business and Personal kits and not with Blog. It seems that an error has occured when creating table "Comment". Package.xml is different as follows and an error occurs in Personal kits with SQL CE. 

Personal

       <Sqlserver><![CDATA[       
      CREATE TABLE [Comment](
             [id] [int] IDENTITY(1,1) NOT NULL,
            [mainid] [int] NOT NULL,
              [nodeid] [int] NOT NULL,
              [name] [nvarchar](250) NULL,
              [email] [nvarchar](250) NULL,
             [website] [nvarchar](250) NULL,
           [comment] [ntext] NULL,
           [spam] [bit] NULL,
            [ham] [bit] NULL,
             [created] [datetime] NULL
          CONSTRAINT [PK_Comment] PRIMARY KEY CLUSTERED 
       (
             [id] ASC
          ));
       ]]></Sqlserver>
 

Blog

      <Sqlserver>
        <![CDATA[          
      CREATE TABLE [Comment](
             [id] [int] IDENTITY(1,1) NOT NULL CONSTRAINT [PK_Comment] PRIMARY KEY ,
           [mainid] [int] NOT NULL,
              [nodeid] [int] NOT NULL,
              [name] [nvarchar](250) NULL,
              [email] [nvarchar](250) NULL,
             [website] [nvarchar](250) NULL,
           [comment] [ntext] NULL,
           [spam] [bit] NULL,
            [ham] [bit] NULL,
             [created] [datetime] NULL
               );
          ]]></Sqlserver>

@awoni - Thanks for researching and finding that.  Hopefully those folks responsible for putting the starter kits together will see this and make the necessary adjustments.

I'm seeing this when I run the Business starter kit. Is there a work around for it?

Bob... [awoni] had posted earlier the differences in the XML files used to setup the various database tables... and showed the Blog versus Personal starter kit XML files.  While I have not tried this myself (yet), looking at the differences between the two files, and noting that the Blog starter kid DOES work, it might make sense to edit the package.xml file for the starter kit you want to use (Business in your case), and copy-n-paste the section shown in awoni's post over.  Worth trying anyway.

I opened a ticket about it http://umbraco.codeplex.com/workitem/30190

You can run Business and Personal starter Kit with SQL CE in the next step.

Make 'Comment' table with WebMatrix or VS2010. 

CREATE TABLE [Comment](
[id] [int] IDENTITY(1,1) NOT NULL CONSTRAINT [PK_Comment] PRIMARY KEY ,
[mainid] [int] NOT NULL,
[nodeid] [int] NOT NULL,
[name] [nvarchar](250) NULL,
[email] [nvarchar](250) NULL,
[website] [nvarchar](250) NULL,
[comment] [ntext] NULL,
[spam] [bit] NULL,
[ham] [bit] NULL,
[created] [datetime] NULL
);

Edit xsltExtensions.config File and add <ext> tags as follows.

<?xml version="1.0" encoding="utf-8" ?> 
<XsltExtensions>
  <!--
  This file is used to register 3rt party xslt extensions (methods you can execute from xslt, like umbraco.library:NiceUrl)
   <ext assembly="assemblyName" type="assemblyName.namespace.type" alias="custom">
  -->
  <ext assembly="umbraco.editorControls" type="umbraco.editorControls.tags.library" alias="tagsLib">
  </ext>
  <ext assembly="Runway.Blog" type="Runway.Blog.BlogLibrary" alias="BlogLibrary">
  </ext>
</XsltExtensions> 

Thanks awoni!  Your solution worked perfectly on my fresh SQLCE based install with the business starter kit.

Hi awoni,

About this issue, I find the Package.xml, but there are many same files. So Can you give the path of Package.xml. I slove the issue by adding a "Comment" table in Umbraco.sdf. Now it is work ok for my system.

Thank you.

is working on a reply...