Changeset View
Changeset View
Standalone View
Standalone View
core/install/upgrades.sql
Context not available. | |||||
CHANGE SSLUrl SSLDomainName VARCHAR(255) NOT NULL DEFAULT '', | CHANGE SSLUrl SSLDomainName VARCHAR(255) NOT NULL DEFAULT '', | ||||
CHANGE SSLUrlUsesRegExp SSLDomainNameUsesRegExp TINYINT(4) NOT NULL DEFAULT '0'; | CHANGE SSLUrlUsesRegExp SSLDomainNameUsesRegExp TINYINT(4) NOT NULL DEFAULT '0'; | ||||
DELETE FROM UserPersistentSessionData WHERE VariableName = 'site-domain[Default]columns_.'; | DELETE FROM UserPersistentSessionData WHERE VariableName = 'site-domain[Default]columns_.'; | ||||
UPDATE SystemSettings | |||||
SET VariableName = 'NotFoundErrorTemplate' | |||||
WHERE VariableName = 'ErrorTemplate'; | |||||
alex: Several more issues with this:
# If a variable is renamed in `upgrades.sql` then it have no… | |||||
UPDATE SystemSettings | |||||
SET DisplayOrder = ROUND(DisplayOrder + 0.01, 2) | |||||
Not Done ReplyThe DisplayOrder column value (the 10.04 in above SQL) should be unique across same configuration group. Right now it exactly matches value of NoPermissionTemplate system setting. You need to:
I usually use SQL similar to this to shift up/down system settings in particular sub-group: UPDATE SystemSettings SET DisplayOrder = ROUND(DisplayOrder + 0.01, 2) WHERE Section = 'x' and Heading = 'y' AND DisplayOrder > z alex: The `DisplayOrder` column value (the `10.04` in above SQL) should be unique across same… | |||||
Not Done ReplyJust noticed that used label doesn't match system setting name and should be la_config_ FatalErrorTemplate. You can see on screenshot above that two system settings have identical translation. alex: Just noticed that used label doesn't match system setting name and should be `la_config_… | |||||
WHERE Section = 'in-portal:configure_advanced' and Heading = 'la_section_SettingsWebsite' AND DisplayOrder > 10.04; | |||||
INSERT INTO SystemSettings VALUES (DEFAULT, 'FatalErrorTemplate', 'error_fatal', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsWebsite', 'la_config_FatalErrorTemplate', 'text', '', '', 10.05, 0, 0, null); | |||||
Context not available. |
Several more issues with this: