Hi. From the trace I can see that CAS exceptions are caused by the lack of permission to access Sql Server CE stuff. I have never dealt with CE actually and am not aware how it works in a partial-trusted house, but probably you have opportunity to deploy your installation there on the usual SQL Server, don't you?

Hi Rodion, thanks for the reply.

Strange thing is that I'm not actually using SQL CE, but am using a SQL Server 2005 database which I've transferred over to the hosting company. This database must be working as I can see the pages ok,  but none of the XSLT code will run.  I also get the same error if I try and create a new XSLT script.

I think my database might be broke somehow :(

I've just tried to create a document type and got the message below :-

Is there any way I can check the database out ?

Server Error in '/' Application.

Cannot insert the value NULL into column 'id', table 'osbit_umbraco.dbo.umbracoNode'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'id', table 'osbit_umbraco.dbo.umbracoNode'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Source Error:

Stack Trace:

[SqlException (0x80131904): Cannot insert the value NULL into column 'id', table 'osbit_umbraco.dbo.umbracoNode'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2062078
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050204
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +56
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +83
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) +21
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +85

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +140
   umbraco.cms.businesslogic.CMSNode.MakeNew(Int32 parentId, Guid objectType, Int32 userId, Int32 level, String text, Guid uniqueID) +669
   umbraco.cms.businesslogic.web.DocumentType.MakeNew(User u, String Text) +135
   umbraco.nodetypeTasks.Save() +57
   umbraco.presentation.create.dialogHandler_temp.Create(String NodeType, Int32 TypeId, Int32 NodeId, String Text) +385
   umbraco.cms.presentation.create.controls.nodeType.sbmt_Click(Object sender, EventArgs e) +213
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

Hi Rodion,

You are quite correct as I eventually figured out last night after many hours :(

Thanks very much for you're help on this, appreciated !

Just in case someone else this problem, here's what I did wrong . . .

When I transferred the database from my dev environment to the live environment I use the SQL Server Export/Import tool.

This tool only transfers the data and creates the 'basic' tables, but does not create primary/foriegn keys and identity fields, etc so my data was a bit of a mess :(

I had to use the 'Generate Scripts' tool (right click on database in SSMS and it's under the 'tasks' menu) to create the tables correctly, without the foriegn keys.

I then used the tool again to transfer just the data (Without blowing any foriegn key contraints as they haven't been created).

Then I ran the tool a third time to create the missing foriegn keys.

BTW - I also used SQL Data Compare (Redgate tool) to make sure the databases were in sync).

Hope it helps !

I used the msdeploy.exe tool several times - it takes some time to learn but it proved to copy the database without problems. However, I think that the ultimate solution would be to use the Courier though it's a paid product.

Hi Rodion,

Thanks for the tip, I'll give that a go as well !

Things are 'better' now in that I can create document and media types without a major crash, but XSLT's still do not run on the site and I still can't create them as before :(

The database is definately fully syncronised so I know that's not the issue now.

Has anyone got this working on MediumTrust anywhere ? (As that's what the hosting company say is wrong).

Thanks

Kevin

Hi. I know there're some articles on Wiki regarding running umbraco with medium trust like this: http://our.umbraco.org/wiki/install-and-setup/medium-trust-with-umbraco-45plus. However I haven't had such experience, bur probably wiki will be of help. What exception do you get? (If you cannot see it in the page then try to find it in the log table in the database).

Hi Rodion,

Sorry for the delay in getting back to you.

I've actually stopped trying to get XSLT working now as I haven't got time to try and work out what's wrong, I'm just not that experianced with Umbraco yet :(

I have instead now re-written the navigation in Razor and am currently doing the same with the gallery.

Strangely I was still seeing the SQLCE error with the XSLT macro in my template, even if it was commented out !

Once I removed it completly, it went away - odd.

I am still getting an error with my Razor script,  but that's just down to the fact my coding skills a crap with Razor at the moment ;)

I'll have a look at the XSLT issue again as soon as I get this update out though.

Thanks again for the help !

Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

Hi. I suspect that the reason of this security exception can be that the System.Data.SqlServerCe assembly requires CAS permissions to call unmanaged code (that's not granted in medium trust). If you don't use SQL CE at all then you could try to remove this assembly from the ~/bin folder - perhaps it would help.

Hi Rodion,

Sorry for the delay in getting back to you on this, busy week :(

I've now got the site working by removing everything from the hosting compant (except the database) and pubilshing a fresh 4.7.1.1 install.

I then published my scipts, etc to this new install and now have everything working as excepted.

Looks like I've done something stupid when I upgraded from 4.6 to 4.7.1.1 and copied something over that I shouldn't have done :(

Thanks again for the help.

Kev

is working on a reply...