Issue Details (XML | Word | Printable)

Key: MDL-12642
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Eloy Lafuente (stronk7)
Reporter: Edith Lin
Votes: 1
Watchers: 2
Operations

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

After running migration, table layout was altered

Created: 19/Dec/07 04:27 PM   Updated: 19/Dec/07 04:27 PM
Return to search
Component/s: Database SQL/XMLDB
Affects Version/s: 1.7.2
Fix Version/s: None

Database: MySQL
Participants: Edith Lin and Eloy Lafuente (stronk7)
Security Level: None
Affected Branches: MOODLE_17_STABLE


 Description  « Hide
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.


 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
No commits have yet been performed on this issue.