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

site registration - Error reading from database

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.3.1
    • Fix Version/s: 2.3.2
    • Component/s: Administration
    • Labels:

      Description

      Cannot register site. Site is in subdirectory, when I click on registration I am taken to Wordpress installation in main directory. When I click the "site not registered" button I get the following debugging details:

      More information about this error
       
      Debug info: Every derived table must have its own alias
      SELECT COUNT(*) FROM (
      SELECT DISTINCT ue.userid, e.courseid
      FROM mdl_user_enrolments ue, mdl_enrol e, mdl_course c
      WHERE ue.enrolid = e.id
      AND e.courseid <> ?
      AND c.id = e.courseid
      AND c.visible = 1)
      [array (
      0 => '1',
      )]
      Error code: dmlreadexception
      Stack trace:
      line 407 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 944 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1346 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
      line 1419 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      line 1590 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      line 4044 of /course/lib.php: call to moodle_database->count_records_sql()
      line 373 of /admin/registration/forms.php: call to average_number_of_participants()
      line 194 of /lib/formslib.php: call to site_registration_form->definition()
      line 61 of /admin/registration/register.php: call to moodleform->moodleform()

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    10/Sep/12