Account search and advanced search

**VirtualSynergy** · 2011-02-25, 12:36 PM

I've been encountering some problems for a while now..

After the upgrade from 5.5 to 6.x the old user accounts weren't able to use account search and advanced account search. It only displays "No Data". The accounts are accessable by the other search in the right top corner but not with the normal search. Newly made users can search and there are nog problems with those.

I've reset all preferences without any luck.. Repair and Rebuild aswell no luck.. All other modules are working fine and everyone can use search and adv. search. So i don't know what to change to fix this

Tnx for the help in advance!

**eitrix** · 2011-02-25, 02:21 PM

turn on debug logging and see what's wrong

**VirtualSynergy** · 2011-02-27, 07:38 AM

This is the log where search ain't working (old accounts):

Code:

Sun Feb 27 08:30:19 2011 [27972][a3bdeb32-e868-b557-92f3-4ca4af024ffc]
[INFO] List View Where Clause: (accounts.assigned_user_id in ('1') ) AND ( accounts.team_id in ('1'))

And this is the log where search is working (newly created account):

Code:

Sun Feb 27 08:40:36 2011 [945][88006fcb-e99c-f2f9-fdf0-4d1b814bd578]
[INFO] List View Where Clause: (accounts.assigned_user_id in ('1'))

So i guess the "AND ( accounts.team_id in ('1'))" is disabling the search for the old accounts (the team module is disabled if that is relevant).

I deleted table team_memberships and after that the search worked again