Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3515

Database read error 306, Face to Face plugin

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.2.5
    • 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.

            aly Alastair Munro (Inactive)
            chris.watkins chris watkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.