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

Unable to reset Dashboard for all users - postgres fails if number of parameters over 65535

    XMLWordPrintable

Details

    • MOODLE_30_STABLE
    • MOODLE_30_STABLE, MOODLE_31_STABLE
    • MDL-53425-master-delete-by-chunks
    • Hide
      Setup
      1. Edit PHP's memory limit to at least 2048M (just to be sure the generator script that we will run won't crash :s).
      2. Set up a fresh Moodle installation.
      3. Copy the attached files dashboard_generator_cli.php and check_data.php to your Moodle root directory.
      4. Open a terminal and cd to your moodle's root directory.
      5. Execute php check_data.php and take note of the values for my_pages, block_positions, block_instances and block-related user preference records.
      6. Execute php dashboard_generator_cli.php. (This will take a while)
      7. Execute php check_data.php and take note of the values for my_pages, block_positions, block_instances and block-related user preference records.
      Testing proper
      1. Login as admin.
      2. Go to Site administration ► Appearance ► Default Dashboard page
      3. Click Reset Dashboard for all users. (This might also take a while)
        • Confirm that the process finishes normally and without any errors.
      4. Execute php check_data.php and take note of the values for my_pages, block_positions, block_instances and block-related user preference records.
        • Confirm that these are now the same with the values that were retrieved on check_data's first run.
      Show
      Setup Edit PHP's memory limit to at least 2048M (just to be sure the generator script that we will run won't crash :s). Set up a fresh Moodle installation. Copy the attached files dashboard_generator_cli.php and check_data.php to your Moodle root directory. Open a terminal and cd to your moodle's root directory. Execute php check_data.php and take note of the values for my_pages, block_positions, block_instances and block-related user preference records. Execute php dashboard_generator_cli.php . (This will take a while) Execute php check_data.php and take note of the values for my_pages, block_positions, block_instances and block-related user preference records. Testing proper Login as admin. Go to Site administration ► Appearance ► Default Dashboard page Click Reset Dashboard for all users . (This might also take a while) Confirm that the process finishes normally and without any errors. Execute php check_data.php and take note of the values for my_pages, block_positions, block_instances and block-related user preference records. Confirm that these are now the same with the values that were retrieved on check_data's first run.
    • 3.1 Sprint 7, 3.2 Sprint 1
    • Large

    Description

      Whenever I try to reset Dashboard for all users I got this error message:

      -------------------
      Debug info: number of parameters must be between 0 and 65535
      DELETE FROM mdl_user_preferences WHERE name IN ($1,$2,$3,$4,$5,$6,$7,
      ...
      76243 => 'docked_block_instance_44065',
      76244 => 'block44066hidden',
      76245 => 'docked_block_instance_44066',
      )]
      Error code: dmlwriteexception
      -------------------

      Stack trace:

      line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
      line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      line 1287 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      line 1847 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->delete_records_select()
      line 2078 of /lib/blocklib.php: call to moodle_database->delete_records_list()
      line 177 of /my/lib.php: call to blocks_delete_instances()
      line 52 of /my/indexsys.php: call to my_reset_page_for_all_users()

      Attachments

        Issue Links

          Activity

            People

              jpataleta Jun Pataleta
              caiado Ricardo Caiado
              Ryan Wyllie Ryan Wyllie
              David Monllaó David Monllaó
              Simey Lameze Simey Lameze
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                23/May/16