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

5 mysterious surveys created

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.6.4, 1.7, 1.7.1, 1.8, 1.9
    • Fix Version/s: 1.6.5, 1.7.2, 1.8, 1.9
    • Component/s: Administration, Survey
    • Labels:
      None
    • Affected Branches:
      MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      When you look at the Admin=>Modules (Activities in 1.7 and on) you see that the count of Surveys is 5 when no surveys have been created anywhere on the site. This is the case with a completely new site. Checking the database shows that they have a course id of 0. I guess that these may be created for a reason, but in that case they should not form part of the count.

      SQL dump as follows....

      mysql> select * from mdl_survey\G

                                                          • 1. row ***************************
                                                            id: 1
                                                            course: 0
                                                            template: 0
                                                            days: 0
                                                            timecreated: 985017600
                                                            timemodified: 985017600
                                                            name: collesaname
                                                            intro: collesaintro
                                                            questions: 25,26,27,28,29,30,43,44
                                                          • 2. row ***************************
                                                            id: 2
                                                            course: 0
                                                            template: 0
                                                            days: 0
                                                            timecreated: 985017600
                                                            timemodified: 985017600
                                                            name: collespname
                                                            intro: collespintro
                                                            questions: 31,32,33,34,35,36,43,44
                                                          • 3. row ***************************
                                                            id: 3
                                                            course: 0
                                                            template: 0
                                                            days: 0
                                                            timecreated: 985017600
                                                            timemodified: 985017600
                                                            name: collesapname
                                                            intro: collesapintro
                                                            questions: 37,38,39,40,41,42,43,44
                                                          • 4. row ***************************
                                                            id: 4
                                                            course: 0
                                                            template: 0
                                                            days: 0
                                                            timecreated: 985017600
                                                            timemodified: 985017600
                                                            name: attlsname
                                                            intro: attlsintro
                                                            questions: 65,67,68
                                                          • 5. row ***************************
                                                            id: 5
                                                            course: 0
                                                            template: 0
                                                            days: 0
                                                            timecreated: 985017600
                                                            timemodified: 985017600
                                                            name: ciqname
                                                            intro: ciqintro
                                                            questions: 69,70,71,72,73
                                                            5 rows in set (0.00 sec)

        Attachments

          Activity

            People

            • Assignee:
              howardsmiller Howard Miller
              Reporter:
              howardsmiller Howard Miller
              Participants:
              Component watchers:
              Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                30/Mar/07