Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.0.1
-
None
-
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
- duplicates
-
MDL-26458 [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'name'
-
- Closed
-