Skip to content

Instantly share code, notes, and snippets.

@takeit
Created September 12, 2014 07:38
Show Gist options
  • Save takeit/35a8ebd5104e84e572ce to your computer and use it in GitHub Desktop.
Save takeit/35a8ebd5104e84e572ce to your computer and use it in GitHub Desktop.
upgrade errors newscoop 4.2->4.3
UPDATE `Languages` SET `RFC3066bis` = "de-DE" WHERE `Code` = "de"
UPDATE `Languages` SET `RFC3066bis` = "pt-PT" WHERE `Code` = "pt"
UPDATE `Languages` SET `RFC3066bis` = "fr-FR" WHERE `Code` = "fr"
UPDATE `Languages` SET `RFC3066bis` = "es-ES" WHERE `Code` = "es"
UPDATE `Languages` SET `RFC3066bis` = "ro-RO" WHERE `Code` = "ro"
UPDATE `Languages` SET `RFC3066bis` = "hr-HR" WHERE `Code` = "hr"
UPDATE `Languages` SET `RFC3066bis` = "cs-CZ" WHERE `Code` = "cs"
UPDATE `Languages` SET `RFC3066bis` = "it-IT" WHERE `Code` = "it"
UPDATE `Languages` SET `RFC3066bis` = "sr-Latn-SR" WHERE `Code` = "sh"
UPDATE `Languages` SET `RFC3066bis` = "sr-Cyrl-SR" WHERE `Code` = "sr"
UPDATE `Languages` SET `RFC3066bis` = "ru-RU" WHERE `Code` = "ru"
UPDATE `Languages` SET `RFC3066bis` = "sv-SE" WHERE `Code` = "sv"
UPDATE `Languages` SET `RFC3066bis` = "zh-Hans" WHERE `Code` = "zh"
UPDATE `Languages` SET `RFC3066bis` = "ar-YE" WHERE `Code` = "ar"
UPDATE `Languages` SET `RFC3066bis` = "ko-KR" WHERE `Code` = "ko"
UPDATE `Languages` SET `RFC3066bis` = "nl-NL" WHERE `Code` = "nl"
UPDATE `Languages` SET `RFC3066bis` = "be-BY" WHERE `Code` = "be"
UPDATE `Languages` SET `RFC3066bis` = "ka-GE" WHERE `Code` = "ka"
UPDATE `Languages` SET `RFC3066bis` = "zh-Hant" WHERE `Code` = "zh_TW"
UPDATE `Languages` SET `RFC3066bis` = "pl-PL" WHERE `Code` = "pl"
UPDATE `Languages` SET `RFC3066bis` = "el-GR" WHERE `Code` = "el"
UPDATE `Languages` SET `RFC3066bis` = "he-IL" WHERE `Code` = "he"
UPDATE `Languages` SET `RFC3066bis` = "bn-BD" WHERE `Code` = "bn"
UPDATE `Languages` SET `RFC3066bis` = "pt-BR" WHERE `Code` = "pt_BR"
UPDATE `Languages` SET `RFC3066bis` = "sq-AL" WHERE `Code` = "sq"
UPDATE `Languages` SET `RFC3066bis` = "tr-TR" WHERE `Code` = "tr"
UPDATE `Languages` SET `RFC3066bis` = "uk-UA" WHERE `Code` = "uk"
UPDATE `Languages` SET `RFC3066bis` = "en-GB" WHERE `Code` = "en_GB"
UPDATE `Languages` SET `RFC3066bis` = "ku-TR" WHERE `Code` = "ku"
UPDATE `Languages` SET `RFC3066bis` = "de-AT" WHERE `Code` = "de_AT";
INSERT IGNORE INTO `Languages`(`Name`, `CodePage`, `OrigName`, `Code`, `RFC3066bis`, `Month1`, `Month2`, `Month3`, `Month4`, `Month5`, `Month6`, `Month7`, `Month8`, `Month9`, `Month10`, `Month11`, `Month12`, `WDay1`, `WDay2`, `WDay3`, `WDay4`, `WDay5`, `WDay6`, `WDay7`, `ShortMonth1`, `ShortMonth2`, `ShortMonth3`, `ShortMonth4`, `ShortMonth5`, `ShortMonth6`, `ShortMonth7`, `ShortMonth8`, `ShortMonth9`, `ShortMonth10`, `ShortMonth11`, `ShortMonth12`, `ShortWDay1`, `ShortWDay2`, `ShortWDay3`, `ShortWDay4`, `ShortWDay5`, `ShortWDay6`, `ShortWDay7`) VALUES ('Hungarian', 'ISO_8859-2', 'Magyar', 'hu', 'hu-HU', 'Január', 'Február', 'Március', 'Április', 'Május', 'Június', 'Július', 'Augusztus', 'Szeptember', 'Október', 'November', 'December', 'Vasárnap', 'Hétfő', 'Kedd', 'Szerda', 'Csütörtök', 'Péntek', 'Szombat', 'Jan', 'Feb', 'Már', 'Ápr', 'Május', 'Jún', 'Júl', 'Aug', 'Szep', 'Okt', 'Nov', 'Dec', 'Va', 'Hé', 'Ke', 'Sze', 'Cs', 'Pé', 'Szu')
INSERT IGNORE INTO `Languages`(`Name`, `CodePage`, `OrigName`, `Code`, `RFC3066bis`, `Month1`, `Month2`, `Month3`, `Month4`, `Month5`, `Month6`, `Month7`, `Month8`, `Month9`, `Month10`, `Month11`, `Month12`, `WDay1`, `WDay2`, `WDay3`, `WDay4`, `WDay5`, `WDay6`, `WDay7`, `ShortMonth1`, `ShortMonth2`, `ShortMonth3`, `ShortMonth4`, `ShortMonth5`, `ShortMonth6`, `ShortMonth7`, `ShortMonth8`, `ShortMonth9`, `ShortMonth10`, `ShortMonth11`, `ShortMonth12`, `ShortWDay1`, `ShortWDay2`, `ShortWDay3`, `ShortWDay4`, `ShortWDay5`, `ShortWDay6`, `ShortWDay7`) VALUES ('Azerbaijani', 'ISO_8859-9', 'Azərbaycanca', 'az', 'az', 'Yanvar', 'Fevral', 'Mart', 'Aprel', 'May', 'İyun', 'İyul', 'Avqust', 'Sentyabr', 'Oktyabr', 'Noyabr', 'Dekabr', 'Bazar', 'Bazar ertəsi', 'Çərşənbə axşamı', 'Çərşənbə', 'Cümə axşamı', 'Cümə', 'Şənbə', 'Yanvar', 'Fevral', 'Mart', 'Aprel', 'May', 'İyun', 'İyul', 'Avqust', 'Sentyabr', 'Oktyabr', 'Noyabr', 'Dekabr', 'B', 'B.e', 'Ç.a', 'Ç', 'Ca', 'C', 'Ş');
INSERT IGNORE INTO `Languages` (`Name`, `CodePage`, `OrigName`, `Code`, `RFC3066bis`, `Month1`, `Month2`, `Month3`, `Month4`, `Month5`, `Month6`, `Month7`, `Month8`, `Month9`, `Month10`, `Month11`, `Month12`, `WDay1`, `WDay2`, `WDay3`, `WDay4`, `WDay5`, `WDay6`, `WDay7`, `ShortMonth1`, `ShortMonth2`, `ShortMonth3`, `ShortMonth4`, `ShortMonth5`, `ShortMonth6`, `ShortMonth7`, `ShortMonth8`, `ShortMonth9`, `ShortMonth10`, `ShortMonth11`, `ShortMonth12`, `ShortWDay1`, `ShortWDay2`, `ShortWDay3`, `ShortWDay4`, `ShortWDay5`, `ShortWDay6`, `ShortWDay7`) VALUES ('Danish', 'ISO_8859-1', 'Dansk', 'da', 'da', 'Januar', 'Februar', 'Marts', 'April', 'Maj', 'Juni', 'Juli', 'August', 'September', 'Oktober', 'November', 'December', 'Søndag', 'Mandag', 'Tirsdag', 'Onsdag', 'Torsdag', 'Fredag', 'Lørdag', 'Jan', 'Feb', 'Mar', 'Apr', 'Maj', 'Jun', 'Jul', 'Aug', 'Sep', 'Okt', 'Nov', 'Dec', 'Søn', 'Man', 'Tir', 'Ons', 'Tor', 'Fre', 'Lør')
INSERT IGNORE INTO `Languages` (`Name`, `CodePage`, `OrigName`, `Code`, `RFC3066bis`, `Month1`, `Month2`, `Month3`, `Month4`, `Month5`, `Month6`, `Month7`, `Month8`, `Month9`, `Month10`, `Month11`, `Month12`, `WDay1`, `WDay2`, `WDay3`, `WDay4`, `WDay5`, `WDay6`, `WDay7`, `ShortMonth1`, `ShortMonth2`, `ShortMonth3`, `ShortMonth4`, `ShortMonth5`, `ShortMonth6`, `ShortMonth7`, `ShortMonth8`, `ShortMonth9`, `ShortMonth10`, `ShortMonth11`, `ShortMonth12`, `ShortWDay1`, `ShortWDay2`, `ShortWDay3`, `ShortWDay4`, `ShortWDay5`, `ShortWDay6`, `ShortWDay7`) VALUES ('Armenian', 'UTF-8', 'Հայերեն', 'hy_AM', 'hy-AM', 'Հունվար', 'Փետրվար', 'Մարտ', 'Ապրիլ', 'Մայիս', 'Հունիս', 'Հուլիս', 'Օգոստոս', 'Սեպտեմբեր', 'Հոկտեմբեր', 'Նոյեմբեր', 'Դեկտեմբեր', 'Կիրակի', 'Երկուշաբթի', 'Երեքշաբթի', 'Չորեքշաբթի', 'Հինգշաբթի', 'ՈՒրբաթ', 'Շաբաթ', 'Հունվ', 'Փետր', 'Մարտ', 'Ապր', 'Մայ', 'Հուն', 'Հուլ', 'Օգոս', 'Սեպ', 'Հոկտ', 'Նոյ', 'Դեկ', 'Կիր', 'Երկ', 'Երք', 'Չոր', 'Հնգ', 'ՈՒր', 'Շաբ');
ALTER TABLE `ArticleImageCaptions` CHANGE `caption` `caption` text COLLATE 'utf8_general_ci' NOT NULL DEFAULT ''
ALTER TABLE `Images` CHANGE `Description` `Description` text COLLATE 'utf8_general_ci' NOT NULL DEFAULT ''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment