powered by Jive Software

Database

Hi Folks,

Which information must be in the PROPVALUE field of the JIVEGROUPPROP table?

The warn.log is showing the following message:

2005.09.06 08:57:42 There is a group property whose value is null of Group: marketing

Regards,

Eduardo

Hard to say for sure… i have one group and this is what is in my jivegroupprop table…

GROUP NAME | name | propvalue

Family | sharedRoster.showInRoster | OnlyGroup

Family | sharedRoster.displayName | Family

Family | sharedRoster.groupList |

Yes the last propvalue appears to be null.

Hope this helps…

Peter

Oi Eduardo,

Have you tried completing the missing value from the admin console instead of doing directly in the database? I would say that you have a shared group with no display name.

Regards,

– Gato

Gato,

All of my “shared groups” have display name. This message started showing in warn.log when I only changed the the name of the group to lower case. Any idea?

Regards,

Eduardo

Could you execute this query in your database and post the results?

SELECT name, propValue FROM jiveGroupProp WHERE groupName=“marketing”

I would like to know the property that has a null value.

Thanks,

– Gato

NAME


PROPVALUE


sharedRoster.displayName

Marketing

sharedRoster.groupList

sharedRoster.showInRoster

everybody

The sharedRoster.groupList has a NULL Value

Regards,

Eduardo

This is normal behavior.

Greg

Eduardo,

The propValue should be an empty string instead of a null value. I was not able to reproduce the case locally. Let me know if there is a way to generate that null value.

Obrigado,

– Gato

Wouldn’'t this do the trick?

update jivegroupprop set propValue = NULL where name = ‘‘sharedRoster.groupList’’ AND groupName = ‘‘GROUPNAME’’

Greg