[eGroupWare-users] Hidden user accounts

[Gordon F. <in...@ib...>]

Hi community,
I'm currently experiencing the same problem like described here before a
couple of times:
Some of my user accounts are hidden. I can't see them anymore but the are in
the database. The do not appear in the admins user accounts screen nor on
any other screens like in the task delegation list of the infolog app.

Reading the forum I tried to repair all tables and I manually reestablished
links from the egw_accounts to egw_addressbook - without success. Accounts
are still hidden.

Next step was to trace the SQL SELECT queries to see what eGW is actually
asking the database for. I discovered the responsible query in the mysql
logfile:
SELECT SQL_CALC_FOUND_ROWS DISTINCT
egw_addressbook.*,account_lid,account_type,egw_accounts.account_id FROM
egw_addressbook  RIGHT JOIN egw_accounts ON
egw_accounts.account_id=egw_addressbook.account_id WHERE contact_private=0
AND egw_addressbook.contact_owner=0 ORDER BY account_lid ASC LIMIT 0,30
If I omit the complete WHERE clause all account entries are selected. If I
insert either one of the two WHERE conditions some accounts are still
missing. The missing user accounts to not have private contacts. The linked
contacts are assigned to group address books.

I'm not able to interpret the WHERE conditions. So where is my problem? What
did I do wrong and what do I need to do to show alle user accounts to the
admin?

Thanks a lot
Gordon
-- 
View this message in context: http://www.nabble.com/Hidden-user-accounts-tp15586220s3741p15586220.html
Sent from the egroupware-users mailing list archive at Nabble.com.