Moodle
  1. Moodle
  2. MDL-25657

Error reading from Database after filter query for all Managers

        Details

        • Type: Bug Bug
        • Status: Closed
        • Priority: Major Major
        • Resolution: Fixed
        • Affects Version/s: 2.0
        • Fix Version/s: 2.0.2
        • Component/s: Administration
        • Labels:
          None
        • Environment:
          Running MAMP on Leopard 10.5 server.
          Database copied from a 1.9 install and then upgraded to 2.0
        • Database:
          MySQL
        • Affected Branches:
          MOODLE_20_STABLE
        • Fixed Branches:
          MOODLE_20_STABLE
        • Rank:
          15266

          Description

          Debug info: Unknown column 'a.timestart' in 'where clause'
          SELECT id, username, email, firstname, lastname, city, country, lastaccess, confirmed, mnethostid
          FROM mdl_user
          WHERE deleted <> 1 AND id IN (SELECT userid
          FROM mdl_role_assignments a
          WHERE a.contextid=1 AND a.roleid=1 AND a.timestart<1292251076
          AND (a.timeend=0 OR a.timeend>1292251076))
          ORDER BY firstname ASC LIMIT 0, 30
          [array (
          )]
          Stack trace:

          • line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
          • line 759 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
          • line 296 of /lib/datalib.php: call to mysqli_native_moodle_database->get_records_sql()
          • line 150 of /admin/user.php: call to get_users_listing()

            Issue Links

            is duplicated by

            Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-24086 Error reading from database when user bulk action or browse

            • Major - Major loss of function, incorrect output
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              Dan Poltawski added a comment -

              Thanks for the report. I've fixed this and requested a merge upstream in PULL-63

              Show
              Dan Poltawski added a comment - Thanks for the report. I've fixed this and requested a merge upstream in PULL-63
              Hide
              Permalink
              John Mansel-Pleydell added a comment -

              Dan,

              Assuming I must wait for 2.02 for this to be included?

              thanks

              John

              Show
              John Mansel-Pleydell added a comment - Dan, Assuming I must wait for 2.02 for this to be included? thanks John
              Hide
              Permalink
              Dan Poltawski added a comment -

              Hi John,

              Yep - the fix will get reviewed and hopefully integrated into 2.0.2

              Show
              Dan Poltawski added a comment - Hi John, Yep - the fix will get reviewed and hopefully integrated into 2.0.2
              Hide
              Permalink
              Petr Škoda added a comment -

              closing, thanks

              Show
              Petr Škoda added a comment - closing, thanks

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: