I have just upgraded DNN from 4.5.2 to DNN 4.5.3 (I installed 4.5.2 hours before 4.5.3 was released just over a month ago).
All of the modules I have see to be working fine, except 3rd party - MMLinks module not appearing, Is there a way I can extract the information that was in the module using SQL queries?
More importantly for now, when logging in I am getting this - Keyword not supported: 'user id' - error and can not see the information in the modules, nor edit any modules (apart from settings). This appears on all pages too those with or without the MMLinks module.
The error details are:
AssemblyVersion: 04.05.03
PortalID: 0
PortalName: The Accountants Circle
UserID: 1
UserName: David Toohey
ActiveTabID: 36
ActiveTabName: Home
RawURL: /Home/tabid/36/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.accountantscircle.co.uk/MemberLogin/tabid/269/Default.aspx?returnurl=%2fHome%2ftabid%2f36%2fDefault.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 499db795-c41a-4fe2-b96d-2a21020a3890
InnerException: Keyword not supported: 'user id'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.Common.DbConnectionOptions.ParseInternal
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Keyword not supported: 'user id'. ---> System.ArgumentException: Keyword not supported: 'user id'. at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at SysDataNet.Store.StoreAdmin.GetLangID() at SysDataNet.Store.ModuleCart.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
as well as on the page with the MMLinks module...
AssemblyVersion: 04.05.03
PortalID: 0
PortalName: The Accountants Circle
UserID: 1
UserName: David Toohey
ActiveTabID: 36
ActiveTabName: Home
RawURL: /Home/tabid/36/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.accountantscircle.co.uk/MemberLogin/tabid/269/Default.aspx?returnurl=%2fHome%2ftabid%2f36%2fDefault.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: cb6e3e26-9f0f-48b6-8672-3802ef39f6d3
InnerException: Keyword not supported: 'user id'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.Common.DbConnectionOptions.ParseInternal
StackTrace:
Message: System.ArgumentException: Keyword not supported: 'user id'. at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Delisoft.DNN.Modules.MMLinks.Data.SqlDataProvider.GetMMLinksTitleLocales(Int32 moduleId, String localeKey) at Delisoft.DNN.Modules.MMLinks.Business.MMLinksTitleLocalesController.Get(Int32 moduleId, String localeKey) at Delisoft.DNN.Modules.MMLinks.MMLinks.a(Object A_0, EventArgs A_1) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings)
Source: