Guys when I install the trial module I get the following

Info	Start Sql execution: 02.50.60.SqlDataProvider file
Warning	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
Info	End Sql execution: 02.50.60.SqlDataProvider file

 

Can you give me any guidance to fix this. It does complete the installation however when I look at where the field list should be when making the template there is nothing under the heading.

 

Thanks

 

Andy

 Hi Andy,

Can you please run this in Host, SQL:

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

Thanks!

Candace

Hi Candace

I have run the SQL code with success, however when I go into the

List Item Temple Editor I see the following SQL error and this maybe responsible for the fields not being made available

 

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'username'. Invalid column name 'userid'. ---> System.Data.SqlClient.SqlException: Invalid column name 'username'. Invalid column name 'userid'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.Modules.DynamicUserDirectory.Data.SqlDataProvider.DataSprings_RetrieveDNNUserProfileData(Int32 PortalID, String RoleFilter, String LimitResults, Int32 AuthOnly, String strUserFilter) at DataSprings.DNN.Modules.DynamicUserDirectory.Business.DynamicUserDirectoryController.DataSprings_RetrieveDNNUserProfileData(Int32 PortalID, String RoleFilter, String LimitResults, Int32 AuthOnly, String strUserFilter) at DataSprings.DNN.Modules.DynamicUserDirectory.Common.GetDotNetNukeUserFields(Int32 PortalID, Int32 TabId, Int32 ModuleID, String strUserFilter, Boolean blnTop1) at DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectoryEdit.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

 

Can you let me know what you think, Than kyou for your help so far.

 

Andy

HI, can you go to Host / Schedule and locate the Dynamic User Directory scheduler, click on History and see what it says? It should say something like: TempDUDProfile and TempDUDPivot tables have been successfully created. If you see some errors, please edit it's schedule, change the time that it runs, and update and the scheduler should kick off right away. Then go back to History and it should show success. If not, please reply with what the error is. -- David