Feature #6088

Set Spanish as parent language for Quechua

Added by Yannick Warnier almost 7 years ago. Updated over 4 years ago.

Bug resolved
Installation / Migration
Target version:
Start date:
Due date:
% Done:


Estimated time:
SCRUM pts - complexity:


During install and update, make sure Spanish is set as a parent language for Quechua, Basque (Euskera), Galician, Asturian and Catalan.
This way, all these languages will default to Spanish when a term is not translated (instead of English).

This is slightly complicated, as there is an AUTO_INCREMENT on the column and we don't know in advance (not formally) the ID of the Spanish language before inserting it (and Asturian comes before Spanish).
This requires a series of UPDATE based on the ID of "Spanish" in the language table in db_main.sql, + a series of UPDATE in the update_db script.

Related issues

Related to Chamilo LMS - Bug #6713: Missing features in Chamilo v2New19/09/2013


Associated revisions

Revision 04716510 (diff)
Added by Yannick Warnier over 4 years ago

Minor improvement of previous db migration script to set parent languages - refs #6088



Updated by Yannick Warnier over 4 years ago

  • Status changed from New to Needs more info
  • Assignee set to Julio Montoya
  • Target version changed from 2.0 to 1.10.0
  • % Done changed from 0 to 70

Added in and checked. Everything seems fine, although the query is based on a fixed ID for the main languages, so it might generate problems for old installations, but usually this should be solved by the fact that languages should be complete.

I have added a note to the changelog to mention that, but to avoid the issue I would need to update the Version20150504....php to query for the language ID before doing the update, and I'm not sure how I must do that.


Updated by Yannick Warnier over 4 years ago

  • Status changed from Needs more info to Assigned

Updated by Yannick Warnier over 4 years ago

  • Status changed from Assigned to Bug resolved
  • Assignee changed from Julio Montoya to Yannick Warnier
  • % Done changed from 70 to 100

Found an example somewhere else and fixed previous migratoin

Also available in: Atom PDF