Differential D9 Diff 203 core/install/upgrades.sql

Changeset View

Standalone View

core/install/upgrades.sql

	Show First 20 Lines • Show All 2902 Lines • ▼ Show 20 Line(s)
	UPDATE LanguageLabels			UPDATE LanguageLabels
	SET l1_ColumnTranslation = 'Not Helpful'			SET l1_ColumnTranslation = 'Not Helpful'
	WHERE PhraseKey = 'LA_FLD_NOTHELPFULCOUNT';			WHERE PhraseKey = 'LA_FLD_NOTHELPFULCOUNT';

	UPDATE LanguageLabels			UPDATE LanguageLabels
	SET Module = 'Core'			SET Module = 'Core'
	WHERE PhraseKey = 'LA_SECTION_FILE';			WHERE PhraseKey = 'LA_SECTION_FILE';

	# ===== v 5.2.1 =====			# ===== v 5.2.1 =====
				alexUnsubmitted Not Done Reply While patch was created the 5.2.1 version was already released, so this needs to be changed to 5.2.2-B1. alex: While patch was created the 5.2.1 version was already released, so this needs to be changed to…

	# ===== v 5.2.2-B1 =====			# ===== v 5.2.2-B1 =====
	UPDATE LanguageLabels			UPDATE LanguageLabels
	SET l1_Translation = 'Incorrect data format, please use {type}'			SET l1_Translation = 'Incorrect data format, please use {type}'
	WHERE PhraseKey = 'LA_ERR_BAD_TYPE';			WHERE PhraseKey = 'LA_ERR_BAD_TYPE';

	UPDATE LanguageLabels			UPDATE LanguageLabels
	SET l1_Translation = 'Field value is out of range, possible values from {min_value} to {max_value}'			SET l1_Translation = 'Field value is out of range, possible values from {min_value} to {max_value}'
	WHERE PhraseKey = 'LA_ERR_VALUE_OUT_OF_RANGE';			WHERE PhraseKey = 'LA_ERR_VALUE_OUT_OF_RANGE';

	UPDATE LanguageLabels			UPDATE LanguageLabels
	SET l1_Translation = 'Field value length is out of range, possible value length from {min_length} to {max_length}'			SET l1_Translation = 'Field value length is out of range, possible value length from {min_length} to {max_length}'
	WHERE PhraseKey = 'LA_ERR_LENGTH_OUT_OF_RANGE';			WHERE PhraseKey = 'LA_ERR_LENGTH_OUT_OF_RANGE';

	ALTER TABLE Themes ADD StylesheetFile VARCHAR( 255 ) NOT NULL DEFAULT '';			ALTER TABLE Themes ADD StylesheetFile VARCHAR( 255 ) NOT NULL DEFAULT '';
	UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced';			UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced';

				UPDATE EmailTemplates
				SET l1_Subject = REPLACE(l1_Subject, "Field name='Username'", 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, "Field name='Username'", 'UserTitle')
				WHERE TemplateName LIKE 'USER%';
				UPDATE EmailTemplates
				SET l1_Subject = REPLACE(l1_Subject, 'Field name="Username"', 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, 'Field name="Username"', 'UserTitle')
				WHERE TemplateName LIKE 'USER%';
				alexUnsubmitted Not Done Reply Please rebase on the latest code, because patch can't be applied cleanly. Looking from the patch there is an SQL error. alex: Please rebase on the latest code, because patch can't be applied cleanly. Looking from the…