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

              Assignee:
              samhemelryk Sam Hemelryk
              Reporter:
              andyjdavis Andrew Davis
              Peer reviewer:
              Dan Poltawski
              Integrator:
              Damyon Wiese
              Tester:
              Mark Nelson
              Participants:
              Component watchers:
              Matteo Scaramuccia, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón, Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

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