[19-Apr-2011 16:15:11] sqlsrv_query: SQLSTATE = 42000
[19-Apr-2011 16:15:11] sqlsrv_query: error code = 8156
[19-Apr-2011 16:15:11] sqlsrv_query: message = [Microsoft][SQL Server Native Client 10.0][SQL Server]The column 'contenthash' was specified multiple times for 'q'.
[19-Apr-2011 16:15:11] sqlsrv_query: SQLSTATE = 42000
[19-Apr-2011 16:15:11] sqlsrv_query: error code = 8156
[19-Apr-2011 16:15:11] sqlsrv_query: message = [Microsoft][SQL Server Native Client 10.0][SQL Server]The column 'contenthash' was specified multiple times for 'q'.
[19-Apr-2011 16:15:11] Default exception handler: Error reading from database Debug: SQLState: 42000<br>
Error Code: 8156<br>

                       Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The column 'contenthash' was specified multiple times for 'q'.<br>

                       SQLState: 42000<br>
                       
Error Code: 8156<br>
                       
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The column 'contenthash' was specified multiple times for 'q'.<br>


                SELECT q.* FROM (SELECT TOP 9223372036854775806 ROW_NUMBER() OVER(ORDER BY timemodified DESC) AS sqlsrvrownumber, 
                       q.* FROM (SELECT * FROM mdl_files files1
                JOIN (SELECT contenthash, filename, MAX(id) AS id
                FROM mdl_files
                WHERE userid = '3' AND filename != N'.' AND ((filearea = N'draft' AND itemid = '903717041') OR filearea != N'draft')
                GROUP BY contenthash, filename) files2 ON files1.id = files2.id
                ) AS q) AS q WHERE q.sqlsrvrownumber > 0 AND q.sqlsrvrownumber <= 50

[array (
  0 => '3',
  1 => '.',
  2 => 'draft',
  3 => 903717041,
  4 => 'draft',
)]

* line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown

* line 252 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()

* line 363 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()

* line 761 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()

* line 66 of \repository\recent\lib.php: call to sqlsrv_native_moodle_database->get_recordset_sql()

* line 96 of \repository\recent\lib.php: call to repository_recent->get_recent_files()

* line 140 of \repository\repository_ajax.php: call to repository_recent->get_listing()