Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-25657

Error reading from Database after filter query for all Managers

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

      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()

        Gliffy Diagrams

          Issue Links

            Activity

            Hide
            poltawski Dan Poltawski added a comment -

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

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

            Dan,

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

            thanks

            John

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

            Hi John,

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

            Show
            poltawski Dan Poltawski added a comment - Hi John, Yep - the fix will get reviewed and hopefully integrated into 2.0.2
            Hide
            skodak Petr Skoda added a comment -

            closing, thanks

            Show
            skodak Petr Skoda added a comment - closing, thanks

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  21/Feb/11