-
Bug
-
Resolution: Not a bug
-
Minor
-
None
-
2.0.3
-
None
-
My test machine setup:
- Moodle version 2.0.3+ (Build: 20110609)
- MS SQL 2005
- Microsoft SQL Server Driver for PHP 2.0.1802.200
- Windows XP SP3
- IIS 5.1
- PHP 5.3.3 NTS (MSVC9 x86) running under MS FastCGI
- Microsoft Windows Cache Extension for PHP 1.1.630.0
Moodle config:
$CFG->dbtype = 'sqlsrv';
$CFG->dblibrary = 'native';
My test machine setup: - Moodle version 2.0.3+ (Build: 20110609) - MS SQL 2005 - Microsoft SQL Server Driver for PHP 2.0.1802.200 - Windows XP SP3 - IIS 5.1 - PHP 5.3.3 NTS (MSVC9 x86) running under MS FastCGI - Microsoft Windows Cache Extension for PHP 1.1.630.0 Moodle config: $CFG->dbtype = 'sqlsrv'; $CFG->dblibrary = 'native';
-
Microsoft SQL
-
MOODLE_20_STABLE
-
I installed the Configurable Report block (CONTRIB-10753) on my Moodle 2.0.3+ (Build: 20110609) test machine. When I create a "Users Report" in that block I get a "ORDER BY items must appear in the select list if SELECT DISTINCT is specified" error. I reported this error in CONTRIB-3204. Juan Leyva, the CONTRIB-10753 maintainer, looked at the report and concluded that "the bug is located in the function get_role_users that is a core function of Moodle", so I'm reporting it here again - I'm not sure what the actual problem in get_role_users is though...
- has been marked as being related by
-
CONTRIB-3204 "Error reading from database" when creating a Users Report under MSSQL 2005
-
- Closed
-