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

[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'name'

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 2.0.1
    • 2.0.3
    • Database SQL/XMLDB
    • Microsoft SQL
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE
    • Moderate

    Description

      Debug info: SQLState: 42S22<br>
      Error Code: 207<br>
      Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'name'.<br>

      SELECT q.* FROM (SELECT TOP 9223372036854775806 ROW_NUMBER() OVER(ORDER BY name, concept) AS sqlsrvrownumber, q.* FROM ( SELECT gec.id AS cid, ge.*, gec.entryid, gc.name AS glossarypivot FROM mdl_glossary_entries ge,
      mdl_glossary_entries_categories gec,
      mdl_glossary_categories gc WHERE (ge.glossaryid = '1' OR ge.sourceglossaryid = '1') AND
      ge.id = gec.entryid AND gc.id = gec.categoryid AND
      (ge.approved <> 0 OR ge.userid = '4') ) AS q) AS q WHERE q.sqlsrvrownumber > 0 AND q.sqlsrvrownumber <= 10
      [array (
      0 => '1',
      1 => '1',
      2 => '4',
      )]
      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 899 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
      line 276 of \mod\glossary\sql.php: call to sqlsrv_native_moodle_database->get_records_sql()
      line 371 of \mod\glossary\view.php: call to require()

      Attachments

        Issue Links

          Activity

            People

              nebgor Aparup Banerjee
              nebgor Aparup Banerjee
              David Mudrák (@mudrd8mz) David Mudrák (@mudrd8mz)
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                5/May/11