Issue Details (XML | Word | Printable)

Key: MDL-17608
Type: Task Task
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Tim Hunt
Reporter: Tim Hunt
Votes: 0
Watchers: 2
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Drop originalquestion field from the question_states table

Created: 12/Dec/08 12:15 AM   Updated: 09/Jan/09 12:30 PM
Return to search
Component/s: Questions
Affects Version/s: 1.9.3
Fix Version/s: 2.0

Participants: Dan Poltawski, Jonathan Newman and Tim Hunt
Security Level: None
Resolved date: 06/Jan/09
Affected Branches: MOODLE_19_STABLE
Fixed Branches: MOODLE_20_STABLE


 Description  « Hide
It is a legacy of an aborted attempt to introduce question versioning. It is just a waste of space.

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Tim Hunt added a comment - 05/Jan/09 04:38 PM
Dan, or anyone else who manages a lot of Moodle sites, would you be able to run the query

SELECT * FROM mdl_question_states WHERE originalquestion <> 0;

against a number of real sites to help confirm that the originalquestion field was really never used, before I drop it. Thanks.


Dan Poltawski added a comment - 05/Jan/09 06:01 PM
Tim, there are no rows using this field in any of my 712 moodles.

Tim Hunt added a comment - 06/Jan/09 10:18 AM
Thanks Dan. Very reassuring.

Jonathan Newman added a comment - 09/Jan/09 12:30 PM
Tim, I sampled about 25% of our Moodle sites and the query showed no results.