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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: 2.0.3
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Database:
      Microsoft SQL
    • Difficulty:
      Moderate
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      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()

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    5/May/11