I upgraded the site to DNN 7.1.1 and run your SQL script. Still I am getting errors in the SQL window. I did run successfully until this statement. I am running them one by one to the order you gave me.

I am getting this message.
" There is an error in your query! "

Please can you tell me if there is any issue in the script?

2)
CREATE FUNCTION {databaseOwner}[{objectQualifier}FitsExtendedPropertyPermission](
@viewingUserId int,
@viewedUserID int,
@extendedPermissions nvarchar(2000)) RETURNS bit
AS
BEGIN
DECLARE @rolesStr nVarChar(2000) = ''
DECLARE @reltnStr nVarChar(2000) = ''
DECLARE @gStartPos int
DECLARE @rStartPos int
DECLARE @recCount int = 0
DECLARE @SQL int
If (@viewedUserID > 0 and Len(IsNull(@extendedPermissions,'')) > 2) BEGIN
SET @gStartPos = CHARINDEX('G:',@extendedPermissions) + 2
SET @rStartPos = CHARINDEX('R:',@extendedPermissions) + 2
if @gStartPos > @rStartPos BEGIN
SET @rolesStr = SUBSTRING(@extendedPermissions, @gStartPos, Len(@extendedPermissions) - @gStartPos)
if @rStartPos > 0 SET @reltnStr = SUBSTRING(@extendedPermissions, @rStartPos, @gStartPos - @rStartPos - 1)
END
If @gStartPos < @rStartPos BEGIN
SET @reltnStr = SUBSTRING(@extendedPermissions, @rStartPos, Len(@extendedPermissions) - @rStartPos)
if @gStartPos > 0 SET @rolesStr = SUBSTRING(@extendedPermissions, @gStartPos, @rStartPos - @gStartPos - 1)
END
If @rolesStr <> '' BEGIN
SET @rolesStr = ',' + SUBSTRING(@rolesStr,1, Len(@rolesStr) - CASE WHEN RIGHT(@RolesStr,1) = ';' THEN 1 ELSE 0 END)
SELECT @recCount = COUNT(1) FROM {databaseOwner}[{objectQualifier}UserRoles] WHERE UserID = @viewingUserId AND @rolesStr LIKE '%,' + Convert(nvarchar(10),RoleId) + ',%'
END
If @recCount = 0 AND @reltnStr <> '' BEGIN
SET @reltnStr = ',' + SUBSTRING(@reltnStr,1, Len(@reltnStr) - CASE WHEN RIGHT(@reltnStr,1) = ';' THEN 1 ELSE 0 END)
SELECT @recCount = COUNT(1) FROM {databaseOwner}[{objectQualifier}vw_RelatedUsers] WHERE UserID = @viewingUserId AND relatedUserID = @viewedUserId AND @reltnStr LIKE '%,' + Convert(nvarchar(10),RelationShipID) + ',%' AND Status = 2
END
END
RETURN CASE WHEN IsNull(@RecCount, 0) > 0 THEN 1 ELSE 0 END
END






3) CREATE FUNCTION {databaseOwner}[{objectQualifier}FilePath]
(
@StrMayContainFileId nVarChar(255)
)
RETURNS nVarChar(500)
AS
BEGIN
DECLARE @Path AS nVarChar(500);

IF ISNUll(@StrMayContainFileId,'') = ''
SET @Path = ''
ELSE IF Lower(@StrMayContainFileId) LIKE 'fileid=%'
SELECT @Path = IsNull(Folder, '') + FileName FROM {databaseOwner}[{objectQualifier}vw_Files]
WHERE fileid = CAST(SUBSTRING(@StrMayContainFileId, 8, 10) AS int)
ELSE
SET @Path = @StrMayContainFileId
RETURN @Path -- never Null!
END

please clear eventlog and check for events. does the application get restarted frequently?

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

And here is a screenshot
http://awesomescreenshot.com/0261r73p3d