Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-10837

Paging error in setup/session

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium 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

        Activity

          People

            unknown unknown
            abeto abeto
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: