 |  | |
| | |
| | |
| | |
 | | |
|
|
|
|
During the module install I get an SQL Provider error and would like to know what to do with/about it. | nfo | Start Sql execution: 01.01.08.SqlDataProvider file | | Warning | SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'CreatedDate'. Invalid column name 'CreatedDate'. ORDER BY items must appear in the select list if SELECT DISTINCT is specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- ============================================= -- Author: Don Worthley -- Create date: 02/13/2008 -- Description: Retrieve the list of Text/HTML modules which a user has access to edit. -- -- Modified: 02/27/2008 -- Modified by: Don Worthley -- Description: Added dbo. and momnet_ to the Users table. -- ============================================= ALTER PROCEDURE dbo.[momnet_itcMetaPost_Get_Html_Modules_By_FriendlyName_UserId_PortalId] @FriendlyName nvarchar(128) = NULL, @UserId int = 0, @PortalId int = 0 AS BEGIN SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET NOCOUNT ON -- Check to see if user is SuperUser or Admin DECLARE @IsSuperUser bit DECLARE @IsAdmin bit DECLARE @PortalAdminRoleId int DECLARE @IsPrivileged bit SELECT @IsSuperUser = IsSuperUser FROM dbo.momnet_Users WHERE UserId = @UserId SELECT @PortalAdminRoleId = AdministratorRoleId FROM dbo.momnet_Portals WHERE PortalId = @PortalId SELECT @IsAdmin = CASE WHEN EXISTS ( SELECT * FROM dbo.momnet_Users u JOIN dbo.momnet_UserRoles ur ON u.UserId = ur.UserId JOIN dbo.momnet_Roles r ON (r.RoleId = ur.RoleId) WHERE u.UserId = @UserId AND r.PortalId = @PortalId AND r.RoleId = @PortalAdminRoleId ) THEN 1 ELSE 0 END SELECT @IsPrivileged = CASE WHEN @IsAdmin = 1 OR @IsSuperUser = 1 THEN 1 ELSE 0 END SELECT DISTINCT m.ModuleId ,t.TabId ,tm.TabModuleId ,m.ModuleTitle ,t.TabPath ,ht.CreatedDate FROM dbo.[momnet_Modules] m LEFT JOIN dbo.[momnet_HtmlText] ht ON ht.ModuleID = m.ModuleID JOIN dbo.[momnet_ModuleDefinitions] md ON m.ModuleDefID = md.ModuleDefID JOIN dbo.[momnet_TabModules] tm ON tm.ModuleID = m.ModuleID JOIN dbo.[momnet_TABS] t ON t.TabID = tm.TabId LEFT JOIN dbo.[momnet_TabPermission] tp on t.TabID = tp.TabID LEFT JOIN dbo.[momnet_ModulePermission] mp on mp.ModuleID = m.ModuleID WHERE FriendlyName = @FriendlyName AND tp.AllowAccess = 1 AND m.PortalId = @PortalId AND t.DisableLink = 0 AND t.IsDeleted = 0 AND (@IsPrivileged = 1 OR ( (tp.RoleID IN ( SELECT RoleID FROM dbo.momnet_USERS u JOIN dbo.momnet_UserRoles ur ON ur.UserID = u.UserID WHERE u.UserID = @UserID) OR tp.UserID = @UserID) AND tp.PermissionID = 4 ) OR ( (mp.RoleID IN ( SELECT RoleID FROM dbo.momnet_USERS u JOIN dbo.momnet_UserRoles ur ON ur.UserID = u.UserID WHERE u.UserID = @UserID) OR mp.UserID = @UserID) AND mp.PermissionID = 2 )) ORDER BY ht.CreatedDate END | | Info | End Sql execution: 01.01.08.SqlDataProvider file |
|
|
|
|
| |
|
|
|
Hi Daniel,
Are you installing on DNN 5.1? If so, I'll need to send you a copy of the pre-release version of metaPost 1.3.6 which contains support for the new Text/HTML module which was re-written to support versioning and basic staging. Feel free to contact me directly at don with the normal at sign and itcrossing.com.
thanks,
Don
|
|
|
|
| |
| | |
| | |
| | |
|