English (United States) English (United Kingdom)
Thursday, September 02, 2010

Smart-Thinker DNN Forums
Smart-Thinker DNN Forums

Forum Guidelines

Please ensure you follow the bug-raising guidelines (e.g. post the full error from your Event Viewer) if you are raising a support call. To request a feature in a module, please use Feature Requests (unless you want to discuss it here in more detail first). If you have an urgent feature that you would like to see in the product then you should consider a Sponsored Enhancement

First Time User? Make sure you have read the Module Config Guide in the documents folder of each module. Also check out this handy Module Deployment Guide (written by a Smart-Thinker customer!)

Configuration issues and no time to read the Forums/Documentation? See our DotNetNuke Premium Support Service. We need your opinion! Please read our proposed new CrowdSourcing development method and let us know if you would be interested and if it might work.

Please ensure you follow the bug-raising guidelines (e.g. post the full error from your Event Viewer) if you are raising a support call. To request a feature in a module, please use Feature Requests (unless you want to discuss it here in more detail first). If you have an urgent feature that you would like to see in the product then you should consider a Sponsored Enhancement

First Time User? Make sure you have read the Module Config Guide in the documents folder of each module. Also check out this handy Module Deployment Guide (written by a Smart-Thinker customer!)

Configuration issues and no time to read the Forums/Documentation? See our DotNetNuke Premium Support Service. We need your opinion! Please read our proposed new CrowdSourcing development method and let us know if you would be interested and if it might work.

 
 
  Forums  DotNetNuke  Smart-Thinker U...  User directory and user list
Previous Previous
 
Next Next
New Post 16/09/2008 07:50
  leif leiner
7 posts
5th Level Poster


User directory and user list  (France)

Hi,

Enjoying the trial version of User Profile and have a few questions about configuring the modules.  What I'd like to do is to have a set-up like the Poker profiles where all the information is concentrated and linked in. Is this possible with the standard modules and if so I'd appreciate if you could send me in the right direction.

In the moduleDeployment guide it says to put UserDirectory and User list on the same tab, what is the difference between the 2 and why should they go on the same tab ?

I've also got a couple of errors like the Wall otNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. I di install the events module but nothing changed, any ideas ?

Another mystery : You have not passed in a UserID to add, I've tried every possible combination but can't seem to find the solution.

If there's more documentation around I'd be very grateful if you could send me a link or a hint how to solve these small issues.

 

Thanks in advance

Leif

 
New Post 16/09/2008 16:54
  Rodney Joyce
3229 posts
www.DNNDir.com
1st Level Poster




Re: User directory and user list  (Australia)

Hi Leif,

 

Ok, lets look at these one at a time -

1) Yes, it is possible to link it all - the modules are quite complex so some time and patience is required but this brings great flexibility too depending on your site requirements.

2) You do not have to have the 2 modules on the same page - check out my find poker players page on PokerDIY - the UserList can be used to show the latest new users on a site (I use it on the PokerDIY home page on the bottom right). The latter is ordered by CreatedDate so works well for New Users, the first is designed to be a searchable dir of users.

3) Can you please list every error from the event log when this happens - where there any errors on install? I am not aware of any outstanding errors and would like to know more about these if poss.

4) "You have not passed in a UserID to add" - I am not sure what you mean by this? What page/functionality are you referring too?


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 17/09/2008 05:11
  leif leiner
7 posts
5th Level Poster


Re: User directory and user list  (France)

Thanks for your reply Rod.

A couple of issues below

The Wall played up again :

ModuleId: 1945
ModuleDefId: 221
FriendlyName: Smart-Thinker - Wall
ModuleControlSource: DesktopModules/Smart-Thinker - Wall/WallTopics.ascx
AssemblyVersion: 04.08.00
PortalID: 0
PortalName: Mon Epicure
UserID: 4
UserName: leiner
ActiveTabID: 53
ActiveTabName: MyEpicure
RawURL: /Accueil/MyEpicure/tabid/53/ID/3/language/fr-FR/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.monepicure.com/Accueil/MyEpicure/UserDirectory/tabid/1258/language/fr-FR/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 192700c2-10de-47b1-bf61-d3388271d744
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: SmartThinker.DNN.Modules.Wall.Business.WallUtils.IsGroupOwner
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at SmartThinker.DNN.Modules.Wall.Business.WallUtils.IsGroupOwner(Int32 groupID, Int32 userID) at SmartThinker.DNN.Modules.Wall.Business.WallUtils.IsItemOwner(Int32 relatedID, Int32 userID) at SmartThinker.DNN.Modules.Wall.WallTopics.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Nom du serveur: DEDI488

User Groups unknown

Erreur: Smart-Thinker - UserGroup Search inconnue.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.SmartThinker_GroupCountryCount_C' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.SmartThinker_GroupCountryCount_C' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at SmartThinker.DNN.Modules.UserGroup.Data.SqlDataProvider.GetSmartThinker_GroupCountryCount(Int32 portalID) at SmartThinker.DNN.Modules.UserGroup.Business.SmartThinker_GroupController.GetSmartThinker_GroupCountryCount(Int32 portalID) at SmartThinker.DNN.Modules.UserGroup.UserGroupSearch.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Thanks

Leif

 
New Post 17/09/2008 05:28
  Rodney Joyce
3229 posts
www.DNNDir.com
1st Level Poster




Re: User directory and user list  (Australia)

Can you please confirm the module versions you are using (UP, Groups and Wall?)

 

Were these new installs or upgrades of old versions?


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 17/09/2008 06:38
  leif leiner
7 posts
5th Level Poster


Re: User directory and user list  (France)

I'm using

UP 4.03.12

Wall 4.03.02

Groups 4.03.07

It's a new install, but if the trial licence allows I can try it on another site.

Leif

 
New Post 18/09/2008 01:23
  Rodney Joyce
3229 posts
www.DNNDir.com
1st Level Poster




Re: User directory and user list  (Australia)

Yes, I see you tried it on another install - that is fine.

 

It looks like it is to do with some changes in the Wall software - I will be releasing a new version tomorrow which will fix this issue.

 

The second error is REALLY odd if there were no issues on the Groups install - that stored proc has been there for ages!

Can you crack open the SQL files and extract this SP and run it on your SQL DB - SmartThinker_GroupCountryCount_C?

 


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 18/09/2008 01:54
  leif leiner
7 posts
5th Level Poster


Re: User directory and user list  (France)

Rod,

Cleaned up my install and tried to install the UserGroups PA and got the following SQL.

Information Traitement en cours04.03.01.SqlDataProvider
StartJob Début de traitement de script Sql : 04.03.01.SqlDataProvider
Failure Erreur pendant la génération SQL : System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation. 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) CREATE PROCEDURE dbo.SmartThinker_GroupCountryCount_C AS SELECT L.Text As Country, COUNT(GroupID) As GroupCount FROM SmartThinker_Group G INNER JOIN Lists L ON L.Text = G.Country AND L.ListName = 'Country' WHERE G.PublicGroup = 1 GROUP BY L.Text
EndJob Exécution SQL terminée : fichier 04.03.01.SqlDataProvider
 
Information Traitement en cours04.03.02.SqlDataProvider
StartJob Début de traitement de script Sql : 04.03.02.SqlDataProvider
Failure Erreur pendant la génération SQL : System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation. 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) CREATE PROCEDURE dbo.SmartThinker_GroupCountryCount_C ( @PortalID int ) AS SELECT L.Text As Country, COUNT(GroupID) As GroupCount FROM SmartThinker_Group G INNER JOIN Lists L ON L.Text = G.Country AND L.ListName = 'Country' WHERE G.PublicGroup = 1 AND G.PortalID = @PortalID GROUP BY L.Text
 
New Post 18/09/2008 06:52
  Rodney Joyce
3229 posts
www.DNNDir.com
1st Level Poster




Re: User directory and user list  (Australia)

Hmm - this seems to be getting worse - can you uninstall the module completely (and make sure all DB objects are erased) and resinstall it?


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
New Post 18/09/2008 07:53
  leif leiner
7 posts
5th Level Poster


Re: User directory and user list  (France)

I'll try that, I've uninstalled all the modules. Do you which tables are affected by the modules ( a sure way of checking that everything has been deleted)

Leif

 
New Post 18/09/2008 15:11
  Rodney Joyce
3229 posts
www.DNNDir.com
1st Level Poster




Re: User directory and user list  (Australia)

All the Smart-Thinker objects are prefixed with "SmartThinker_" - just make sure all the tables and sps have been dropped.


Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog
 
Previous Previous
 
Next Next
  Forums  DotNetNuke  Smart-Thinker U...  User directory and user list
Top Threads Minimize
In the past 1 week, we have 0 new thread(s) and 0 new post(s)
In the past 1 week, we have 0 new thread(s) and 0 new post(s)
Print  

Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke - DotNetNuke Powered!
Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke - DotNetNuke Powered!
© 2008 Smart-Thinker