I've uploaded my first project to a hosting company (PipeTen) and have found that I'm not able ti either create or execute XSLT functions on the site.
When I initially uploaded the site it was at version 4.6 and found that I needed to upgrade to 4.7.1.1 so that I could get it to work in a mudium trust environment.
Since doing this most of the site is working, but none of the XSLT's will run and I get the debug output below which complains about SQLServer CE (Which I'm not using as far as I know).
I've spoken to the hosting company and they are sating that this is because Umbraco wants to run in full trust mode, but if that's the case I don't see how they can have anybody running as they also tell me that a full trust solution won't be available for a couple of weeks yet.
I'm really lost at this point so any input would be greatly appreciated.
Many Thanks in advance
Kevin
Request Details
Session Id:
id1qvb3abrlewpdogzgkuq5k
Request Type:
GET
Time of Request:
01/02/2012 11:27:34
Status Code:
200
Request Encoding:
Unicode (UTF-8)
Response Encoding:
Unicode (UTF-8)
Trace Information
Category
Message
From First(s)
From Last(s)
aspx.page
Begin PreInit
umbracoInit
handling request
2.2784E-05
0.000023
request handler
current url '/virtual-tour/classroom-1.aspx'
0.000116288
0.000094
umbracoRequestHandler
Just before xPath query (True, '1345')
0.000152848
0.000037
umbracoRequestHandler
After xPath query
0.000175056
0.000022
umbracoRequestHandler
Access checking started
0.000206624
0.000032
umbracoRequestHandler
Page not protected
0.0002308
0.000024
umbracoRequestHandler
Access checking ended
0.000249088
0.000018
umbracoInit
Done handling request
0.00026704
0.000018
umbracoPage
Element loaded: mediaFolderId
0.000444832
0.000178
umbracoPage
Pagedata loaded for Classroom 1 (ID: 1345)
0.00047256
0.000028
umbracoPage
Looking up skin information
0.000501072
0.000029
aspx.page
End PreInit
0.000716992
0.000216
aspx.page
Begin Init
0.000743744
0.000027
renderMacro
Rendering started (macro: umb2ndLevelNavigation, type: 1, cacheRate: 0)
0.000779808
0.000036
umbracoMacro
Before adding extensions
0.00082256
0.000043
umbracoMacro InnerException
Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Assembly assembly, Type attribute) at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Type attribute) at umbraco.macro.GetXsltExtensionsImpl() at umbraco.macro.b__6() at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) at umbraco.macro.GetXsltExtensions() at umbraco.macro.AddMacroXsltExtensions() at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters) at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)
0.030990384
0.030168
item
Start parsing 'pagecontent'
0.031235744
0.000245
item
Done parsing 'pagecontent'
0.031288592
0.000053
renderMacro
Rendering started (macro: Get Gallery Images, type: 1, cacheRate: 0)
0.031326048
0.000037
umbracoMacro
Before adding extensions
0.031374304
0.000048
umbracoMacro InnerException
Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Assembly assembly, Type attribute) at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Type attribute) at umbraco.macro.GetXsltExtensionsImpl() at umbraco.macro.b__6() at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) at umbraco.macro.GetXsltExtensions() at umbraco.macro.AddMacroXsltExtensions() at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters) at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)
So, just in case someone else has it, 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).
Can't create or run XSLT scripts from hosted site
Hi all !
This is my first post so please be gentle ;)
I've uploaded my first project to a hosting company (PipeTen) and have found that I'm not able ti either create or execute XSLT functions on the site.
When I initially uploaded the site it was at version 4.6 and found that I needed to upgrade to 4.7.1.1 so that I could get it to work in a mudium trust environment.
Since doing this most of the site is working, but none of the XSLT's will run and I get the debug output below which complains about SQLServer CE (Which I'm not using as far as I know).
I've spoken to the hosting company and they are sating that this is because Umbraco wants to run in full trust mode, but if that's the case I don't see how they can have anybody running as they also tell me that a full trust solution won't be available for a couple of weeks yet.
I'm really lost at this point so any input would be greatly appreciated.
Many Thanks in advance
Kevin
Request Details
Trace Information
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown:
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Assembly assembly, Type attribute)
at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Type attribute)
at umbraco.macro.GetXsltExtensionsImpl()
at umbraco.macro.b__6()
at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
at umbraco.macro.GetXsltExtensions()
at umbraco.macro.AddMacroXsltExtensions()
at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters)
at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Unable to load one or more of the types in assembly 'System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Exceptions were thrown:
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Assembly assembly, Type attribute)
at umbraco.BusinessLogic.Utils.TypeFinder.FindClassesMarkedWithAttribute(Type attribute)
at umbraco.macro.GetXsltExtensionsImpl()
at umbraco.macro.b__6()
at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
at umbraco.macro.GetXsltExtensions()
at umbraco.macro.AddMacroXsltExtensions()
at umbraco.macro.GetXsltTransformResult(XmlDocument macroXML, XslCompiledTransform xslt, Dictionary`2 parameters)
at umbraco.macro.loadMacroXSLT(macro macro, MacroModel model, Hashtable pageElements)
Control Tree
Session State
Application State
Request Cookies Collection
Response Cookies Collection
Headers Collection
Response Headers Collection
Form Collection
Querystring Collection
Server Variables
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
I found the solution to this problem !
So, just in case someone else has it, 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 !
is working on a reply...