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

Table installation doesn't occur if reinstalling a Moodle site

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.4.1
    • Fix Version/s: 2.4.2
    • Component/s: Caching, Installation
    • Labels:
    • Testing Instructions:
      Hide

      Functionality tests (2.4 and master).

      1. Run unit tests
      2. Browse around your site and make sure that things continue to work exactly as they did before.

      Installation tests (2.4 and master).

      1. Install a fresh site through your browser (without a config.php file)
      2. Create a course.
      3. Delete all your database tables
      4. Browse to the front page and proceed through the installation again.
      5. Delete your database tables, your moodle data and your config file.
      6. Install again but through CLI this time.
      7. In your browser create a course and browse to it.
      8. Delete your database tables.
      9. Run the CLI script to install the database.
      10. Browse your site to make sure things work.

      Upgrade tests.

      1. Install a 2.3 site
      2. Create a few courses, users, and forum posts.
      3. Upgrade it to Moodle 2.4.
      4. Browse around the site and just check things are as they were.
      5. Upgrade it to master.
      6. Browse around again.
      Show
      Functionality tests (2.4 and master). Run unit tests Browse around your site and make sure that things continue to work exactly as they did before. Installation tests (2.4 and master). Install a fresh site through your browser (without a config.php file) Create a course. Delete all your database tables Browse to the front page and proceed through the installation again. Delete your database tables, your moodle data and your config file. Install again but through CLI this time. In your browser create a course and browse to it. Delete your database tables. Run the CLI script to install the database. Browse your site to make sure things work. Upgrade tests. Install a 2.3 site Create a few courses, users, and forum posts. Upgrade it to Moodle 2.4. Browse around the site and just check things are as they were. Upgrade it to master. Browse around again.
    • Affected Branches:
      MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_24_STABLE
    • Pull Master Branch:
      wip-MDL-37683-m25

      Description

      If you remove your config.php then visit the site, installation starts. Instead of installing the tables it fails part way through complaining of a missing table.

      I dropped the existing schema, created a new schema with a slightly different name and renamed config.php. when I visit the site in the browser, as there is no config.php, it puts me through the installation process. However after Ive entered the database details instead of creating the tables it gives me the following.

      Table "context" does not exist Debug info:
      Error code: ddltablenotexistStack trace: line 538 of /lib/dml/moodle_database.php: dml_exception thrownline 1332 of /lib/dml/moodle_database.php: call to moodle_database->where_clause()line 5910 of /lib/accesslib.php: call to moodle_database->get_record()line 7170 of /lib/accesslib.php: call to context_system::instance()line 657 of /lib/setup.php: call to get_system_context()line 27 of /config.php: call to require_once()line 50 of /admin/index.php: call to require()

      Deleting the cache directory from moodle data resolved this. Installation now appears to be working correctly.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  11/Mar/13