Database

Openfire Openfire Support
1

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

2

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

3

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

4

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

5

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

6

NAME

PROPVALUE

sharedRoster.displayName

Marketing

sharedRoster.groupList

sharedRoster.showInRoster

everybody

The sharedRoster.groupList has a NULL Value

Regards,

Eduardo

7

This is normal behavior.

Greg

8

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

9

Wouldn’'t this do the trick?

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

Greg