Orphaned users can be left when deleting a portal from a set of DotNetNuke portals. Using some SQL the orphaned users can be deleted from the users, aspnet_membership and aspnet_users tables. To delete these users navigate to the SQL page under host. Enter the following code in the text area and click on Run Script. […]
Category: DotNetNuke
System.Web.AspNetHostingPermission Failed
Recently whilst upgrading a DotNetNuke website I encountered the error: System.Security.SecurityException: Request for the permission of type ‘System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, failed. The issue is caused in Windows 2008 Server by the permissions on an extracted zip file. When using the built-in Windows file unzip the permissions are retained relevant to the original user. Thus […]
Installing DotNetNuke on Windows XP
DotNetNuke can be installed on Windows XP to provide a test and development environment. Implementing DotNetNuke on Windows XP allows for: a backup up for a live DotNetNuke website try out ideas and development for the live website development of custom modules and skins To add a DotNetNuke website to Windows XP, the files available […]
Error File Upload is Unavailable Cannot Access a Closed File
DotNetNuke version 3 can give an error relating to a file upload, indicating that it can’t be completed. The issue being a closed file: Error: File Upload is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot access a closed file. —> System.ObjectDisposedException: Cannot access a closed file. at System.IO.__Error.FileNotOpen() at System.IO.FileStream.Seek(Int64 offset, SeekOrigin origin) at System.Web.HttpRawUploadedContent.TempFile.GetBytes(Int32 offset, Int32 length, […]
Read More… from Error File Upload is Unavailable Cannot Access a Closed File
Get Stored Procedure Using SQL
Not having backend access to a DotNetNuke website, or readily able to download a backup of the database. My thoughts turned to how to review a stored procedure with SQL from the SQL host page in DotNetNuke. SELECT text FROM syscomments WHERE id = (SELECT id FROM sysobjects WHERE name = ‘StoredProcedureName’) ORDER BY colid […]
Setting Default Date Format
The default date format can be set using the globalization tag within web.config. The DotNetNuke settings will then override this dependant upon the localisation settings of the browser and the logged in user. The format of the date is governed by the culture setting in the web.config file. As installed the tag looks like: <globalization […]
Restricting Modules Available to Portals
DotNetNuke allows more than one website to be hosted on one instance of the DotNetNuke site code. By configuring a DNN module as a premium module, a module may be assigned for use on a sub-set of the portals. Navigate to the extensions page, within the host pages. Select the module whose usage you wish […]
Everyone can Edit DotNetNuke Module
DotNetNuke modules should be editable by administrators only, but can become editable by all visitors to a website. If you have a module which is editable by more than the administrators of the website it is likely a permissions configuration issue. Later versions (7) For the later DNN 7, enable edit mode for the page […]
Login Failed for SQL Server Login
Updating a DotNetNuke website I was unable to proceed, encountering the error: login failed for SQL Server login. The full error reported by DNN was: DotNetNuke Upgrade Error The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )ERROR: Could not connect to database. Login failed for SQL Server login ‘dbUser’. […]
Runat Attribute Must Have the Value Server
Following Microsoft’s updates for August 2007 I received the following error on a DotNetNuke website: Error: Edit Text/HTML is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: The Runat attribute must have the value Server. —> System.Exception: The Runat attribute must have the value Server. —> System.Web.HttpParseException: The Runat attribute must have the value Server. —> System.Exception: The Runat attribute […]
