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

          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

              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 Skoda added a comment -

                closing, thanks

                Show
                Petr Skoda added a comment - closing, thanks

                  People

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

                    Dates

                    • Created:
                      Updated:
                      Resolved: