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.

Tim Hunt made changes - 06/Jan/09 02:20 PM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
tjhunt committed 6 files to 'Moodle CVS' - 06/Jan/09 02:20 PM
question bank database: MDL-17608 Drop originalquestion field from the question_states table - it was never used for anything.
MODIFY question/restorelib.php   Rev. 1.40    (+1 -12 lines)
MODIFY version.php   Rev. 1.947    (+1 -1 lines)
MODIFY question/backuplib.php   Rev. 1.23    (+1 -2 lines)
MODIFY mod/quiz/restorelibpre15.php   Rev. 1.32    (+1 -8 lines)
MODIFY lib/db/install.xml   Rev. 1.182    (+3 -4 lines)
MODIFY lib/db/upgrade.php   Rev. 1.259    (+16 -1 lines)
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.