Moodle

Drop all TEXT defaults across Moodle

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Duplicate
  • Affects Version/s: 1.9
  • Fix Version/s: 1.9
  • Component/s: Database SQL/XMLDB
  • Labels:
    None
  • Environment:
    PostgreSQL and MySQL
  • Database:
    MySQL, PostgreSQL
  • Affected Branches:
    MOODLE_19_STABLE
  • Fixed Branches:
    MOODLE_19_STABLE

Description

Starting from Moodle 1.7 we are installing all the TEXT fields without defaults. That's OK.

But some old installations will contain some defaults under such type of columns. The idea is to iterate over all the fields of this type in Moodle, dropping the default clause if present.

Needed for MySQL and PostgreSQL (there weren't other flavours before 1.7)

Ciao

Issue Links

This issue duplicates:
MDL-6218 MySQL - TEXT and BLOB columns can't have a default value Minor Closed

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Penny Leach added a comment -

Eloy - is there a good programmatical way to find all such fields with XMLDB or does it involve looking through a database/schema ?

Show
Penny Leach added a comment - Eloy - is there a good programmatical way to find all such fields with XMLDB or does it involve looking through a database/schema ?
Hide
Permalink
Eloy Lafuente (stronk7) added a comment -

I think it's introspecting DB. Something like the:

[Check indexes] or [Check bigints] tests currently in XMLDB editor.

Show
Eloy Lafuente (stronk7) added a comment - I think it's introspecting DB. Something like the: [Check indexes] or [Check bigints] tests currently in XMLDB editor.
Hide
Permalink
Eloy Lafuente (stronk7) added a comment -

This bug really sounded me a lot, so I've performed some searches in the tracker and have found that it was addressed and fixed in bugs like MDL-6218 and MDL-9530.

So I really think we are free from TEXT columns containing DEFAULTs.

Show
Eloy Lafuente (stronk7) added a comment - This bug really sounded me a lot, so I've performed some searches in the tracker and have found that it was addressed and fixed in bugs like MDL-6218 and MDL-9530. So I really think we are free from TEXT columns containing DEFAULTs.

People

Vote (0)
Watch (0)

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.