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

Survey module install script hardcodes ids and relies on autoincrement=1

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.7.3, 2.8.1
    • Fix Version/s: None
    • Component/s: Survey
    • Labels:
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_27_STABLE, MOODLE_28_STABLE

      Description

      Survey module stores fixed question id in mdl_survey table (hard-coded in install.php) instead of storing dynamic question id from survey_questions table, due to that in case of cluster when questions are not in sequential order in mdl_survey_questions table questions are not displaying.

      To Reproduce.
      1) In MySQL my.ini add following line
      auto_increment_increment =3
      2) Restart MySQL and install Moodle.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            pinky Pinky Sharma
            Participants:
            Component watchers:
            Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: