Urgent issue: Excessive duplicate data getting entered into the table "mdl_adobeconnect_quiz_attempts"

Urgent issue: Excessive duplicate data getting entered into the table "mdl_adobeconnect_quiz_attempts"

de Brian Lee -
Número de respuestas: 4

This is an urgent issue because it affects disk space and web performance. My employer (online university) is experiencing excessive duplicate data getting entered into the table "mdl_adobeconnect_quiz_attempts" in our Moodle database. For instance, I saw that there were almost 300 rows of duplicate data showing a user having watched an Adobe Connect activity for 61 minutes in the table. Anyone else experiencing the same issue? Thank you.

Promedio de valoraciones: -
En respuesta a Brian Lee

Re: Urgent issue: Excessive duplicate data getting entered into the table "mdl_adobeconnect_quiz_attempts"

de Tyler Bannister -
Hi Brian, do you know what plugin that table came from?  I did a quick Google search and no results were found for that table name, it's not from the Adobe Connect module. 
En respuesta a Tyler Bannister

Re: Urgent issue: Excessive duplicate data getting entered into the table "mdl_adobeconnect_quiz_attempts"

de Brian Lee -

The table "mdl_adobeconnect_quiz_attempts" came from the Adobe Connect plugin created by Remote Learner. The single-sign on feature is fine, as well as everything else. However, there is too much data getting populated in the "mdl_adobeconnect_quiz_attempts" table. For one instance of a user watching a recording by clicking an Adobe Connect activity, the plugin somehow enters hundreds of duplicate rows. I do not know how and when this happens, exactly, and I was wondering if anyone else experienced the same issue. If so, do we have a solution?

En respuesta a Tyler Bannister

Re: Urgent issue: Excessive duplicate data getting entered into the table "mdl_adobeconnect_quiz_attempts"

de Brian Lee -
The following screenshot shows my MySQL query of the "mdl_adobeconnect_quiz_attempts" table:

MySQL query of mdl_adobeconnect_quiz_attempts table

As you can see, there are so many duplicates of one row of data.
En respuesta a Tyler Bannister

Re: Urgent issue: Excessive duplicate data getting entered into the table "mdl_adobeconnect_quiz_attempts"

de Brian Lee -

Tyler, I apologize. As I have said on the Adobe Connect activity plugin page, the plugin that was installed in our system was created by Envisiontel. I am not sure why my hosting provider or someone else installed it in our system. Here is the link to the Adobe Connect activity module source code written by Envisiontel. Notice if you access the file "Envisiontel-mod_adobeconnect/lib.php", you can see that there is the function "adobeconnect_update_quiz_attempts", which does not exist in Remote Learner's version of the Adobe Connect activity plugin. I am going to contact my hosting provider about this. Thank you.