Administration

Two Portals same Domain

Dave — Thu, 17 Oct 2019 07:44:02 GMT

Hi Aderson

Brilliant

I've tested steps 1 and 2 and they work a treat

I'll test step 3 when I get to moving the main site

Thanks

Dave

Many Host Alerts - "Resource Not Found" in Admin Log

Aderson Oliveira — Fri, 25 Jan 2019 11:01:11 GMT

Hi Tom,

Do you get any other details from the log entry? Like which resource it is complaining about?

Cheers,

Aderson

Active Directory - Guidance / Manual

Aderson Oliveira — Fri, 25 Jan 2019 10:59:54 GMT

Thanks for the note Tom!

I have used AD from Glanton in the past with great success.

Cheers,

Aderson

Intranet

Aderson Oliveira — Tue, 19 Jun 2018 18:43:02 GMT

Hi Dave,

1 - 3rd party modules will not behave as local machines on intranets - You need them licensed as it site was a regular public site. Sorry;

2 - I was not the one setting it up but we used this module http://store.dnnsoftware.com/home/product-details/active-directory-authentication-v35 for AD integration with a DNN 8 site and it works very well.

My 2 cents.

Cheers,

Aderson

DNN 9 "Remove Deleted Users" gone?

Chad — Tue, 06 Feb 2018 16:57:09 GMT

FYI, I found this thread very helpful in reducing our spam accounts. I modified the scripts though to make them a bit more robust in wrapping all the transactions related to a user into a single transaction, so if one fails, that user account is not corrupted. This could be put into a stored procedure easily enough. Note this uses the presumption that you used another script to update the UserPortals.IsDeleted to 1 for those that you feel need to be deleted.

DECLARE @i int
DECLARE @user_id int
DECLARE @numrows int
DECLARE @userToDelete_table TABLE (
    idx smallint Primary Key IDENTITY(1,1)
    , UserId int
)

SET NOCOUNT ON

-- populate user table in-memory table to hold distinct user id
INSERT @userToDelete_table
Select Distinct UserId
From UserPortals 
WHERE PortalID = 1 and IsDeleted = 1

-- enumerate the table

SET @i = 1
SET @numrows = (SELECT COUNT(*) FROM @userToDelete_table)
IF @numrows > 0
    WHILE (@i <= (SELECT MAX(idx) FROM @userToDelete_table))
	--WHILE (@i <= 1000)
    BEGIN
        -- get the next primary key
        SET @user_id = (SELECT UserId FROM @userToDelete_table WHERE idx = @i)
		
		--
		BEGIN TRAN
			PRINT('******************************************')
			PRINT('UserId to Delete: ' + CAST(@user_id as varchar(10)))

			DELETE UserRoles WHERE UserID = @user_id
			PRINT('UserRoles Deleted for User ID: ' + CAST(@user_id as varchar(10)) + '. Rows Deleted: ' + CAST(@@ROWCOUNT as varchar(10)))
			
			DELETE UserPortals WHERE UserID = @user_id
			PRINT('UserPortals Deleted for User ID: ' + CAST(@user_id as varchar(10)) + '. Rows Deleted: ' + CAST(@@ROWCOUNT as varchar(10)))

			DELETE userprofile WHERE UserID = @user_id
			PRINT('userprofile Deleted for User ID: ' + CAST(@user_id as varchar(10)) + '. Rows Deleted: ' + CAST(@@ROWCOUNT as varchar(10)))
			
			DELETE aspnet_membership WHERE UserId = 
				(
					SELECT au.UserId 
					FROM dbo.aspnet_Users as au INNER JOIN
                         dbo.Users as u ON au.UserName = u.Username
					WHERE  u.UserID = @user_id
				)
			PRINT('aspnet_membership Deleted for User ID: ' + CAST(@user_id as varchar(10)) + '. Rows Deleted: ' + CAST(@@ROWCOUNT as varchar(10)))
			
			DELETE aspnet_users WHERE UserId = 
				(
					SELECT au.UserId 
					FROM dbo.aspnet_Users as au INNER JOIN
                         dbo.Users as u ON au.UserName = u.Username
					WHERE  u.UserID = @user_id
				)
			PRINT('aspnet_users Deleted for User ID: ' + CAST(@user_id as varchar(10)) + '. Rows Deleted: ' + CAST(@@ROWCOUNT as varchar(10)))
			
			DELETE Users WHERE UserID = @user_id
			PRINT('Users Deleted for User ID: ' + CAST(@user_id as varchar(10)) + '. Rows Deleted: ' + CAST(@@ROWCOUNT as varchar(10)))

			PRINT('')
			PRINT('')

		COMMIT    

        -- increment counter for next employee
        SET @i = @i + 1
    END

Spam forum attacks

Aderson Oliveira — Mon, 15 Jan 2018 10:08:35 GMT

Thank you Richard.

It was the blog module. seemed to be manual updates. I think I may have gotten in control

Thank you for the offer Richard!

Aderson

Goodbye Span Registrations forever

richard — Fri, 11 Aug 2017 14:50:45 GMT

Hi Aderson

I will retry the upgrade as I tried 7 to 9 and things were quite broken. Ill try 7 to 8 and see if that's better.

Custom Role with Special Character

Aderson Oliveira — Mon, 28 Nov 2016 12:42:57 GMT

Thanks for sharing Michael - Sometimes you have to "kick the bucket" to have things refreshed on DNN's interface. It is about cached data. I always make sure I force a site recycle when I want to ensure changes to the DB are reflected on the site.

Cheers,

Aderson

DNN 8 Administrator permission

Aderson Oliveira — Mon, 31 Oct 2016 18:22:54 GMT

Thank you for sharing your finding Dave!

Cheers,

Aderson

DNN8 Bulk Installer Missing

Aderson Oliveira — Mon, 26 Sep 2016 19:16:47 GMT

Grat that it worked!

Thank you for letting us know Tyler.

Aderson

jQuery is Undefined for Regular Users

michael — Thu, 08 Sep 2016 09:42:12 GMT

Thanks for your reply. It is a really odd problem. I looked at my html source and did a lookup for jQuery and it's not even attempting to load when a user is logged in. There's a bunch of scripts that are commented out in the source but none of them are the basic jQuery.min.js. I was able to create a patch for the problem. I created a module that was placed on all pages (that's a really handy feature) that on page pre-render forces jQuery to load. That has fixed the issue for now so I can move on but I'd still like to figure out what went wrong here.

Templates - exporting and using

Aderson Oliveira — Fri, 02 Sep 2016 09:13:17 GMT

Hi Dave,

Thanks for this level of details! You should write an article about your experience once you are done. I would gladly publish it on DNNHero and could potentially turn it to a video tutorial as well.

Thank you!

Aderson

Exception+has+been+thrown+by+the+target+of+an+invocation.&content=0

Aderson Oliveira — Wed, 31 Aug 2016 15:11:21 GMT

Thank you for letting us know Michael. At least you know it is related to the DLLs you placed.

Aderson

DNN 7.2 site down after autoupdate

Aderson Oliveira — Wed, 25 May 2016 16:38:44 GMT

Hi Tom,

First is that a DNN site doesn't auto update if you haven't copied newer files on top of it. Maybe you haven't done it but maybe someone else did it. If this is not the case, then the problem must be something else.

In any case we have a video series just covering troubleshooting @ DNHero - http://www.dnnhero.com/Premium/Tutori...

Thatg should help you going about different strategies.

Best regards,

Aderson

HTML5 compliance

Aderson Oliveira — Wed, 21 Oct 2015 09:57:17 GMT

Hi Chris,

IT seems to be possible but to be honest I don't know the ins and outs. It seems these guys know it. Seems to be pretty fresh information:

http://www.dnncreative.com/video/how-to-achieve-dnn-html5-compliance-converting-your-dnn-theme-to-html5

Best regards,

Aderson

New User - Email Notifications

Aderson Oliveira — Mon, 06 Jul 2015 09:21:24 GMT

Hi Dave,

I would recommend that you try to send some test emails from Admin/Newsletters to see if you get more specific error messages and to see if you can get any Event Log error as well.

I would also test the SMTP settings under Host/Host Settings as well. There is a "Test" button over there which sends an email to the emails address set under Host/Host Settings/Host Details/Host Email

Best regards,

Aderson

Upgrade produces DNN Error

Aderson Oliveira — Mon, 15 Jun 2015 12:16:31 GMT

Hi Dave,

1 - I'm not aware of such options. I don't think there are another options like that available;

2 - Usually 3rd Party URL rewriters can be disabled inside the web.config. I would open up the one you have, try to find references about TanLD and replace by looking at the web.config os a fresh DNN install from the same version of your original DNN site.

That would be the strategy we would use.

Best regards,

Aderson

Deleting Redundant Portals

Aderson Oliveira — Wed, 13 May 2015 14:57:33 GMT

Hi Dave,

Not sure what you mean by "redundant portals", but if these are portals that were created and never used then that is a good approach and DNN does remove records of those portals from the DB.

Best regards,

Aderson

Spam Reg

Aderson Oliveira — Thu, 12 Mar 2015 10:25:35 GMT

Hi David,

That is strange. You said "get even more emails from Administrator reporting a failed registration" - Can you post here the contents of that failed registration email?

Thanks,

Aderson

All admins are receiving new user notifications

Paul — Thu, 30 Oct 2014 09:27:22 GMT

Yeah that is an all or nothing setting looks like. My main thing is verifying that the behavior i'm seeing now (all admins receiving these) is expected, and not something I have configured wrong. It seems if it's expected that it is a change in behavior from past versions of DNN, but I haven't been able to find confirmation on that. Thank you!

Administration

Two Portals same Domain

Many Host Alerts - "Resource Not Found" in Admin Log

Active Directory - Guidance / Manual

Intranet

DNN 9 "Remove Deleted Users" gone?

Spam forum attacks

Goodbye Span Registrations forever

Custom Role with Special Character

DNN 8 Administrator permission

DNN8 Bulk Installer Missing

jQuery is Undefined for Regular Users

Templates - exporting and using

Exception+has+been+thrown+by+the+target+of+an+invocation.&content=0

DNN 7.2 site down after autoupdate

HTML5 compliance

New User - Email Notifications

Upgrade produces DNN Error

Deleting Redundant Portals

Spam Reg

All admins are receiving new user notifications

More...