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

SQL related problem in user_bulk.php

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 1.9
    • 1.9
    • Administration
    • None
    • PostgreSQL 8.1.2, CVS HEAD
    • PostgreSQL
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

    Description

      When accessing admin/user/user_bulk.php the form in the bottom of the page (the lists of users) is empty and there are following SQL errors:

      ERROR: argument of NOT must be type boolean, not type integer

      SELECT COUNT FROM mdl_user WHERE id1 AND NOT deleted

      • line 679 of lib/dmllib.php: call to debugging()
      • line 374 of lib/dmllib.php: call to get_recordset_sql()
      • line 357 of lib/dmllib.php: call to count_records_sql()
      • line 70 of admin/user/user_bulk.php: call to count_records_select()

      ERROR: argument of NOT must be type boolean, not type integer

      SELECT id,firstname||' '||lastname AS fullname FROM mdl_user WHERE id1 AND NOT deleted ORDER BY fullname

      • line 679 of lib/dmllib.php: call to debugging()
      • line 603 of lib/dmllib.php: call to get_recordset_sql()
      • line 1016 of lib/dmllib.php: call to get_recordset_select()
      • line 168 of admin/user/user_bulk_form.php: call to get_records_select_menu()
      • line 131 of admin/user/user_bulk_form.php: call to user_bulk_form->getUserData()
      • line 74 of admin/user/user_bulk.php: call to user_bulk_form->setAvailableUsersSQL()

      Attachments

        Activity

          People

            poltawski Dan Poltawski
            mudrd8mz David Mudrák (@mudrd8mz)
            Nobody Nobody
            Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              3/Mar/08