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

Support for Azure SQL Database

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.7
    • Fix Version/s: None
    • Component/s: Installation
    • Labels:
    • Affected Branches:
      MOODLE_27_STABLE

      Description

      Installation

      System

      Error reading from database

      More information about this error

      It is usually not possible to recover from errors triggered during installation, you may need to create a new database or use a different database prefix if you want to retry the installation.

      Debug info: SQLState: 42S02<br>
      Error Code: 208<br>
      Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sysindexes'.<br>

      SELECT name
      FROM sysindexes
      WHERE lower(name) = N'mdl_conf_nam_uix'
      [array (
      0 => 'mdl_conf_nam_uix',
      )]
      Error code: dmlreadexception

      Stack trace: •line 443 of \lib\dml\moodle_database.php: dml_read_exception thrown
      •line 250 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
      •line 357 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
      •line 792 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
      •line 840 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
      •line 619 of \lib\ddl\mssql_sql_generator.php: call to sqlsrv_native_moodle_database->get_records_sql()
      •line 1097 of \lib\ddl\sql_generator.php: call to mssql_sql_generator->isNameInUse()
      •line 585 of \lib\ddl\mssql_sql_generator.php: call to sql_generator->getNameForObject()
      •line 432 of \lib\ddl\sql_generator.php: call to mssql_sql_generator->getNameForObject()
      •line 385 of \lib\ddl\sql_generator.php: call to sql_generator->getCreateIndexSQL()
      •line 248 of \lib\ddl\sql_generator.php: call to sql_generator->getCreateTableSQL()
      •line 409 of \lib\ddl\database_manager.php: call to sql_generator->getCreateStructureSQL()
      •line 364 of \lib\ddl\database_manager.php: call to database_manager->install_from_xmldb_structure()
      •line 1498 of \lib\upgradelib.php: call to database_manager->install_from_xmldb_file()
      •line 226 of \admin\index.php: call to install_core()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              nebgor Aparup Banerjee
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: