Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-43283

Error reading from database after leaving Chat activity

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.6, 2.7
    • Fix Version/s: 2.6.1
    • Component/s: Chat, Course
    • Labels:
    • Testing Instructions:
      Hide

      For testing you need Oracle, MSSQL or some versions of Postgres DB. Before testing make sure that query "select * from mdl_user group by id" results in error on your DB.

      1. Create a course and add a recent activity block if not present
      2. Create a chat activity
      3. Open a chat and say something
      4. Return to the course and make sure that your name appears in recent activity under this chat.

      Test this also with alternative names settings

      Show
      For testing you need Oracle, MSSQL or some versions of Postgres DB. Before testing make sure that query "select * from mdl_user group by id" results in error on your DB. Create a course and add a recent activity block if not present Create a chat activity Open a chat and say something Return to the course and make sure that your name appears in recent activity under this chat. Test this also with alternative names settings
    • Affected Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE
    • Pull Master Branch:
      wip-MDL-43283-master
    • Sprint:
      BACKEND Sprint 9

      Description

      We appear to have identified an issue causing a dmlreadexception error for a course, after the user has entered a chat within that course.

      Steps to reproduce:
      Login, browse to course with Chat activity
      Browse to Chat activity and go to 'Click here to enter the chat now'
      Attempt to browse to the original course, either via the breadcrumbs, or via a new window/tab. Browsing elsewhere (outside of the course) appears unaffected.

      Expected behaviour would be to return to the course.
      Actual behaviour is an error message:
      Past chat sessions:
      10 Dec, 10:02
      Test Chat
      Active chat sessions:
      Error reading from database

      Logging out of Moodle appears to clear the error, until the user enters the chat again.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marina Marina Glancy
              Reporter:
              walkda Daryl Walkenhorst
              Peer reviewer:
              Eloy Lafuente (stronk7)
              Integrator:
              Eloy Lafuente (stronk7)
              Tester:
              Eloy Lafuente (stronk7)
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                13/Jan/14