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

Support for Azure SQL Database

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Won't Do
    • Minor
    • None
    • 2.7
    • Installation
    • 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

              Unassigned Unassigned
              nebgor Aparup Banerjee
              Votes:
              3 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: