-
Bug
-
Resolution: Fixed
-
Major
-
2.0, 3.3.3, 3.4, 3.5
-
Windows Azure Guest OS 1.5 + SQL Azure
PHP 5.3.3
Native SQL Connector
-
Microsoft SQL
-
MOODLE_20_STABLE, MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE
-
MOODLE_33_STABLE, MOODLE_34_STABLE
-
MDL-23887-master-2 -
While installing Moodle using SQL Azure, you get a "dmlreadexception".
Tracking down this error, I found that some queries on lib/ddl/mssql_sql_generator.php uses System Tables, which was deprecated on SQL Server 2005. It works correctly on SQL Server 2008 R2, but it seems Microsoft removed System Tables support on SQLAzure version.
I changed the queries to use System Views, according to this documentation on MSDN <http://msdn.microsoft.com/en-us/library/ms187997.aspx>, it worked, but I don't know if it will work as expected by other modules, as I am not a T-SQL expert.
The patch I have created is attached.