umbraco v 4.5.2 (Assembly version: 1.0.3891.20719)
Koiak_Standard_Site_1.1
ASP.NET 4
Windows 2008, IIS Version 7
We are currently evaluating Umbraco to see if we would like to use it in our website redesign project. The system is brand new without any packages installed in it When I try to install Koiak_Standard_Site_1.1 I am getting the following error.
Any help would be greatly appreciated.
With Regards
David C Dillman
Keyword not supported: 'datalayer'. 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.ArgumentException: Keyword not supported: 'datalayer'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
In web.config, find the appsetting for db called "umbracoDbDSN". If there's anything "datalayer" there - just remove it .. Here's an example of a correct one for MS SQL:
After we removed the datalayer parameter and restarted the server we were no longer able to logon to umbraco. It would not accept any of the IDs / Passwords.
It sounds as one of the packages you rely on does not support MySql - if you feed a MySql connection string to a SQLServer adapter it will raise an error similar to this, as far as I remember
It does indeed sound like the package MS SQL Server specific.
I had a similar issue with one of my packages not supporting SQL CE 4 in 4.6. The easy fix is to use the built in Application.SqlHelper within Umbraco to do your database calls. Umbraco constructs a SQL Connection for you based upon the Umbraco config, then you can just use the methods of the SQL helper to execute your scripts.
Keyword not supported: 'datalayer'
umbraco v 4.5.2 (Assembly version: 1.0.3891.20719)
Koiak_Standard_Site_1.1
ASP.NET 4
Windows 2008, IIS Version 7
We are currently evaluating Umbraco to see if we would like to use it in our website redesign project. The system is brand new without any packages installed in it When I try to install Koiak_Standard_Site_1.1 I am getting the following error.
Any help would be greatly appreciated.
With Regards
David C Dillman
Keyword not supported: 'datalayer'.
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.ArgumentException: Keyword not supported: 'datalayer'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ArgumentException: Keyword not supported: 'datalayer'.]
System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +6337982
System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +134
System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +103
System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +35
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +253
System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +60
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +68
Koiak.BasicSite.usercontrols.BasicSiteInstall.Page_Load(Object sender, EventArgs e) +5148
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
System.Web.UI.Control.LoadRecursive() +71
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3048
In web.config, find the appsetting for db called "umbracoDbDSN". If there's anything "datalayer" there - just remove it .. Here's an example of a correct one for MS SQL:
<add key="umbracoDbDSN" value="server=.\SQLEXPRESS;database=umbraco45demo;user id=umbraco;password=nomatterwhatyoudoyourenotgonnaguessit" />
Good luck
Jesper
After we removed the datalayer parameter and restarted the server we were no longer able to logon to umbraco. It would not accept any of the IDs / Passwords.
Thanks
David
Our Original Line:
<add key="umbracoDbDSN" value="server=servername;database=databasename;user id=username;password=password;datalayer=MySql" />
Updated Line:
<add key="umbracoDbDSN" value="server=servername;database=databasename;user id=username;password=password" />
It sounds as one of the packages you rely on does not support MySql - if you feed a MySql connection string to a SQLServer adapter it will raise an error similar to this, as far as I remember
>Tommy
Hello,
Is there any update to this issue, as I am getting the same error?
Also, does this package require MySql? I am using MS SQL.
Lastly, how does one create an "empty" Umbraco site to then import this package? I am working in Microsoft WebMatrix.
Thanks,
Paul
It looks like (from stack trace) that Koiak.BasicSite don't support datalayer, try verify it
Petr
I am stuck on this as well :(
This package runs some SQL during the install process using the Enterprise Data blocks. Looks like this doesn't support the 'datalayer' syntax.
It looks like this package is restricted to MS SQL databases only.
It does indeed sound like the package MS SQL Server specific.
I had a similar issue with one of my packages not supporting SQL CE 4 in 4.6. The easy fix is to use the built in Application.SqlHelper within Umbraco to do your database calls. Umbraco constructs a SQL Connection for you based upon the Umbraco config, then you can just use the methods of the SQL helper to execute your scripts.
Hope this helps.
Matt
Thanks Matt, but that's exactly what I do.
I do use the Membership API a lot, and a obsolete method called "AddGroup". I'll using the new method AddUserToRole and see if this works.
is working on a reply...