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

          Activity

          Hide
          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
          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
          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
          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: