Moodle

Drop originalquestion field from the question_states table

Details

  • Type: Task Task
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.9.3
  • Fix Version/s: 2.0
  • Component/s: Questions
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE
  • Fixed Branches:
    MOODLE_20_STABLE

Description

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

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Tim Hunt added a comment -

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.

Show
Tim Hunt added a comment - 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.
Hide
Permalink
Dan Poltawski added a comment -

Tim, there are no rows using this field in any of my 712 moodles.

Show
Dan Poltawski added a comment - Tim, there are no rows using this field in any of my 712 moodles.
Hide
Permalink
Tim Hunt added a comment -

Thanks Dan. Very reassuring.

Show
Tim Hunt added a comment - Thanks Dan. Very reassuring.
Hide
Permalink
Jonathan Newman added a comment -

Tim, I sampled about 25% of our Moodle sites and the query showed no results.

Show
Jonathan Newman added a comment - Tim, I sampled about 25% of our Moodle sites and the query showed no results.

People

Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.