Hi

If it is not one thing, it's another!

We decided to standardize for all account usernames to just using email addresses. In the process of doing that (by going into the db and changing the Users and aspnet_Users table), I realized that the detail link of the user's directory doesn't work for those changed accounts.

Basically, the listing works, however, when I click on the "view details" link, it goes to a empty record. How do I fix this? thanks.

= reuben

Hi Reuben... Well there are two potential issues here...

1. I don't think you can simply change the username in that table but I could be wrong.

2. Any changes that are made to a user (such as if a new user registered or a user changed their info) this data is heavily cached in DUD. The data is generated (typically hourly) under a scheduled process under host/schedule. So I would likely make sure that this schedule has kicked off after the recent change you make.

Thanks,

-Chad

Which process is this? I can't find any DUD process on the schedule of the DNN.

Hi I think the process needs to be added manually since I don't see it anywhere. Which process is this, and how do I add this to the schedule?

Presently using DNN 05.04.02 (66)

Thanks for any information so that I can resolve this issue soon.

HI, the process should be called:

DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory

If you don't see it, you can add it by going to Host / SQL and typing in:

execute AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,0, 'Dynamic User Directory',1

See if this will work for you. -- David To

Didn't work and gave me an error as follows. I assume that I should check off the "Run as script" box.

System.Data.SqlClient.SqlException: Procedure or function AddSchedule has too many arguments 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 ConnectionString, String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) execute AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,0, 'Dynamic User Directory',1

Hi

I did a quick test by installing the DUD on a clean version of DNN and I get this error. I am using DUD 3.0.30 and DNN 05.04.04. The process is not installing for some reason.


SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@FriendlyName', which was not supplied. 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) -- ADD DNN SCHEDULER ITEM if not exists (select TypeFullName from schedule where TypeFullName = 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory') if exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'Schedule' and COLUMN_NAME = 'CreatedByUserID') execute AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,1 else execute AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL

Reuben,

This is happening because there are many different versions of DNN and with recent versions they started changing the stored procedure that adds schedules to the scheduler. We are starting (already handled for IUI and Opt In Email) to move scheduled tasks to being added via the DotNetNuke Controller within the code but there are a few modules such as DUD where the update hasn't been posted for this.

For 5.4, it appears that there is one fewer item added to the add schedule routine. You can run this:

execute AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,0, 'Dynamic User Directory'

Basically, this is the same thing David posted but I took out the last item which is the ,1.

-Chad

Ok - this works. Thanks!

You might want to send another patch for the install since the install is failing to start up the scheduled process.

Thanks... Glad to hear!

The real problem here is that with many different DNN versions any patch would work on some but not all. The real solution is for the next release where we can have the scheduled task added via VB code instead of SQL stored procedure that DNN uses.

Thanks!

-Chad