XML Courses get put back into the course overviews table even though they have been retired

Description

When the XML courses got retired we removed them from the course_overviews_courseoverview table. The understanding was that they would not get put back in unless an editing trigger happened which populated the table. However it looks like something else is populating this table with them even though no modulestore can serve them. The code should be updated to not add a course to the course_overviews_courseoverview table unless it can be found in one of the modulestores.

can you please look at this ASAP. Students are seeing courses on their dashboard that give them a 404 when they try to go to them.

Steps to Reproduce

None

Current Behavior

None

Expected Behavior

None

Reason for Variance

None

Release Notes

None

User Impact Summary

None

Activity

Show:
Feanil Patel
October 19, 2015, 1:43 PM

XML courses are usually on disk, the way we remove them is to remove them from disk and remove them form the MixedModulestore list of XML courses.

hrazaR
October 19, 2015, 1:13 PM

, what does mean by retired ? if its means deleting the course how could we delete an xml course ?

Adam Palay
October 9, 2015, 1:04 PM

here's one on prod: https://courses.edx.org/courses/MITx/6.00x/2013_Spring/info

The problem is that these are ending up in the CourseOverview table even though they're not in the modulestore.

It might be good to check how many courses are in the Overview table but aren't in the modulestore. can you check that? Or , is there a discrepancy between the amount of items in the Overview vs coursestructure tables?

hrazaR
October 9, 2015, 12:58 PM

can you tell example of such course mention in description !?

LeslieG
October 8, 2015, 3:30 PM

TNL already has a large backlog of CAT-2s that the team is already working on. Can it wait until your team can pick it up? Or can I help you prioritize CAT-2s on your side so that you can take this on ASAP?

Not Reproducible

Assignee

hrazaR

Reporter

Feanil Patel

Labels

Reach

None

Impact

None

Platform Area

None

Customer

None

Partner Manager

None

URL

None

Contributor Name

None

Groups with Read-Only Access

None

Actual Points

None

Category of Work

None

Platform Map Area (Levels 1 & 2)

None

Platform Map Area (Levels 3 & 4)

None

Priority

CAT-2