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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Environment:
      Microsoft Server 2008
      Apache Web Server
      Microsoft SQL2005
    • Database:
      Microsoft SQL
    • Affected Branches:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: