can't get new private message count

[Migrated From Jforum.net]

dear jforum team,

i've checked out and built/installed 2.1.5 using postgres. i've also enabled sso and implemented my own authenticateUser() - that was all easy (thanks ;)

problem now is I can't get new pm count to appear by using ${session.privateMessages} - it is always zero. the user table also shows zeros;

jforum=> select user_id,user_allow_pm,user_new_privmsg,user_unread_privmsg,user_last_privmsg, user_notify_pm from jforum_users;
 user_id | user_allow_pm | user_new_privmsg | user_unread_privmsg | user_last_privmsg | user_notify_pm
---------+---------------+------------------+---------------------+-------------------+----------------
       2 |             1 |                0 |                   0 |                   |              1
      19 |             1 |                0 |                   0 |                   |              1
      20 |             1 |                0 |                   0 |                   |              1
      21 |             1 |                0 |                   0 |                   |              1
       1 |             1 |                0 |                   0 |                   |              1
(5 rows)

I'm no error messages in logs etc.

Anyone got any pointers to where i should be looking - I'm relatively new to j2ee so all help appreciated.

thanking you, -Mark.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

You should do a different SELECT statement - JForum does not store the values in jforum_users for performance reasons.

Open WEB-INF/config/database/generic/generic_queries.sql and look for the query named "UserModel.selectById". You'll understand how to do it

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

ya - cool. I never looked there ops:
-Mark.
[originally posted on jforum.net by Anonymous]