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

Error Reading Database - When logged in as admin unable to edit User Profile or retrieve logs after upgrade

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.1
    • None
    • Database SQL/XMLDB
    • Microsoft Server 2008
      Apache Web Server
      Microsoft SQL2005
    • Microsoft SQL
    • MOODLE_20_STABLE

    Description

      After upgrading from Final Release Candidate version to Moodle 2.0.1+ build:20110105 I am unable to access/edit user profile information. I am using external authentication stored in a different MSSQL DB. The following errors are displayed:

      Debug info: SQLState: 42000<br>
      Error Code: 8155<br>
      Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]No column was specified for column 1 of 'q'.<br>
      SQLState: 42000<br>
      Error Code: 8155<br>
      Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]No column was specified for column 2 of 'q'.<br>

      SELECT 1 FROM (SELECT TOP 9223372036854775806 ROW_NUMBER() OVER(ORDER BY 1) AS sqlsrvrownumber, 1 FROM (SELECT 1
      FROM mdl_role_assignments
      WHERE userid = '505' AND roleid IN (3)) AS q) AS q WHERE q.sqlsrvrownumber > 0 AND q.sqlsrvrownumber <= 1
      [array (
      0 => '505',
      )]
      Stack trace:
      line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
      line 252 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
      line 363 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
      line 761 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
      line 1553 of \lib\dml\moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
      line 825 of \lib\accesslib.php: call to moodle_database->record_exists_sql()
      line 3284 of \lib\navigationlib.php: call to has_coursecontact_role()
      line 3208 of \lib\navigationlib.php: call to settings_navigation->generate_user_settings()
      line 2583 of \lib\navigationlib.php: call to settings_navigation->load_user_settings()
      line 583 of \lib\pagelib.php: call to settings_navigation->initialise()
      line 599 of \lib\pagelib.php: call to moodle_page->magic_get_settingsnav()
      line 132 of \blocks\settings\block_settings.php: call to moodle_page->__get()
      line 279 of \blocks\moodleblock.class.php: call to block_settings->get_content()
      line 232 of \blocks\moodleblock.class.php: call to block_base->formatted_contents()
      line 895 of \lib\blocklib.php: call to block_base->get_content_for_output()
      line 947 of \lib\blocklib.php: call to block_manager->create_block_contents()
      line 342 of \lib\blocklib.php: call to block_manager->ensure_content_created()
      line 7 of \theme\elvis\layout\general.php: call to block_manager->region_has_content()
      line 647 of \lib\outputrenderers.php: call to include()
      line 605 of \lib\outputrenderers.php: call to core_renderer->render_page_layout()
      line 245 of \user\editadvanced.php: call to core_renderer->header()

      Attachments

        Issue Links

          Activity

            People

              poltawski Dan Poltawski
              richford Richard Ford
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: