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

Glossary database error after lots of recent activity

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.3
    • 2.3
    • Glossary
    • MOODLE_23_STABLE
    • MOODLE_23_STABLE
    • MDL-33821-master-1
    • Hide

      There are several ways of doing this - the easy way, the other mostly easy way, or the insane way.

      Easy way:

      • Open /mod/glossary/lib.php
        • change the GLOSSARY_RECENT_ACTIVITY_LIMIT to something very low, like 1

      Mostly easy way:

      Hard way:

      • Create at least 50 glossary entries in 5 minutes

      General Procedure

      • Open a course
        • Ensure that the Recent activity block is shown
      • Create a new glossary
      • Create lots of entries (At least GLOSSARY_RECENT_ACTIVITY_LIMIT)
      • View the course page
        • Confirm no errors were shown
      Show
      There are several ways of doing this - the easy way, the other mostly easy way, or the insane way. Easy way: Open /mod/glossary/lib.php change the GLOSSARY_RECENT_ACTIVITY_LIMIT to something very low, like 1 Mostly easy way: Take an existing glossary with at least 50 entries and export them (or use http://moodle.org/pluginfile.php/855/mod_glossary/attachment/6031/texfilter_glossary_en.xml ) Import them into a new glossary Hard way: Create at least 50 glossary entries in 5 minutes General Procedure Open a course Ensure that the Recent activity block is shown Create a new glossary Create lots of entries (At least GLOSSARY_RECENT_ACTIVITY_LIMIT) View the course page Confirm no errors were shown

    Description

      Just been adding glossary support to the jmeter load testing scripts. In doing so, I'm obviously generating quite a few glossary entries in a short space of time. As a result, I've hit a bug in glossary_print_recent_activity() with an invalid SQL query.

      Attachments

        Issue Links

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-22970 Glossary import displays too many items in recent activity

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed
          is a regression caused by

          Improvement - An enhancement to an existing Moodle feature. MDL-30482 Capability for viewing glossary entries

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-33707 After importing terms to glossary course page shows a database error

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              dobedobedoh Andrew Lyons
              dobedobedoh Andrew Lyons
              Jason Fowler Jason Fowler
              Dan Poltawski Dan Poltawski
              Ankit Agarwal Ankit Agarwal
              Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                25/Jun/12