Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
3.9.2
-
None
-
Operating System: Debian Sarge
PHP Version: 4.4.3
Database and version: mysql 4.1.11
Browser (and version): mozilla firefox
Description
The pager at the session administration page on the administration interface is showing much more pages than there actually are. Thus when you select the "nth" page you get empty results.
The problem seems to be on kernel/setup/session.php where session_count is counting the total results and session_list has the results grouped by user.
For instance:
Select for session_count as generated by eZFetchActiveSessionCount:
SELECT count( * ) AS count FROM ezsession
Select for session_list as generated by eZFetchActiveSessions:
SELECT ezsession.user_id, max( ezsession.expiration_time ) as expiration_time, max(session_key) as session_key , count( ezsession.user_id ) AS count FROM ezsession, ezuser, ezcontentobject WHERE ezsession.user_id=ezuser.contentobject_id AND ezsession.user_id=ezcontentobject.id GROUP BY ezsession.user_id ORDER BY expiration_time DESC
Since session count has no "GROUP BY", count is much larger than actual result of session_list
Steps to reproduce
Log in to admin interface an browse to setup/session.
Select "everyone" on the users list and chech the box to include inactive users and refresh the list.
Select the second page on the pager menu at the bottom of the list and pager results come empty.
Attachments
Issue Links
- is duplicated by
-
EZP-8482 Session function is buggy
- Closed