The Elearning Community

On upgrade i got following error , please help ,

Upgrade database error
Upgrading to version: 1.2
Result: ERROR !!!

Upgrade db with file: /public_html/mysite/upgrade/data/upg_data/10200_db.sqlCannot add or update a child row: a foreign key constraint fails (`saurabhj_ifsdocebo`.`core_lang_translation`, CONSTRAINT `core_lang_translation_ibfk_1` FOREIGN KEY (`lang_code`) REFERENCES `core_lang_language` (`lang_code`) ON DELETE CASCADE ON UPDATE CASC)
------

Hi sachintholia,
The db error you received in the upgrade procedure is raised beacause the DB upgrade procedure try to insert new key and language trnaslation for "english" and you, probably, does not load it .

To avoid the error you can follow one of these steps
a) Load english language translation in your database before run the upgrade
b) or, modify the DB update script commenting out the INSERT statement of "english translation" .

Here attached you can find the sql script with INSERT commented out . replace the content of your upgrade folder