Appion

Break up the query. The search for projects containing viewable sessions by a user is much faster with the combination of the smaller query results using php code.

Testing:
1. Log in myamiweb as a user in the "users" group who may own a few projects and/or share a few sessions. Users in "administrators" group do not go through this query.

2. New code and old code should give the same project listing but the new code should be faster when there are many projects overall such as NRAMM databases.

Amber,
It is a database problem. It turns out some experiments were assigned to two projects. 04mar03a belongs to both projectId 5 and 44. Since your test user, as well as mine, owns project 44, the query in inc/leginon.inc (not changed by this bug fix) accepts the session. The query for session selector is rather strange. I think it is that way because of session finder. Don't see how the old getProjects could get around this problem.

I will create an AMI group issue on the database problem that need to be corrected.

Anchi, I shared my "user" self with a session in NRAMM - Installation Test (234).
When I look for the project in the viewer, it is not there, but the session that I share is in the session list. This seems to be the case with both 2.1.0 and the trunk, so I don't think this is a new problem, but it could be related. Any ideas?

It is another of duplicated session problem.

Session DEF_id 6818 and 6819 are both named 09jul08a. In the database 6818 is assigned to installation project while 6819, being an test session during development, has not project assigned. Some kind of mysql error occurred when project/inc/project.inc.php function getExperiments was performed so that it returns 6819.

I've patched up the database by making 6819 (3 images) not 6818 (with no images) is assigned to installation project so that it won't happen in this case.

Eric, do you know why?

I think we can close this out now. Duplicated session errors should be reported in a new issue.