Read More »
During setup of a DotNetNuke portal the application asks for a time zone. In the drop down list "Arizona Time Zone" is not listed as an option. Read More »
During setup of a DotNetNuke portal the application asks for a time zone. In the drop down list "Arizona Time Zone" is not listed as an option.
After testing DNN 5 I notice traces of user in the database after they are deleted from the "User Accounts" under admin options. If DNN is setup to use unique email address, after a user is delete and recreated with the same email address DNN returns "ERROR IN DATABASE EMAIL ADDRESS EXISTS". I created the following stored procedure to completely cleanse all traces of a user from the DNN database. Please use the following STORED PROCEDURE at your own risk. I take no responsibility for misuse or damage this procedure could cause to your database. I was very careful with a ROLL BACK but mistakes do happen I suggest running this in test environment first. Read More »
After testing DNN 5 I notice traces of user in the database after they are deleted from the "User Accounts" under admin options. If DNN is setup to use unique email address, after a user is delete and recreated with the same email address DNN returns "ERROR IN DATABASE EMAIL ADDRESS EXISTS". I created the following stored procedure to completely cleanse all traces of a user from the DNN database.
Please use the following STORED PROCEDURE at your own risk. I take no responsibility for misuse or damage this procedure could cause to your database. I was very careful with a ROLL BACK but mistakes do happen I suggest running this in test environment first.