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

                Attachments

                  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
                    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
                    Permalink
                    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
                    Permalink
                    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
                    Permalink
                    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