-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.0, 3.3.3, 3.4, 3.5
-
Component/s: Database SQL/XMLDB
-
Environment:Windows Azure Guest OS 1.5 + SQL Azure
PHP 5.3.3
Native SQL Connector
-
Database:Microsoft SQL
-
Testing Instructions:
-
Affected Branches:MOODLE_20_STABLE, MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE
-
Fixed Branches:MOODLE_33_STABLE, MOODLE_34_STABLE
-
Pull from Repository:
-
Pull Master Branch:
MDL-23887-master-2 -
Pull Master Diff URL:
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.