Error after install (ignores table prefix)
Last Post 03-19-2009 08:37 PM by Chad Nash. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Thomas BornUser is Offline
going with the flow
going with the flow
Posts:78
Avatar

--
03-18-2009 01:27 AM

    Hi;

    I have installed the Dynamic User Directory module and when I tried to configure it I receive the error message as below. It looks to me that it did not add the prefix to the table names that I selected. Can this be easily fixed?

    Error message:

    Error: is currently unavailable.
    DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dbo.ProfilePropertyDefinition'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.ProfilePropertyDefinition'. 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) at DataSprings.DNN.Modules.DynamicUserDirectory.Business.DynamicUserDirectoryController.DataSprings_RetrieveDNNUserProfileData(Int32 PortalID, String RoleFilter, String LimitResults, Int32 AuthOnly) at DataSprings.DNN.Modules.DynamicUserDirectory.Common.GetDotNetNukeUserFields(Int32 PortalID, Int32 TabId, Int32 ModuleID) at DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectoryEdit.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

     

    Thanks

    Thomas

     

    Thomas BornUser is Offline
    going with the flow
    going with the flow
    Posts:78
    Avatar

    --
    03-18-2009 01:28 AM

    BTW I am using th demo version

    Thomas BornUser is Offline
    going with the flow
    going with the flow
    Posts:78
    Avatar

    --
    03-18-2009 02:30 AM
    I debuged the SQL and found the error was in dnn_DataSprings_RetrieveDNNUserProfileData3. There were some other SPs as well that didn't have the dnn_prefix so you may want to check those in your release.
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    03-19-2009 08:37 PM
    IKes... Thanks, yes I will check into this right away and test on a site that use object qualifiers.

    -Chad



    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi