Hi there, been working on this for days, I can't seem to bring up activity results for anything quiz or assignment related when looking at course/activity.
I've checked to make sure the quizzes and assignments are associated with the course and they are.
Course activities seem to work and I can even confirm that the scope and filter for the ajax request is correct when using the dropdown to select 'Quiz evaluated'.
Looked in the DB to see where the bp_activity links quiz_evaluated to a course but can't find it.
Any advice would be appreciated
Tried to test it on my stock WPLMS install but that is full of bugs to a failed one click setup.
Please share what bugs you're facing on install, there are no bugs on fresh install otherwise the theme would be disabled.
The quiz and assignment functions would only work where the quiz/assignment is connected to the course. This does not give accurate results but it will be fixed in the coming update as the query for this will be updated.
Here's where I'm having issues with one click install...
https://wplms.io/support/forums/topic/one-click-media-media-import-fails/#post-40452
As for the new query is there any way to share it with me and tell me where to put it so I can fix it manually for now?
Thanks
You need to delete those questions manually form the quiz .
This is an import error for sure but we are working on it get it fixed .
Have you checked that the actual activity is recorded for the quiz evaluation from the activity directory page ?
Coz this is working on my test setup when i checked :
http://prntscr.com/aq3g1i
The quiz data is not currently showing at all but I can confirm it exists in the database (table: bp_activity, see screenshot). Where is the linkage between these entries and a course ID? I would have guessed secondary_item_id (as item_id points to the quiz ID) but secondary _item_id is all set to 0.
I made some console logs of the data getting sent to admin-ajax if that helps...
Selecting Everything (no quiz/assignments):
- bp_ajax_request = http://learndianelee.staging.wpengine.com/wp-admin/admin-ajax.php
- action: activity_widget_filter
- cookie:
- bp--scope=all
- bp-edit-scope=all
- bp-admin-scope=all
- bp-curriculum-scope=all
- bp-activity-scope=course_5674
- bp-activity-filter=-1
- bp-activity-oldestpage=1
- _wpnonce_activity_filter: ac9153a759
- scope: course_5674
- filter: -1
Quiz Evaluated (empty but database entries in screenshot):
- bp_ajax_request = http://learndianelee.staging.wpengine.com/wp-admin/admin-ajax.php
- action: activity_widget_filter
- cookie:
- bp--scope=all
- bp-edit-scope=all
- bp-admin-scope=all
- bp-curriculum-scope=all
- bp-activity-scope=course_5674
- bp-activity-filter=quiz_evaluated
- bp-activity-oldestpage=1
- _wpnonce_activity_filter: ac9153a759
- scope: course_5674
- filter: quiz_evaluated
Course Submitted (works):
- bp_ajax_request = http://learndianelee.staging.wpengine.com/wp-admin/admin-ajax.php
- action: activity_widget_filter
- cookie:
- bp--scope=all
- bp-edit-scope=all
- bp-admin-scope=all
- bp-curriculum-scope=all
- bp-activity-scope=course_5674
- bp-activity-filter=submit_course
- bp-activity-oldestpage=1
- _wpnonce_activity_filter: ac9153a759
- scope: course_5674
- filter: submit_course
If I go to mysite.com/activivty the quiz results and assignments show up when using no filters so they are there, seems to be a linkage problem...
- bp_ajax_request = http://learndianelee.staging.wpengine.com/wp-admin/admin-ajax.php
- action: activity_widget_filter
- cookie:
- bp--scope=all
- bp-edit-scope=all
- bp-admin-scope=all
- bp-curriculum-scope=all
- bp-activity-filter=-1
- bp-activity-scope=course
- bp-activity-oldestpage=1
- _wpnonce_activity_filter: ac9153a759
- scope: course
- filter: undefined
Everything is up to date including the latest vibe course module
Here's the query it is sending, the only id used is the course id but quiz_evaluated activities are stored with the quiz id so we may need to bring in another table to make the connection
SELECT DISTINCT a.id
FROM SERVMASK_PREFIX_bp_activity a
WHERE a.component IN ( 'course' )
AND a.type IN ( 'quiz_evaluated' )
AND a.item_id IN ( 5674 )
AND a.is_spam = 0
AND a.hide_sitewide = 0
AND a.type NOT IN ('activity_comment')
ORDER BY a.date_recorded DESC, a.id DESC LIMIT 0, 51
Ok please check if you have the quiz connected to that course in the quiz settings .
refer :
http://prntscr.com/arq5xd
If quiz is not connected to the course then it wont show any activity for the quiz in course .
If quiz is not connected then please connect it to the course and retake the quiz and check for its activity .
If quiz is connected to the course and still activity is not showing then please share your site admin credentials and site url to check this .
PS : mark reply as private while sharing credentials .
Hi Alex, I do have the quiz connected to the course (see attached). I have a plain wplms install with only my database from the live site for testing (password protected).
http://i2gwplms.wpengine.com/
User: i2gwplms Password: cf332783
Admin account User: vibethemes Password: @ZcBtJWXi$n@
Here's a course with 1 quiz
http://i2gwplms.wpengine.com/course/the-series-part-1-support/activity/
Here's one with multiple quizzes
http://i2gwplms.wpengine.com/course/the-series-part-1-prep/activity/
Thanks for the help
Note that the activity is recoded in the Activity table, and the Course should be connected to the quiz when the user submits the quiz. We record the primary id at the time of submission.
If you set the quiz course setting later on it will not change the primary id for the existing quiz submissions.
The activity is also recorded in global activity and I can see the submission activity being recorded which indicates that the course-quiz connection was probably made at a later stage.
screenshot :
http://prntscr.com/as5g4n
Hi Latiyan, the quiz was last modified on January 29th 2016 and it had quiz linkage. I have quiz results as late as April 3rd 2016 that are not showing up.
Where should the linkage be set in the database? Should the item_id column in bp_activity table reflect the course id instead of the quiz id?
Thanks
I checked your site and found no issues with the quiz activity .
Please check :
http://prntscr.com/askuyr
http://prntscr.com/askwkn
Note here that the old activities that are recorded when the quiz was not connected will not show in the quiz related activities .
Seems to be recording with recent updates. Had to update the database manually.
For anyone with the same problem..
in the table wp_bp_activity item_id should be the course id and secondary_item_id should be quiz id.
Here's how I found the entries
SELECT * FROM wp_bp_activity
WHERE type LIKE 'quiz_evaluated' AND secondary_item_id = 0
You can filter further with the Quiz post name:
SELECT * FROM wp_bp_activity
WHERE type LIKE 'quiz_evaluated'
AND content LIKE '%Part 3 Quiz%'
AND secondary_item_id = 0
Then I updated it with SQL
.
