Index: trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql =================================================================== diff -u -N -r8049 -r8051 --- trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql (.../inportal_upgrade_v4.0.2.sql) (revision 8049) +++ trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql (.../inportal_upgrade_v4.0.2.sql) (revision 8051) @@ -32,4 +32,7 @@ ALTER TABLE UserSession CHANGE SessionKey SessionKey INT UNSIGNED NULL DEFAULT NULL, CHANGE CurrentTempKey CurrentTempKey INT UNSIGNED NULL DEFAULT NULL, CHANGE PrevTempKey PrevTempKey INT UNSIGNED NULL DEFAULT NULL, CHANGE LastAccessed LastAccessed INT UNSIGNED NOT NULL DEFAULT '0', CHANGE PortalUserId PortalUserId INT(11) NOT NULL DEFAULT '-2', CHANGE Language Language INT(11) NOT NULL DEFAULT '1', CHANGE Theme Theme INT(11) NOT NULL DEFAULT '1'; +UPDATE Phrase SET Translation = REPLACE(Translation, CHAR(146), "'"); +UPDATE Phrase SET Translation = REPLACE(Translation, CONCAT(CHAR(97), CHAR(128), CHAR(153)), "'"); + UPDATE Modules SET Version = '4.0.2' WHERE Name = 'In-Portal'; \ No newline at end of file