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

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

XMLWordPrintable

    • Microsoft SQL
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE
    • Moderate

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

            nebgor Aparup Banerjee
            nebgor Aparup Banerjee
            David Mudrák (@mudrd8mz) David Mudrák (@mudrd8mz)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.