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

Exception thrown at insert table adminpresets_it

XMLWordPrintable

    • MOODLE_400_STABLE
    • MOODLE_400_STABLE
    • MDL-73953-master
    • Hide

      Testing creation in English

      1. Create a new Moodle Moodle 4.0dev+ (Build: 20220211) site based on d24a4ab56fe595bb1dd7b0af599e576440e0b68a commit.
      2. As admin go to Site administration > Language > Language packs and install 'Dutch / Nederlands ‎(nl)‎‎' language package
      3. Go to Site administration > Language > Language settings
      4. Disable 'Language autodetect' and set 'Default language' to 'Nederlands (nl)' and Save changes
      5. Go to User preferences > Preferred language, select Nederlands (nl) and Save changes.
      6. Update to latest.
      7. Confirm the process finishes with no errors.
      8. Go to User preferences > Preferred language, select English (en) and Save changes.
      9. Go to Site administration > Site admin presets
      10. Confirm there is a preset called 'Beginner' and another one called 'Vol'. 
      11. Confirm description of both presets is on Dutch.

      Testing creation in a non-english language

      1. Create a new 3.11 Moodle site.
      2. As admin go to Site administration > Language > Language packs and install 'French / Français ‎(fr)‎‎' language package
      3. Go to Site administration > Language > Language settings
      4. Disable 'Language autodetect' and set 'Default language' to 'Français (fr)' and Save changes
      5. Go to User preferences > Preferred language, select Français (fr) and Save changes.
      6. Update to e78184d8271cbff1d938b787fc256d999e1d6603 commit.
      7. Confirm the process finishes with no errors.
      8. (You could change to English if you feel more comfortable)
      9. Go to "Site administration > Plugins > Manage blocks".
      10. Disable the following blocks:
        1. Course summary
        2. Feedback
        3. Remote RSS feeds
        4. Self completion
      11. Go to Site administration > Site admin presets.
      12. Confirm there are 2 admin presets: 'Débutant' and 'Complet' 
      13. Choose 'Review settings and apply' on 'Complet' preset Action menu.
      14. Click on 'Apply' and after that on 'Conitnue'.
      15. Go to Site administration > Language > Language packs and install 'Dutch / Nederlands ‎(nl)‎‎' language package
      16. Go to User preferences > Preferred language, select Nederlands (nl) and Save changes.
      17. Update to latest.
      18. Confirm the process finishes with no errors.
      19. (You could change to English if you feel more comfortable)
      20. Go to "Site administration > Plugins > Manage blocks".
      21. Confirm following blocks are disabled:
        1. Course summary
        2. Feedback
        3. Remote RSS feeds
        4. Self completion
      22. Go to Site administration > Site admin presets
      23. Confirm there is a preset called 'Beginner' and another one called 'Vol'. 
      24. Confirm description of both presets is on Dutch.
      25. Open 'Von' preset's Action menu and choose 'Show version history'. You might need to scroll to the bottom to see all menu options.
      26. Restore the version.
      27. Click on 'Continue'
      28. Go to "Site administration > Plugins > Manage blocks".
      29. Confirm the following blocks are still disabled:
        1. Course summary
        2. Feedback
        3. Remote RSS feeds
        4. Self completion

      Upgrading straight to 4.0

      1. Create a new 3.11 Moodle site.
      2. Update to latest.
      3. Confirm the process finishes with no errors.
      4. Go to "Site administration > Plugins > Manage blocks".
      5. Confirm following blocks are disabled:
        1. Course summary
        2. Feedback
        3. Remote RSS feeds
        4. Self completion
      Show
      Testing creation in English Create a new Moodle Moodle   4.0dev+ (Build: 20220211) site based on d24a4ab56fe595bb1dd7b0af599e576440e0b68a commit. As admin go to Site administration > Language > Language packs and install 'Dutch / Nederlands ‎(nl)‎‎' language package Go to Site administration > Language > Language settings Disable 'Language autodetect' and set 'Default language' to 'Nederlands (nl)' and Save changes Go to User preferences > Preferred language, select Nederlands (nl) and Save changes. Update to latest. Confirm the process finishes with no errors. Go to User preferences > Preferred language, select English (en) and Save changes. Go to Site administration > Site admin presets Confirm there is a preset called 'Beginner' and another one called 'Vol'.  Confirm description of both presets is on Dutch. Testing creation in a non-english language Create a new 3.11 Moodle site. As admin go to Site administration > Language > Language packs and install 'French / Français ‎(fr)‎‎' language package Go to Site administration > Language > Language settings Disable 'Language autodetect' and set 'Default language' to 'Français (fr)' and Save changes Go to User preferences > Preferred language, select Français (fr) and Save changes. Update to e78184d8271cbff1d938b787fc256d999e1d6603 commit. Confirm the process finishes with no errors. (You could change to English if you feel more comfortable) Go to "Site administration > Plugins > Manage blocks". Disable the following blocks: Course summary Feedback Remote RSS feeds Self completion Go to Site administration > Site admin presets. Confirm there are 2 admin presets: 'Débutant' and 'Complet'  Choose 'Review settings and apply' on 'Complet' preset Action menu. Click on 'Apply' and after that on 'Conitnue'. Go to Site administration > Language > Language packs and install 'Dutch / Nederlands ‎(nl)‎‎' language package Go to User preferences > Preferred language, select Nederlands (nl) and Save changes. Update to latest. Confirm the process finishes with no errors. (You could change to English if you feel more comfortable) Go to "Site administration > Plugins > Manage blocks". Confirm following blocks are disabled: Course summary Feedback Remote RSS feeds Self completion Go to Site administration > Site admin presets Confirm there is a preset called 'Beginner' and another one called 'Vol'.  Confirm description of both presets is on Dutch. Open 'Von' preset's Action menu and choose 'Show version history'. You might need to scroll to the bottom to see all menu options. Restore the version. Click on 'Continue' Go to "Site administration > Plugins > Manage blocks". Confirm  the following blocks are still disabled: Course summary Feedback Remote RSS feeds Self completion Upgrading straight to 4.0 Create a new 3.11 Moodle site. Update to latest. Confirm the process finishes with no errors. Go to "Site administration > Plugins > Manage blocks". Confirm following blocks are disabled: Course summary Feedback Remote RSS feeds Self completion
    • Moppies Kanban

      While upgrading Moodle 4.0dev+ (Build: 20220211) with the latest build, I got this error and the upgrade stopped:

      Default exception handler: Fout bij het schrijven van de databank Debug: Column 'adminpresetid' cannot be null
      INSERT INTO adminpresets_it (adminpresetid,plugin,name,value) VALUES(?,?,?,?)
      [array (
        0 => NULL,
        1 => 'none',
        2 => 'guestloginbutton',
        3 => '0',
      )]
      Error code: dmlwriteexception

      • line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 1357 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1403 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
      • line 4008 of /lib/db/upgrade.php: call to mysqli_native_moodle_database->insert_record()
      • line 1875 of /lib/upgradelib.php: call to xmldb_main_upgrade()
      • line 196 of /admin/cli/upgrade.php: call to upgrade_core()

        1. image-2022-02-21-15-17-28-505.png
          15 kB
          Gemma Lesterhuis
        2. MDL-73953 - Testing creation in a non-english language - Step 18.png
          22 kB
          Carlos Escobedo
        3. MDL-73953 - Upgrading straight to 4.0 - Step 5.png
          90 kB
          Carlos Escobedo
        4. MDL-73953 - Testing creation in a non-english language - Step 12.png
          53 kB
          Carlos Escobedo
        5. MDL-73953 - Testing creation in a non-english language - Step 21.png
          85 kB
          Carlos Escobedo
        6. MDL-73953 - Testing creation in a non-english language - Step 23 and 24.png
          46 kB
          Carlos Escobedo
        7. MDL-73953 - Testing creation in a non-english language - Step 29.png
          87 kB
          Carlos Escobedo
        8. MDL-73953 - Testing creation in a non-english language - Step 7 confirmed.png
          73 kB
          Carlos Escobedo
        9. MDL-73953 - Testing creation in a non-english language - Step 7 confirmed2.png
          16 kB
          Carlos Escobedo
        10. MDL-73953 - Testing creation in english - Step 7 confirmed.png
          23 kB
          Carlos Escobedo
        11. MDL-73953 - Testing creation in english - Steps 10 and 11 confirmed.png
          53 kB
          Carlos Escobedo
        12. MDL-73953 - Upgrading straight to 4.0 - Step 3_1.png
          68 kB
          Carlos Escobedo
        13. MDL-73953 - Upgrading straight to 4.0 - Step 3_2.png
          131 kB
          Carlos Escobedo
        14. MDL-73953 - Testing creation in a non-english language - Step 21-1.png
          85 kB
          Carlos Escobedo

            amaia Amaia Anabitarte
            alainraap Alain Raap
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Carlos Escobedo Carlos Escobedo
            Votes:
            2 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 days, 6 hours, 55 minutes
                2d 6h 55m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.