Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
3.0.3
-
MOODLE_30_STABLE
-
MOODLE_30_STABLE, MOODLE_31_STABLE
-
MDL-53425-master-delete-by-chunks -
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.
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
- has a non-specific relationship to
-
-
- Closed
-
-
MDL-53735 Split very large SQL-IN parameters to chunks
-
- Closed
-
- has been marked as being related by
-
-
- Open
-
- is a regression caused by
-
-
- Closed
-