Hi,

I received the following error during installation. I'm running on localhost, DNN version 5.2.1, SQL Server 2008. I also have Dynamic Login and Dynamic Registration installed on this portal.

Any ideas?

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.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

Thanks.

Hi Vinny,

I'll follow with Chad about this one.  Thanks!

Candace

Thanks Candace. I'm looking forward to hearing from Chad.

Hi Vinny,

I believe newer versions of DNN started adding a new schedule property called Friendly Name. To get around this you will need to manually add the scheduler item.. We are working on an updated patch, DNN has been changing the scheduler table between 5.0, 5.1 and now 5.2 so there are different scripts to add the scheduled item.

So, for now... Go to host/SQL and execute this:
execute AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,0, 'Dynamic User Directory'

That should fix you up.


-Chad

Thanks Chad. I followed your instructions and have successfully added the module to a page.

I experienced the same error when upgrading from Dynamic User Directory 2.5 to 3.0 on a DNN 5.2.2 installation. I ran Chad's script and it executed fine. However, when I now try to view the User Directory, I don't see *any* users. I will start a separate thread about this problem.

ignore.. posted on the wrong thread