Moodle
  1. Moodle
  2. MDL-11767

SQL related problem in user_bulk.php

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Component/s: Administration
    • Labels:
      None
    • Environment:
      PostgreSQL 8.1.2, CVS HEAD
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE
    • Rank:
      30070

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

        Activity

        Hide
        Dan Poltawski added a comment -

        Hi this should be fixed in CVS

        Show
        Dan Poltawski added a comment - Hi this should be fixed in CVS

          People

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

            Dates

            • Created:
              Updated:
              Resolved: