-
Bug
-
Resolution: Fixed
-
Minor
-
2.1.2
-
None
-
None
-
Windows
-
Microsoft SQL
-
MOODLE_21_STABLE
-
MOODLE_22_STABLE
Created 3 face to face sessions in an orientation program
Logging on with regular userid and selecting the 'Attendees' link for the first session gives the following error dump: this occurrs on any attempt to view attendees (whether attending or not)
Error reading from database
More information about this error
Debug info: SQLState: 42000<br>
Error Code: 306<br>
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.<br>
Problem with Select statement because it tries to Group on a number of fields including "mdl_facetoface_signups_status.note" which is a 'nText' and this field is too large for grouping.