Moodle

After running migration, table layout was altered

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.7.2
  • Fix Version/s: None
  • Component/s: Feedback
  • Labels:
    None
  • Database:
    MySQL
  • Affected Branches:
    MOODLE_17_STABLE

Description

In my production enviornment, some feedback entries in feedback module were trimmed since the 'value' field in 'mdl_feedback_value' table is set to varchar(255).

After investigation, it is found that the data type of this field is ''TEXT' in the original installation scripts (both mysql.sql and install.xml). However, in migrate2utf8.xml, following line is found.

<FIELD name="value" method="PHP_FUNCTION" type="varchar" length="255">

I'm not sure if this is the cause of the problem but I have ever run the migration script in production. In my local, i didn't run the migration and the data type of this field is still 'TEXT'.

In fact, not only this table was affected, but also the mdl_log, mdl_log_display and some other tables.

Activity

Hide
Michael de Raadt added a comment -

Thanks for reporting this issue.

We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.

If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

Michael d;

lqjjLKA0p6

Show
Michael de Raadt added a comment - Thanks for reporting this issue. We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported. If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d; lqjjLKA0p6
Hide
Michael de Raadt added a comment -

I'm closing this issue as it has become inactive and does not appear to affect a current supported version. If you are encountering this problem or one similar, please launch a new issue.

Show
Michael de Raadt added a comment - I'm closing this issue as it has become inactive and does not appear to affect a current supported version. If you are encountering this problem or one similar, please launch a new issue.

People

Vote (1)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: